Runnig multiple SQL statment in DB2 stage

[murur]

I have to implement the following scenario,

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

[ray.wurlod]

I'd recommend separate DataStage jobs for each step. The results of Step 1 are stored in a file (text file, hashed file, doesn't really matter) which becomes the input for Step 4 and Step 5. You didn't specify what Step 2 and Step 3 do, it may be needed there too.
Wrap a job sequence around the lot, so that everything depends on successful execution of Step 1, and there you have it.