Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| 00000 | Warning | 2000 | 0L | No message | This code indicates that there was no error or warning. Click here for a list of possible parameters and odbc states. |
| 00002 | Warning | 20023 | 1009002L | " Index %2: Starting Insert Pass 2. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 00003 | Warning | 20024 | 1009003L | " Index %1: Thread %2 Inserting %3 Recs, %4 Secs." | No additional information available. Click here for a list of possible parameters and odbc states. |
| 00A00 | Warning | 20570 | 1013000L | "*** BlockSize: %2, Block size: Record size: %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 00A01 | Warning | 20571 | 1013001L | "*** Record size: variable, Block size: %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 00A13 | Warning | 21024 | 1010013L | "IQ cannot support the %1 connections requested by the server.\nRestart the server with -gm %2 on the command line." | Inform the DBA about the number of connection Click here for a list of possible parameters and odbc states. |
| 00A15 | Warning | 20585 | 1013015L | "Row Delimiter: %1" | This is the ROW DELIMITER used for the LOAD. Click here for a list of possible parameters and odbc states. |
| 00A31 | Warning | 20691 | 1000031L | "Join Index '%1' created from the following join relations:" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 00A32 | Warning | 20692 | 1000032L | "The ultimate/top table is %1\n" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 00A34 | Warning | 20694 | 1000034L | " Table Name Relationship" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 00A36 | Warning | 20696 | 1000036L | "%1. %2 joined to '%3' %4" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 00A37 | Warning | 20697 | 1000037L | "------------------------------------------------------------------" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 00A68 | Warning | 20728 | 1000068L | "The '%1' join index is in use for table '%2'." | This is an informational message. Click here for a list of possible parameters and odbc states. |
| 00A80 | Warning | 20740 | 1000080L | "Join index %1 already synchronized." | The join index is already synchronized. Click here for a list of possible parameters and odbc states. |
| 00A93 | Warning | 20985 | 1013093L | "Insert started: %1\n" | This is an informational message displayed during insert. Click here for a list of possible parameters and odbc states. |
| 00B09 | Warning | 20769 | 1000109L | "For table %1, join index %2 was modified. %3 rows were deleted." | Informational message regarding rows deleted from a table. Click here for a list of possible parameters and odbc states. |
| 00B17 | Warning | 20777 | 1000117L | "The data to be inserted into table '%2', column '%1' cannot be converted to the datatype of the column. NULL will be inserted if the column allows NULLs." | The database option CONVERSION_ERROR has been set to 'OFF' for this INSERT. The data to be inserted to the named column cannot be converted to the datatype of that column. If the column allows NULL, then NULL will be inserted instead. Click here for a list of possible parameters and odbc states. |
| 00B19 | Warning | 20779 | 1000119L | "The data to be inserted into table '%2', column `%1' from row %3 of the select results cannot be converted to the datatype of the destination column. NULL will be inserted if the column allows NULLs." | The database option CONVERSION_ERROR has been set to 'OFF' for this INSERT...SELECT. During INSERT...SELECT, the data to be inserted to one of the columns cannot be converted to the datatype of that column. If the column allows NULL, then NULL will be inserted instead. Click here for a list of possible parameters and odbc states. |
| 00B22 | Warning | 20782 | 1000122L | "The data to update table '%2', column `%1' cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs." | The database option CONVERSION_ERROR has been set to 'OFF' for this UPDATE. During UPDATE, the data to update one of the columns cannot be converted to the datatype of the column. The update number represents the number of updates made to the table which is not necessarily the row number of the table being updated. The column will be updated with NULL if the column definition allows NULLs. Click here for a list of possible parameters and odbc states. |
| 00B59 | Warning | 20819 | 1000159L | "\nIn table '%1', the %2 width insert of %3 columns will begin at record %4." | Informational message displayed during insert. Click here for a list of possible parameters and odbc states. |