Informix Error Messages and Error Codes From Error 675 to 680

SQLServerF1

Informix Error Code -675 Illegal SQL statement in stored procedure.
A restricted statement was executed in a procedure. This error occurs when a procedure is called from an SQL data manipulation statement.
Example of error:
CREATE PROCEDURE testproc (arg INT, id INT) RETURNING INT;
UPDATE tab SET col = arg WHERE key = id; — error RETURN id; END PROCEDURE;
SELECT col FROM tab WHERE testproc(tab.col, tab.key) = 10;
Correction: Do not use a restricted statement (such as the preceding UPDATE statement).
Informix Error Code -676 Invalid check constraint column.
A check constraint that is specified at the column level can reference only that column. To specify a check constraint that spans more than one column, specify the check constraint at the table level. You cannot create a check constraint for columns across tables.

Informix Error Code -677 Check constraint cannot contain subqueries or procedures.
A check constraint cannot have subqueries or procedure calls.
Informix Error Code -678 Invalid subscript for column column-name in check constraint.
A subscripted column in a check constraint has subscripts outside the bounds of the column. Check that the bounds specified in the subscripted column do not exceed the maximum length of the column. If you know the table name of the column, use the following subquery to query the system-catalog tables to find out the maximum length of the column:
SELECT collength FROM syscolumns WHERE colname = ‘column-name’
AND tabid = (SELECT tabid FROM systables WHERE tabname = ‘table-name’)

Informix Error Code -679 Cannot read constraint violation data for constraint constraint-name.
See the ISAM error for more information. If this internal error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -680 Cannot write constraint violation data for constraint constraint-name.
See the ISAM error for more information. If this internal 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.

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 *