Informix Error Messages and Error Codes From Error 510 to 516


Informix Error Code -510 Cannot create synonym for temporary table table-name.
This CREATE SYNONYM statement cannot be executed because the specified table is temporary. Review the spelling of the table name. If it is as you intended, redesign the application. Either make the table permanent, or do not use a synonym.
Informix Error Code -511 Cannot modify system catalog table-name.
You are not allowed to update, insert, or delete rows in this table. If you are absolutely sure that you must do so, sign on as user informix. That user account can modify most system-catalog tables. However, this very risky practice is not recommended unless you are specifically instructed by Informix Technical Support.

Informix Error Code -512 No References privilege on the referenced columns.
You do not have References privilege on the referenced columns. The owner of the referenced table or a user who has References privilege with the grant option on that table can grant you this privilege using the GRANT statement.
Informix Error Code -513 Statement not available with this database server.
You cannot do an xa_open() execution if another database is already open. Make sure that you have closed any open databases before executing xa_open().

Informix Error Code -514 Only DBA can create, drop, or grant for another user.
This data definition statement specifies a table, view, index, or synonym that is owned by another user or grants a privilege as another user. Any of these things requires Database Administrator privilege, which you do not have on this database. If you intended to work on objects that you own, review the punctuation of the statement. At some point in it, you have qualified a name with the user ID of another account. Otherwise, get a DBA to grant you DBA privilege or to perform this operation for you.
Informix Error Code -515 Constraint constraint-name has already been dropped.
You are trying to drop a constraint that has already been dropped in the same ALTER TABLE statement.
Informix Error Code -516 System error – temporary output file not created yet.
This internal error indicates a problem in the communication between the database server and the library functions that call it. Check that your program is at the same software level as the database server in use. If the error recurs, please note all circumstances and contact Informix Technical Support.

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 *