running cl at before subroutine

talbl · Post by **talbl** » Wed Aug 19, 2009 4:42 am

hi

i am trying to run a cl in the properties of the job at the before subroutine
after 20 min the job aborted but the cl is still running and i am getting this messege "status = 97 (Stopped by operator)"
can anyone tell me why?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 19, 2009 4:49 am

Can you put that in simple English please. Too cryptic for me.

Also provide more information on what you are doing.

talbl · Post by **talbl** » Wed Aug 19, 2009 5:05 am

i am trying to run an external program by datastage .
this external program is called cl (as400) . i place the command that runs the external program at the datastage jog at the db2 connect stage at the sql before . the external program is running but the datastage is falling with the message i gave.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 19, 2009 5:51 am

What is the returnCode from the cl ?

chulett · Post by **chulett** » Wed Aug 19, 2009 7:09 am

If it's not SQL then that's not the place to be running it. Sounds like you need to run it before job rather than before sql.

DSXchange

running cl at before subroutine

running cl at before subroutine

as400 cl