sqlerrd

The system array VGVar.sqlerrd is a 6-element array, where each element contains the corresponding SQL communication area (SQLCA) value that was returned from the last SQL I/O option. The value in VGVar.sqlerrd[3], for example, is the third value and indicates the number of rows processed for some SQL requests.

Of the elements in VGVar.sqlerrd, only VGVar.sqlerrd[3] is refreshed by the database management system for Java™ code or at debugging time.

You can use a VGVar.sqlerrd element in these ways:

The characteristics of each element in the VGVar.sqlerrd array are as follows:
Primitive type
BIN
Data length
9
Is value always restored after a converse?
Only in a non-segmented text program; for details see Segmentation

Example

  myItem = VGVar.sqlerrd[3];
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.