Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions

 

ERRORMSG function [Miscellaneous]

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

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

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

SELECT ERRORMSG( -813 );