Informix Error Messages and Error Codes From Error 389 to 395


Informix Error Code -389 No DBA permission.
This statement cannot be executed because your account has not been granted DBA privilege to this database. Contact a person who has DBA privilege to the database and ask to be granted DBA privileges to it (or simply ask to have this statement executed for you).
Informix Error Code -390 Synonym already used as table name or synonym.
This CREATE SYNONYM statement names a synonym that is already in use. To see all the synonym and table names currently defined, query systables as follows:
SELECT tabname, owner FROM systables WHERE tabid > 99

Informix Error Code -391 Cannot insert a null into column column-name.
This statement tries to put a null value in the noted column. However, that column has been defined as NOT NULL. Roll back the current transaction. If this is a program, review the definition of the table, and change the program logic to not use null values for columns that cannot accept them.
Informix Error Code -392 System error – unexpected null pointer encountered.
This internal error should not occur. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -393 A condition in the where clause results in a two-sided outer join.
This query requests an outer join, but one or more conditions in the WHERE clause interfere with the dominant-subservient relationship. Review the query to ensure that every condition that relates two tables is actually necessary.

Informix Error Code -394 View view-name not found.
The named view cannot be dropped as it does not exist. To see names of existing views, query systables as follows:
SELECT tabname FROM systables WHERE tabtype = ‘V’
Informix Error Code -395 The where clause contains an outer cartesian product.
This query requests an outer join, but the WHERE clause is written so as to imply selecting every row of the subservient table for every row of the dominant table, resulting in a very large output. Review the query, and check that at least one condition relates each preserved-subservient pair of tables in the query.

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 *