The finderr utility

Use the finderr utility to view additional information on Informix® error messages. On UNIX and Linux platforms, the information appears on the command line. On Windows platforms, the information appears in the Error Messages program.


Read syntax diagramSkip visual syntax diagram
            .- - .                 
            '- + '                 

Table 1. finderr element
Element Purpose Key Considerations
error_number The error message number for which to provide additional information On UNIX or Linux: If you do not include a minus sign (-) or plus sign (+) and both a positive and a negative version of the error message exists, the negative version of the message is displayed. To display the information about an error message number that is positive, preface the error number with a plus sign.

On Windows: If you do not include a minus sign or plus sign and both a positive and a negative version of the error message exists, you must choose which message you want to view in the Error Messages program.


Error messages that are printed in the message log include a message number and a short message description. Use the message number with the finderr command to look up a more detailed description of the cause of the error and possible user actions to correct or prevent the error.

On Windows, you can open the Error Messages program directly by choosing Error Messages from the database server program group.


The following command on a UNIX or Linux platform displays information about the error message -201:

finderr 201

-201	 A syntax error has occurred.

This general error message indicates mistakes in the form of an SQL
statement. Look for missing or extra punctuation (such as missing or
extra commas, omission of parentheses around a subquery, and so on),
keywords misspelled (such as VALEUS for VALUES), keywords misused (such
as SET in an INSERT statement or INTO in a subquery), keywords out of
sequence (such as a condition of "value IS NOT" instead of "NOT value
IS"), or a reserved word used as an identifier.

Database servers that provide full NIST compliance do not reserve any
words; queries that work with these database servers might fail and
return error -201 when they are used with earlier versions of IBM Informix
database servers.

The cause of this error might be an attempt to use round-robin syntax with
CREATE INDEX or ALTER FRAGMENT INIT on an index. You cannot use round-robin

The error may also occur if an SQL statement uses double quotation marks 
around input strings and the environment variable DELIMIDENT is set. 
If DELIMIDENT is set, strings that are surrounded by double quotation 
marks are regarded as SQL identifiers rather than string literals. For 
more information on the usage of DELIMIDENT, see the IBM Informix Guide to 
SQL: Reference.

The following command displays information about the error message 100, which corresponds to the SQLCODE value of 100:

finderr +100

100	No matching records found.

The database server did not find any more data. This message is an ANSI-
standard SQLCODE value. If you attempted to select or fetch data, you
encountered the end of the data, or no data matched the criteria in the
WHERE clause. Check for an empty table. Use this SQLCODE value to determine
when a statement reaches the end of the data. For more information, see the
discussion of SQLCODE in the IBM Informix ESQL/C Programmer's Manual. The
database server can return this SQLCODE value to a running program.
For the High-Performance Loader (HPL), this message can indicate that the
map might be from a project other than the default project. Use the -p option
in the onpload command line to provide a project name for mappings.

Copyright© 2018 HCL Technologies Limited