Informix Error Messages and Error Codes From Error 555 to 558


Informix Error Code -555 Cannot use a select or any of the database statements in a multi-query prepare.
The statement text that is presented with this PREPARE statement has multiple statements divided by semicolons, and one is a SELECT, DATABASE, CREATE DATABASE, or CLOSE DATABASE statement. These statements must always be prepared as one-statement texts. Check the statement text string, and make sure that you intended multiple statements. If you did, revise the program to execute these four statement types alone.
Informix Error Code -556 Cannot create, drop, or modify an object on an another database server.
This statement attempts to create, drop, or alter an object in an external database, one other than the current database. You can only read the contents of an external database. If you make the database your current database, you can modify the contents. Review all uses of names beginning dbname, which refer to objects in the external database dbname.

Informix Error Code -557 Cannot locate table on another server after level-count levels of synonym mapping.
One of the tables named in this query was in fact a synonym, and it pointed outside the current database. It named another synonym that pointed outside its database, and so on for count synonyms with no real table being found. The database server has given up on the query in case an endless chain of synonyms exists. To review the synonyms in the current database that refer to external databases, query systables and syssyntable as follows:
SELECT T.tabname synonym, servername, dbname, user, S.tabname
FROM systables T, syssyntable S WHERE T.tabtype = ‘S’ AND T.tabid = S.tabid AND S.btabid IS NULL

To follow a chain of synonyms through external databases, use a similar query in the external database, and substitute for servername, dbname, and tabname the values that the preceding query returns each time.
SELECT T.tabname synonym, servername, dbname, user, S.tabname
FROM dbname@servername:systables T, dbname@servername:syssyntable S WHERE T.tabtype = ‘S’ AND T.tabname = ‘tabname’ AND T.tabid = S.tabid
When this query returns no row, the requested tabname is not defined as a synonym in that database (it is a table or view or not defined).
Informix Error Code -558 Changrp not found in $INFORMIXDIR/bin. Consult your installation instructions.
This command requires the presence of an executable program named changrp, which is normally installed as part of the database server. It should be in the bin subdirectory of the directory that INFORMIXDIR environment variable names. Check the value in that variable, and then consult with the person who installed the software.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *