Sqlca reason-code

Dev Shed Forums Sponsor:

Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!

May 30th, 2006, 04:36 PM

needlottahelp

Registered User

Join Date: May 2006

Posts: 1

Time spent in forums: 43 m 48 sec
Reputation Power: 0

Sqlca reason-code

Hello,

I am new to database development in general. I am using db2 v8.2 and was trying to decipher the sqlcode reason-code. I am working in error recovery so I need to be able to read these reason-codes when an error happens (if they exist) to determine what I need to do to recover (if anything).

From what I have found so far it looks like the reason-code is placed in sqlca->sqlerrmc. Can anyone verify that?

sqlerrmc is a VARCHAR (70) and I see some references such as : "sqlerrmc VARCHAR (70) Contains one or more tokens, separated by X'FF', which are substituted for variables in the descriptions of error conditions. "

In the minimal amount of sqlcodes I am seeing so far that have a reason-code, I am not seeing the X'FF' stated above...and I am not seeing the expected reason-code for that sqlcode either.

BTW, this is in code and without using any db2 api's to display. I am trying to determine how to best extract the reason-code from the sqlerrmc (if that is where it is). Does anyone have any information on this?

Thanks

June 1st, 2006, 10:39 AM

Randux

Contributing User

Join Date: May 2006

Posts: 48

Time spent in forums: 18 h 47 m 23 sec
Reputation Power: 6

I don't have the manuals in front of me. There is a callable service that returns a formatted error message based on an input sqlca. Check the Programmer's Guide for details.

June 14th, 2006, 11:00 AM

OS2dude

Registered User

Join Date: Jun 2006

Posts: 3

Time spent in forums: 29 m 4 sec
Reputation Power: 0

Getting SQLDA diagnostic data

According to the DB2 manual, the way you get diagnostic info is by calling GET DIAGNOSTICS. Here is a bit of code to help. The Token String is what contains the values seperated by '0xFF'. You can look up the function in the SQL book for more details.

(BTW, you don't NEED all the variables. I was trying to track a problem and dumped as much as I thought might be remotely useful.)

RPG Embedded SQL Code:

Original - RPG Embedded SQL Code


D dasqlcode       S             10I 0        
D datokencnt      S             10I 0        
D datoken1        S          32740A   VARYING
D datoken2        S          32740A   VARYING
D datoken3        S          32740A   VARYING
D datoken4        S          32740A   VARYING
D datoken5        S          32740A   VARYING
D datokenstr      S             70A   VARYING
D dasqlerrdid     S             10A          
D dasqlerrd1b     S              7A   VARYING
D dasqlerrd2b     S              7A   VARYING
D damsgtext       S          32740A   VARYING

C/EXEC SQL                                  
C+ GET CURRENT DIAGNOSTICS CONDITION 1      
C+     :dasqlcode   = DB2_RETURNED_SQLCODE, 
C+     :datokencnt  = DB2_TOKEN_COUNT,      
C+     :datoken1    = DB2_ORDINAL_TOKEN_1,  
C+     :datoken2    = DB2_ORDINAL_TOKEN_2,  
C+     :datoken3    = DB2_ORDINAL_TOKEN_3,  
C+     :datoken4    = DB2_ORDINAL_TOKEN_4,  
C+     :datoken5    = DB2_ORDINAL_TOKEN_5,  
C+     :datokenstr  = DB2_TOKEN_STRING,     
C+     :dasqlerrdid = DB2_MESSAGE_ID,       
C+     :dasqlerrd1b = DB2_MESSAGE_ID1,      
C+     :dasqlerrd2b = DB2_MESSAGE_ID2,      
C+     :damsgtext   = MESSAGE_TEXT          
C/END-EXEC

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: