Informix Error Messages and Error Codes From Error 703 to 709

SQLServerF1

Informix Error Code -703 Primary key on table table-name has a field with a null key value.
An attempt was made either to insert a null value into a column that is part of a primary key, or to add a primary constraint to a table that has a NULL value in one of the key columns.
Informix Error Code -704 Primary key already exists on the table.
A table can have only one primary key.

Informix Error Code -705 Cannot drop/modify procedure procedure-name. It is currently in use.
An attempt was made either to drop a currently executing procedure or to run UPDATE STATISTICS on a currently running procedure. This condition can occur if a procedure tries to drop itself or if a nested procedure tries to drop a procedure that called it.
Example of error:
CREATE PROCEDURE testproc() … DROP PROCEDURE testproc; — error END PROCEDURE
Correction: You can use an ON EXCEPTION statement to trap this error and not carry out the DROP PROCEDURE or UPDATE STATISTICS statement.
This error also occurs if you try to drop a function or procedure that a functional index is using.
Informix Error Code -706 Execute privilege denied on procedure procedure-name.
A user who does not own the procedure or is not DBA must have Execute privilege in order to run a procedure.

Informix Error Code -707 TEXT and BYTE columns in optical cluster must be distinct.
The same column is specified more than once in the column list of the FOR clause in the CREATE OPTICAL CLUSTER statement. Change your statement so that no column appears more than once.
Informix Error Code -708 Optical cluster cluster-name already exists.
You have attempted to create a new optical cluster with the name of an existing cluster. You must either drop the existing cluster or re-execute your statement using a different cluster name.
Informix Error Code -709 TEXT and BYTE column column-name is already clustered.
You have already created an optical cluster using the named column. Because a single column can be part of only one optical cluster, your attempt to create a new cluster on this column has failed.

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.

Thanks,
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 *