sysVar.sqlerrmc

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

sysVar.sqlerrmc has no meaning for the JDBC environment.

You can use sysVar.sqlerrmc in these ways:

• As the source in an assignment or move statement

• As a variable in a logical expression

• As the argument in an exit or return statement

The characteristics of sysVar.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 = sysVar.sqlerrmc;

Related concepts
Segmentation in text applications
SQL support

Related reference
File and database (system words)
sysVar.sqlca