err_get()

Returns the text corresponding to an error number.

Syntax

err_get(
   messageId INTEGER ) 
  RETURNS STRING
  1. messageId is a runtime error or an Informix® SQL error.

Usage

The err_get() function returns the error message corresponding to the number passed as parameter. This can be a Genero BDL error (like -6324), or an IBM® Informix SQL error message.

Important: IBM Informix SQL message numbers can only be supported, if the program is connected to an Informix database, and an SQL error occurred just before calling this function. Do not use this function in the context of SQL execution, when using different type of database servers.