RUNSQLSTM Monitor

["Smith, Dave" <DSmith@xxxxxxxxx>]

I have one CLP using runsqlstm and it just does a 

MONMSG     MSGID(SQL9010) EXEC(GOTO CMDLBL(ERROR))

 

I try to run all my SQL from SQLRPGLE programs where it becomes easier
to monitor for specific messages.

 

David J. Smith

IT Contractor

dsmith@xxxxxxxxx

517.546.5400 Ext: 1513

 

-----Original Message-----

Subject: RUNSQLSTM Monitor

 

How does one monitor for errors when using RUNSQLSTM? I have member

containing a couple of DROP INDEX statements. The process blows up if

the specified index isn't found. I know I can do a DLTF in CL and

monitor for the appropriate message, but I'd like to be able to do this

in SQL.

 

TIA...

-- 

  

  michaelr_41@xxxxxxxxxxxxxx