SQL Query on Hash File
Posted: Tue Apr 15, 2003 9:28 am
Another one of my dumb questions. 
Can we run SQL type queries on normal DataStage hash file ?
Since I have very large hash files and opening them through Data Stage designer often freezes my client which results in locked jobs.
So presently I have to do all this through ETL jobs to filter out the records that I want since another limitation of the designer is that it only allows for one find condition.
Can we run SQL type queries on normal DataStage hash file ?
Since I have very large hash files and opening them through Data Stage designer often freezes my client which results in locked jobs.
So presently I have to do all this through ETL jobs to filter out the records that I want since another limitation of the designer is that it only allows for one find condition.