Informix Error Messages and Error Codes From Error 47087 to 47093

SQLServerF1

Informix Error Code -47087 Cannot specify null default value when column doesn’t accept nulls.
Select a different (nonnull) default value for the column, or modify the column to accept null values.
Informix Error Code -47088 Cannot specify server or site as a default value with this column type.
You cannot specify a default value that consists of the current database server name or current site name for a column that is not a CHAR, NCHAR, VARCHAR, or NVARCHAR data type. Change the column data type (if permitted), or specify a different default value.

Informix Error Code -47089 Cannot specify server or site as a default value with this column length.
For specifying a default value that consists of the current database server name or current site name for a CHAR, NCHAR, VARCHAR, or NVARCHAR column, the minimum column length must be 18. Increase the column length, or specify a different default value.
Informix Error Code -47090 Cannot specify today as a default value with this column type.
You cannot specify a default value that consists of the current system date for a column when the column data type is not DATE. Change the column data type (if permitted), or specify a different default value.

Informix Error Code -47091 Cannot specify user as a default value with this column type.
You cannot specify a default value that consists of the login name of the current user for a column that is not a CHAR, NCHAR, VARCHAR, or NVARCHAR data type. Change the column data type (if permitted), or specify a different default value.
Informix Error Code -47092 Cannot specify user as a default value with this column length.
In order to specify a default value that consists of the login name of the current user for a CHAR, NCHAR, VARCHAR, or NVARCHAR column, the minimum column length must be 8. Increase the column length, or specify a different default value.
Informix Error Code -47093 Cannot create unique or primary key constraint with column type of BYTE or TEXT.
In order to create a primary or unique constraint on the column, change the column data type from TEXT or BYTE, if permitted.

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 *