To insert SQL Error text message in Audit Log Table..

rahul.arora · New User Joined: 09 Jul 2011 Posts: 9 Location: India

I made a program to perform insert/delete on a table(main table)...My program also write a log for the operations (insert/delete) performed on this this table in another table(audit log table)...
The program write the log for every successful or failed operation performed on main table in audit log table...I have one field in my audit log table in which i want to move the reason of failure of the operation, if the operation will fail for main table..

I know the reason for sqlcodes like -503 , +100 , -803 ...But i want to insert reason for every SQL code possible...

Is there any variable in SQLCA , from where i can insert the sql error text message into the table..??
Or there is any other way to do it ?

Akatsukami · Posted: Sat Sep 24, 2011 1:24 am

I shall refrain from commenting on the utility of this, and merely point you to DSNTIAR.

rahul.arora · New User Joined: 09 Jul 2011 Posts: 9 Location: India

Thanks alot..It works..

Akatsukami · Posted: Wed Nov 16, 2011 2:38 am

You're welcome.