Informix Error Messages and Error Codes From Error 351 to 355


Informix Error Code -351 Database contains tables owned by other users.
This DROP DATABASE or UPDATE STATISTICS statement cannot be carried out for the reason shown. It might destroy the work of others. In order to drop this database, you must first drop all tables that other users own. To do so, you must have database administrator privilege. See the discussion of error -313 for a way to list the names of all tables with their owners.
Informix Error Code -352 Column column-name not found.
The column, or one of the columns, named in this CREATE INDEX statement does not exist. Review the spellings of all columns in the statement. See the discussion of error -328 for a way to list all column names in a table.

Informix Error Code -353 No table or view specified when granting/revoking privileges.
This statement specifies one of the table-level privileges (ALTER, DELETE, INDEX, INSERT, SELECT, UPDATE, and ALL) but does not specify the table to which the privilege applies. When you grant or revoke a database-level privilege (CONNECT, DBA, RESOURCE), you can not name a table, but when you grant or revoke a table-level privilege you must name a table.

Informix Error Code -354 Incorrect database or cursor name format.
This statement contains the name of a database or a cursor in some improper format. If the statement is part of a program, the name may have been passed in a host variable. Database names should be no longer than 10 characters for INFORMIX-SE (less in some host operating systems) and no longer than 18 characters for other Informix database servers. Cursor names must not exceed 18 characters.
Both database and cursor names must begin with a letter and contain only letters, numbers, and underscore characters. For Version 6.0 and later, database and cursor names can begin with an underscore.
In DOS systems, filenames can be a maximum of 8 characters plus a 3-character extension.
Informix Error Code -355 Cannot rename file for table.
This RENAME statement cannot be completed because the database server got an unexpected error. Check the accompanying ISAM error code for more detailed information on the cause. Possible causes include hardware errors and file-permission problems.

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 *