Sometimes, when a stored procedure fails and return a negative SQLCODE error (< 0 ), this procedure automatically shuts down (STOPs) and doesn’t work until you execute the instrucction –START PROCEDURE xxxxxx.
Does anybody know a way to avoid this situation. Is possible restart automatically the procedure?

Also I’m looking for invoke the db2 command prompt from a stored procedure. I’ve tried with DSNWLI, buy It hasn’t worked as I expected (I my case, only works out of stored procedure)

Any ideas

Thanks in advance,

(we are using DB2 6.1)