MQSeries.net :: View topic - Wrong SQLCODE/SQLSTATE using the indicator in V2.1

samuel_lee2000 · Posted: Thu Apr 25, 2002 2:36 am Post subject:

Platform used : WMQI v2.1 CSD2 on Windows 2000

We're trying to use the database indicators to get the error information.
But we're getting the wrong SQLCODE and SQLSTATE. Have anyone tried the new feature successfully ? Is there any special steps we need to do ?
Thanks for any advice !!

Here is our ESQL code fragment :
-------------------------------------------------------------------------
DECLARE SQLState1 CHARACTER;
DECLARE SQLCode1 INTEGER;

SET OutputRoot.XML.DB.Result[] = (SELECT ITEM T.EMPNOX FROM Database.db2admin.EMPLOYEE AS T);

SET SQLState1 = SQLSTATE;
SET SQLCode1 = SQLCODE;

IF SQLCode1 <> 0 THEN
THROW USER EXCEPTION MESSAGE 2950 VALUES ('The SQL State', SQLState1, SQLCode1);
END IF;
-------------------------------------------------------------------------
We've unchecked the "Throw database on Database exception" in the Advanced tab of the Compute Node.

The expected result should be SQLCODE = -206 and SQLSTATE = 42703
Because we can see the following in the trace file ExceptionList :
[IBM][CLI Driver][DB2/NT] SQL0206N "T.EMPNOX" is not valid in the context where it is used. SQLSTATE=42703

However, what we actually get using the indicator is :
SQLSTATE = 42S22
SQLCODE = -1

Using the MQSI trace, we know that the SQLSTATE indicator get resolved to 42S22
and SQLCODE indicator get resolved to -1 by MQSI. So is it WMQI is passing the wrong value back ?

[ This Message was edited by: samuel_lee2000 on 2002-04-25 03:37 ]