Page 1 of 1

getting parameters from two different files

Posted: Fri Mar 18, 2005 9:34 am
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

Posted: Fri Mar 18, 2005 5:09 pm
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

Posted: Mon Mar 21, 2005 9:13 am
by srikie
Thanks Mike, but my situation is different anyway I guess I have 2 go with creating an additional job option.