Several files for only one 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
auvray.muriel
Participant
Posts: 43
Joined: Wed Feb 19, 2003 7:17 am
Location: France - Paris
Contact:

Several files for only one job

Post by auvray.muriel »

Hello,

I have several files sequentiels in a repertory, and a job which treats the whole of the files of the repertory.

Each one of these files contain a first recording different from the others (cutting different).

I must recover information in the first line of each file. I make a test:

If @INROWNUM = 1 then I recover the value in the first line, and I store it in a stage variable.

This test functions for the first file, but as soon as the job treats the following files of the repertory, variable @INROWNUM is not re-initialized, and my test does not go any more.

Somebody have a solution?

One spoke to me about the columns generator, but I do not know how to count the lines with this stage.

Thank you very much
Post Reply