sqlState

The system variable SysVar.sqlState contains the SQL state value for the most recently completed SQL I/O operation. The code is obtained from the SQL communications area (SQLCA) and can vary with the relational database manager.

You can use SysVar.sqlState in these ways:
The characteristics of SysVar.sqlState are as follows:
Primitive type
CHAR
Data length
5
Is value always restored after a converse?
Only in a non-segmented text program; for details see Segmentation

Example

  rcitem = SysVar.sqlState;
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.