Opening a table with Basic Code
Posted: Fri Dec 29, 2006 11:32 am
Hi all
is it possible to code in Data stage basic to open a table and use a select statement to read the values with where clause and assign the read values from the table as paramters to the subsequent Jobs in the basic code.
I couldn't find any DS statements in helping me do this. one way i am thinking of doing this is write a small job which reads the required data from the table and put in a sequential file. then i guess i can call this job in my basic code and open the formed sequential file, read the values and set the parameters for my subsequent jobs accordingly.
is there any better way of doing this...
Any help will be really great
Thanks
Pavan
is it possible to code in Data stage basic to open a table and use a select statement to read the values with where clause and assign the read values from the table as paramters to the subsequent Jobs in the basic code.
I couldn't find any DS statements in helping me do this. one way i am thinking of doing this is write a small job which reads the required data from the table and put in a sequential file. then i guess i can call this job in my basic code and open the formed sequential file, read the values and set the parameters for my subsequent jobs accordingly.
is there any better way of doing this...
Any help will be really great
Thanks
Pavan