getting parameters from two different files

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
srikie
Participant
Posts: 58
Joined: Thu Oct 14, 2004 4:19 pm

getting parameters from two different files

Post by srikie »

Hi,
I would like to know if it is possible to get parameters from two different files. As, we could only specify one file name in job properties-parameters.
I am using Data Stage mvs 7.5
Thanks
srikie
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

No, you only get one job parameter file and only one record in that file (with as many columns as you care to define). These will be your job parameters.

Options:
1) You can create a job to generate a single parameter file out of your multiple files.

2) You can use one as a parameter file, and do a conditional lookup on the second file (where the condition is to only do the lookup for the first record). Mainframe jobs have a conditional lookup :) .

Mike
srikie
Participant
Posts: 58
Joined: Thu Oct 14, 2004 4:19 pm

Post by srikie »

Thanks Mike, but my situation is different anyway I guess I have 2 go with creating an additional job option.
Post Reply