DB2 V8 Z/OS: I tried to insert an already existing row into a table and i
received an SQLCODE -803 (SQLCA). That is ok. When calling GET DIAGNOSTICS, the
columns returned for STATEMENT INORMATION remained empty. The same for the
colums of the "condition Information".<br />
<br />
Any idea?<br />
<br />
EXEC SQL <br />
GET DIAGNOSTICS <br />
:LAST_ROW = DB2_LAST_ROW, <br />
:NUMBER_PARAMETER_MARKERS = DB2_NUMBER_PARAMETER_MARKERS, <br />
:NUMBER_RESULT_SETS = DB2_NUMBER_RESULT_SETS, <br />
:NUMBER_ROWS = DB2_NUMBER_ROWS, <br />
:RETURN_STATUS = DB2_RETURN_STATUS, <br />
:SQL_ATTR_CURSOR_HOLD = DB2_SQL_ATTR_CURSOR_HOLD, <br />
:SQL_ATTR_CURSOR_ROWSET = DB2_SQL_ATTR_CURSOR_ROWSET, <br />
:SQL_ATTR_CURSOR_SCROLLABLE = DB2_SQL_ATTR_CURSOR_SCROLLABLE, <br />
:SQL_ATTR_CURSOR_SENSITIVITY = DB2_SQL_ATTR_CURSOR_SENSITIVITY,<br />
:SQL_ATTR_CURSOR_TYPE = DB2_SQL_ATTR_CURSOR_TYPE, <br />
:MORE = MORE, <br />
:GETDIAGNOSTICS_NUMBER = NUMBER, <br />
:ROW_COUNT = ROW_COUNT; <br />
<br />
EXEC SQL <br />
GET DIAGNOSTICS CONDITION 1<br />
:CATALOG_NAME = CATALOG_NAME, <br />
:CONDITION_NUMBER = CONDITION_NUMBER, <br />
:CURSOR_NAME = CURSOR_NAME, <br />
:ERROR_CODE1 = DB2_ERROR_CODE1, <br />
:ERROR_CODE2 = DB2_ERROR_CODE2, <br />
:ERROR_CODE3 = DB2_ERROR_CODE3, <br />
:ERROR_CODE4 = DB2_ERROR_CODE4, <br />
:INTERNAL_ERROR_POINTER = DB2_INTERNAL_ERROR_POINTER, <br />
:MESSAGE_ID = DB2_MESSAGE_ID, <br />
:MODULE_DETECTING_ERROR = DB2_MODULE_DETECTING_ERROR, <br />
:REASON_CODE = DB2_REASON_CODE, <br />
:RETURNED_SQLCODE = DB2_RETURNED_SQLCODE, <br />
:ROW_NUMBER = DB2_ROW_NUMBER, <br />
:TOKEN_COUNT = DB2_TOKEN_COUNT, <br />
:MESSAGE_TEXT = MESSAGE_TEXT, <br />
:RETURNED_SQLSTATE = RETURNED_SQLSTATE, <br />
|
In article
<1503563982.1205231212023.JavaMail.wassrvr@ltsgwas010.sby.ibm.com>,
georg.thaler@raiffeisen.it says...
> DB2 V8 Z/OS: I tried to insert an already existing row into a table
> and i received an SQLCODE -803 (SQLCA). That is ok. When calling GET
> DIAGNOSTICS, the columns returned for STATEMENT INORMATION remained
> empty. The same for the colums of the "condition Information".
>
> Any idea?
>
There's loads of APARs for GET DIAGNOSTICS on R810. Open APAR PK62521
could be your problem.
Call your local IBM support centre and open a new PMR. We need to take a
deeper look at your problem.
--
Dougie Lawson
UKISA Software Support
|