sqlerrmc

The system variable VGVar.sqlerrmc contains the error message associated with the return code in SysVar.sqlcode. VGVar.sqlerrmc is obtained from the SQL communications area (SQLCA) and can vary with the relational database manager.

VGVar.sqlerrmc has no meaning for the JDBC environment.

You can use VGVar.sqlerrmc in these ways:

The characteristics of VGVar.sqlerrmc are as follows
Primitive type
CHAR
Data length
70
Is value always restored after a converse?
Only in a non-segmented text program; for details see Segmentation

Example

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