Informix Error Messages and Error Codes From Error 23741 to 23745

SQLServerF1

Informix Error Code -23741 CREATE EXTERNAL TABLE: Invalid value for keyword.
The CREATE EXTERNAL TABLE statement (or SELECT…INTO EXTERNAL statement) contains an invalid value for one of the USING clause keywords.
Review the statement to see if the value of the keyword is misspelled. For the MAXERRORS keyword, make sure the value is a valid number.

Informix Error Code -23742 CREATE EXTERNAL TABLE: Invalid DATAFILES entry.
A DATAFILES entry does not have the correct format. The format for an entry is filetype:coserver-info:rooted-path-name.
Check that the file type is a valid type (DISK or PIPE), that the second item names a cogroup or a coserver number, and that the last item names a file that can be accessed by the coserver that manages it.

Informix Error Code -23743 CREATE EXTERNAL TABLE: Missing DATAFILE entries.
The DATAFILES entry in the CREATE EXTERNAL TABLE statement (or SELECT…INTO EXTERNAL statement) is missing. Add a DATAFILES entry and reissue the statement.
Informix Error Code -23744 CREATE EXTERNAL TABLE: Cannot use SAMEAS for FIXED format tables.
The CREATE EXTERNAL TABLE statement does not allow SAMEAS for FIXED format tables. The column entries must also define an external type to describe how to access (or write) the data in the fixed file.
Revise the CREATE EXTERNAL TABLE statement to enumerate the column information and reissue the statement.
Informix Error Code -23745 CREATE EXTERNAL TABLE: Internal column types must be defined column-name.
The CREATE EXTERNAL TABLE statement requires a column type for each column enumerated in the statement.
Revise the statement. Add the appropriate column type and then reissue the statement.

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 *