SQL Query on Hash File

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
datastagedummy
Participant
Posts: 56
Joined: Thu Feb 13, 2003 6:08 pm
Location: USA

SQL Query on Hash File

Post by datastagedummy »

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.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Basically, the answer is "yes". Access the hash file using a Universe stage and you'll be able to do SQL against it.

-craig
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”