DB2 Data Types for GET DIAGNOSTICS Items Returning Statement Information

The data types for the GET DIAGNOSTICS items that return statement information. The various GET DIAGNOSTIC statements can provide useful and informative information for application communication.

Item	Description	Data Type
DB2_GET_DIAGNOSTICS _DIAGNOSTICS	After a GET DIAGNOSTICS statement, if any error or warning occurred, contains all the diagnostics as a single string	VARCHAR (32672)
DB2_LAST_ROW	After a multiple-row FETCH statement, contains a value of +100 if the last row in the table is in the row set that was returned.	INTEGER
DB2_NUMBER_PARAMETER_MARKERS	After a PREPARE statement, contains the number of parameter markers in the prepared statement.	INTEGER
DB2_NUMBER_RESULT_SETS	After a CALL statement that invokes a stored procedure, contains the number of result sets that are returned by the procedure.	INTEGER
DB2_NUMBER_ROWS	After an OPEN or FETCH statement for which the size of the result table is known, contains the number of rows in the result table. After a PREPARE statement, this item contains the estimated number of rows in the result table for the prepared statement. For SENSITIVE DYNAMIC cursors, this item contains the approximate number of rows.	DECIMAL (31,0)
DB2_RETURN_STATUS	After a CALL statement that invokes an SQL procedure, contains the return status if the procedure contains a RETURN statement.	INTEGER
DB2_SQL_ATTR _CURSOR_HOLD	After an ALLOCATE or OPEN statement, indicates whether the cursor can be held CHAR(1) open across multiple units of work (Y or N).	CHAR(1)
DB2_SQL_ATTR _CURSOR_ROWSET	After an ALLOCATE or OPEN statement, indicates whether the cursor can use row set positioning (Y or N).	CHAR(1)
DB2_SQL_ATTR _CURSOR_SCROLLABLE	After an ALLOCATE or OPEN statement, indicates whether the cursor is scrollable (Y or N).	CHAR(1)
DB2_SQL_ATTR _CURSOR_SENSITIVITY	After an ALLOCATE or OPEN statement, indicates whether the cursor shows updates made by other processes (sensitivity A, I, or S).	CHAR(1)
DB2_SQL_ATTR _CURSOR_TYPE	After an ALLOCATE or OPEN statement, indicates whether the cursor is declared static (S for INSENSITIVE or SENSITIVE STATIC) or dynamic (D for SENSITIVE DYNAMIC).	CHAR(1)
MORE	After any SQL statement, indicates whether some condition items were discarded because of insufficient storage (Y or N).	CHAR(1)
NUMBER	After any SQL statement, contains the number of condition items. If no warning or error occurred or if no previous SQL statement has been executed, the number 1 is returned.	INTEGER
ROW_COUNT	After DELETE, INSERT, UPDATE, or FETCH, contains the number of rows deleted, inserted, updated, or fetched. After PREPARE, contains the estimated number of result rows in the prepared statement.	DECIMAL (31,0)

Created with Artisteer