1) Step 1: select list of emp_no from <TABLE1>
...
....
...
n) Last Step : I have to run multiple SQL statment against various
tables in one database in DB2 Stage (using DB2/UDB API plug in)
Ex:
insert into <TABLE2> VALUES (emp_no,......)
delete from <TABLE4> where emp_no = <list of EmpNo selected in step1>
delete from <TABLE5> where emp_no = <list of EmpNo selected in step1>
Question is : What are all option I have to implement the above scenario.
(As per standard I shouldn't create any DB procedure, all code should reside in DataStage job only).
Thank you,
Muru
![Smile :)](./images/smilies/icon_smile.gif)