Library functions for retrieving error messages
Each SQLCODE value has an associated message. Error message files in the $ONEDB_HOME/msg directory store the message number and its text.
When you use SQLCODE and
the sqlca structure, you can retrieve error message text with
the rgetlmsg() and rgetmsg() functions.
Both of these functions take the SQLCODE error code as input
and return the associated error message.
Tip: When you
use SQLSTATE and the GET DIAGNOSTICS statement, you can access
information in the MESSAGE_TEXT field of the diagnostics area
to retrieve the message text that is associated with an exception.
Important: Use rgetlmsg() in any new code
that you write. provides
the rgetmsg() function primarily for compatibility
with earlier versions.