Error-handling

[Naiyanad Ohpanayikool <naiyanad.ohpanayikool@ACCENTURE.COM>]

Hello,

I want to do error-handling in SQR when there is an error such as no table
/ column in the database after generating a report, and insert status of
the job as "error", is this possible? I noticed that once there's an error,
the program will stop and throw SQL error. Can we make SQR go to update the
table with the status before stopping the program? I tried "on-error"
command in begin-select but that doesn't work.

Merry Christmas to you all.

Nai



This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete the
original.  Any other use of the email by you is prohibited.