IBM App Connect Enterprise 12.0.12.0 Operating Systems: AIX, Linux, Windows

ESQL database state functions

ESQL provides four functions to return database state. These are:

SQLCODE function
SQLERRORTEXT function
SQLNATIVEERROR function
SQLSTATE function

SQLCODE function
SQLCODE is a database state function that returns an INTEGER data type with a default value of 0 (zero).
SQLERRORTEXT function
SQLERRORTEXT is a database state function that returns a CHARACTER data type with a default value of '' (empty string).
SQLNATIVEERROR function
SQLNATIVEERROR is a database state function that returns an INTEGER data type with a default value of 0 (zero).
SQLSTATE function
SQLSTATE is a database state function that returns a 5 character data type of CHARACTER with a default value of '00000' (five zeros as a string).

Parent topic: ESQL functions