View previous topic :: View next topic
|
Author |
Message |
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 ? |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
I shall refrain from commenting on the utility of this, and merely point you to DSNTIAR. |
|
Back to top |
|
|
rahul.arora
New User
Joined: 09 Jul 2011 Posts: 9 Location: India
|
|
|
|
Thanks alot..It works.. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
You're welcome. |
|
Back to top |
|
|
|