ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ERRORMSG function [Miscellaneous]

Function 

Provides the error message for the current error, or for a specified SQLSTATE or SQLCODE value.

Syntax 

ERRORMSG ( [ sqlstate | sqlcode ] )

sqlstate: string

sqlcode: integer

Parameters 

sqlstate    The SQLSTATE value for which the error message is to be returned.

sqlcode    The SQLCODE value for which the error message is to be returned.

Return value 

A string 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).

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.

See also 

Error messages indexed by SQLSTATE

Error messages indexed by Adaptive Server Anywhere SQLCODE

Example 

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

select errormsg( -813 )