ERRORMSG(  [ sqlstate | sqlcode ] )

sqlstate: string

sqlcode: integer

VARCHAR containing the error message.

If no argument is supplied, the error message for the current state is supplied. Any substitutions (such as table names and column names) are made.

If an argument is supplied, the error message for the supplied SQLSTATE or SQLCODE is returned, with no substitutions. Table names and column names are supplied as placeholders (%1).

• SQL Anywhere error messages sorted by SQLSTATE
• SQL Anywhere error messages sorted by SQLCODE

The following statement returns the error message for SQLCODE -813.

SELECT ERRORMSG( -813 );