Reading a seq file mult times in same job

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
deep
Participant
Posts: 30
Joined: Fri Dec 12, 2003 9:06 am

Reading a seq file mult times in same job

Post by deep »

Hi All

1.Is it safe to read from the same SEQUENTIAL file multiple times in the same job.
2.Can diffrent jobs read from the same SEQUENTIAL file at the same time.
3.Is it safe to read from the same HASH file multiple times in the same job.
4.Can diffrent jobs read from the same HASH file at the same time.

Thanks
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

YES
YES
YES
YES

Writing is a whole other topic. But, keep in mind that hash reads have the ability to be LOCKED reads, so avoid that and you're completely safe and performance won't suffer.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply