Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1000227L | Error | 20997 | QDC37 | "Cannot load data with both BINARY and delimited columns. %1" | You cannot load data with both BINARY and delimited columns in the same LOAD command. Click here for a list of possible parameters and odbc states. |
| -1000228L | Error | 20888 | QDC28 | "JP4&5" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000229L | Warning | 20889 | 01C29 | "%1 records were inserted and %2 records were rejected for %3 tables \nfor join index '%4'.\n" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000229L | Error | 20998 | QDC38 | "Only BINARY [WITH NULL BYTE] can be used as a column specification when using UNLOAD FORMAT. %1" | When using UNLOAD FORMAT, you cannot specify any column specification other than BINARY. If need to load null values for a column using the BINARY column spec, you must specify the WITH NULL BYTE option. You cannot use the [ROW] DELIMITED BY options with UNLOAD FORMAT. Click here for a list of possible parameters and odbc states. |
| 1000230L | Warning | 20890 | 01C30 | "\nInsert for '%1',\n completed in %2 seconds." | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000230L | Error | 20999 | QDC39 | "Columns that allow nulls must use the WITH NULL BYTE option. %1" | The user must use the WITH NULL BYTE option for a BINARY column spec for columns that allow nulls. Click here for a list of possible parameters and odbc states. |
| -1000231L | Error | 20891 | QDC31 | "You do not have permission to create join index %2%3%4. %1" | A user can only create a join index under the following conditions 1) They are the DBA account 2) They have DBA authority. 3) They did not specify a creator and have RESOURCE authority 4) The specified creator is the same as the current user and they have RESOURCE authority. Click here for a list of possible parameters and odbc states. |
| -1000232L | Error | 20892 | QDC32 | "Partial input record skipped at EOF. %1" | A partial input record was detected during a 'load' operation. This can occur as a result of an OS/hardware error or simply because the input data file was missing values for one or more columns in the table. Click here for a list of possible parameters and odbc states. |
| -1000233L | Error | 20893 | QDC33 | "Cannot SYNCHRONIZE join index %2. %1" | The requested SYNCHRONIZE operation for the named join index failed because not all read-write locks could be obtained for all tables and related joins/tables in the join indexes' transitive closure. Try the SYNCHRONIZE operation later when there are no access conflicts with other users. Click here for a list of possible parameters and odbc states. |
| 1000234L | Warning | 20894 | 01C34 | "\nInsert into table '%1', %2 rows rejected (in all)." | This is an informational message displayed in context with other messages. During the LOAD, some records were rejected. Click here for a list of possible parameters and odbc states. |
| -1000234L | Error | 21000 | QDC40 | "The record size of the unloaded data: %2, does not match the record size of the load: %3. %1" | The record size of the unloaded data does not match the size of the record described by the LOAD command. Click here for a list of possible parameters and odbc states. |
| 1000235L | Warning | 20895 | 00C35 | "%3 Pass %1 completed in %2 seconds." | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000235L | Error | 21001 | QDC42 | "The total number of columns of unloaded data: %2, does not match the total number of columns in the load: %3. %1" | The total number of columns in the unloaded data does not match the number of columns in the LOAD command. Click here for a list of possible parameters and odbc states. |
| 1000236L | Warning | 20896 | 01C36 | "%4 for '%1' completed in %2 seconds. %3 rows %5." | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000236L | Error | 21002 | QDC43 | "The total number of null columns in the unloaded data, %2, does not match the total number of null columns in the LOAD command, %3. %1" | The total number of null columns in the unloaded data does not match the number of null columns in the LOAD command. Click here for a list of possible parameters and odbc states. |
| 1000237L | Warning | 20897 | 00C37 | "\t%1 Rows, %2 Seconds" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000237L | Error | 21003 | QDC44 | "The total number of variable width columns in the unloaded data, %2, does not match the total number of variable width columns in the LOAD command, %3. %1" | The total number of variable width columns in the unloaded data does not match the number of variable width columns in the LOAD command. Click here for a list of possible parameters and odbc states. |
| 1000238L | Warning | 20898 | 01C38 | "\t%1 Rows, %2 Seconds, '%3'" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000238L | Error | 21009 | QDC45 | "The platform type of the unloaded data, %2, does not match the platform type on the load, %3. %1" | The Platform ID of unloaded data does not match the Platform ID of load. The LOAD command detected that the platform on which the UNLOAD was performed, is not the same platform on which the LOAD is being attempted. Cross platform UNLOAD-LOAD cannot be done. Click here for a list of possible parameters and odbc states. |
| 1000239L | Warning | 20899 | 01C39 | "Inserting into table '%1',\ncolumn '%2'.\nInput record %3 was rejected." | Some data cannot be inserted. Examine the data and column definition to determine why. Click here for a list of possible parameters and odbc states. |