sqlca

The system variable SysVar.sqlca contains the entire SQL communication area (SQLCA). As noted later, the current values of a subset of fields in the SQLCA are available to you after your code accesses a relational database.

You can use SysVar.sqlca in these ways:

In order to refer to specific fields in the SQLCA, you must move SysVar.sqlca to a base record. The record must have a structure as specified in the SQLCA description for your database management system. Use the base record if you pass the SQLCA contents to a remote program so that the contents will be converted correctly to the remote system data format.

For specific information about the fields that are available in SysVar.sqlca, refer to the following topics:
The characteristics of SysVar.sqlca are as follows:
Primitive type
HEX
Data length
272 (136 bytes)
Is value always restored after a converse?
Only in a non-segmented text program; for details see Segmentation

Example

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