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 |
|---|---|---|---|---|---|
| QDC37 | Error | 20997 | -1000227L | "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. |
| QDC38 | Error | 20998 | -1000229L | "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. |
| QDC39 | Error | 20999 | -1000230L | "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. |
| QDC40 | Error | 21000 | -1000234L | "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. |
| QDC41 | Warning | 20901 | 1000241L | "The insert to the table will be single threaded." | There are not enough threads available to do a multithreaded insert or load. The number of users doing parallel processing has limited the number of threads available for your insert/load. The insert/load will proceed, but will be done serially. Click here for a list of possible parameters and odbc states. |
| QDC42 | Error | 21001 | -1000235L | "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. |
| QDC43 | Error | 21002 | -1000236L | "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. |
| QDC44 | Error | 21003 | -1000237L | "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. |
| QDC45 | Error | 21009 | -1000238L | "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. |
| QDC46 | Error | 21010 | -1000239L | "UNLOAD version number: %2, does not match the LOAD version number: %3. %1" | The UNLOAD version number does not match the LOAD version number. The version number of the data on the tape being read does not match the version number of the LOAD command. The version numbers must match before the data on the tape can be loaded. Click here for a list of possible parameters and odbc states. |
| QDC47 | Error | 21011 | -1000240L | "The total number of blocks of unloaded data: %2, does not match the total number of blocks loaded: %3. %1" | Total number of blocks of unloaded data on the tape does not match the number of blocks of data that were just loaded. Click here for a list of possible parameters and odbc states. |
| QDC48 | Error | 21012 | -1000242L | "Total number of rows of unloaded data: %2, does not match the total number of rows in the load: %3. %1" | The total number of rows of unloaded data on the tape does not match the numbers of rows of data just loaded. Click here for a list of possible parameters and odbc states. |
| QDC49 | Error | 21013 | -1000243L | "The unload format number: %2, does not match the load format number: %3. %1" | The unload format number does not match the load format number. The data on the tape being read contains a format number. This number does not match the format number of the LOAD command. In order to load the data, the numbers must match. Click here for a list of possible parameters and odbc states. |
| QDC50 | Error | 21014 | -1000244L | "The BLOCK FACTOR of unloaded data: %2 does not match the BLOCK FACTOR of the LOAD: %3. %1" | The BLOCK FACTOR used in the LOAD command must be the same as the BLOCK FACTOR that was used in the LOAD command to unload the data. Click here for a list of possible parameters and odbc states. |
| QDC51 | Error | 21015 | -1000245L | "Tape / File already loaded. Block number %2 repeats. %1" | LOAD has encountered a block that has already been loaded. This tape (or file) has already been loaded. Click here for a list of possible parameters and odbc states. |
| QDC52 | Error | 21016 | -1000246L | "The number of rows loaded: %3, does not match the number of rows unloaded: %2. %1" | The number of rows of data on all of the tapes that were loaded does not match the number of rows of data that were unloaded by the LOAD command. Click here for a list of possible parameters and odbc states. |
| QDC53 | Error | 20913 | -1000253L | "Cannot drop the constraint '%1'." | IQ is unable to drop the named constraint because the index associated with the constraint could not be found or opened. Click here for a list of possible parameters and odbc states. |
| QDC54 | Error | 21017 | -1000247L | "The number of blocks loaded: %3, does not match the number of blocks unloaded: %2. %1" | The number of blocks of data on all of the tapes that were loaded does not match the number of blocks of data that were unloaded by the LOAD command. Click here for a list of possible parameters and odbc states. |
| QDC55 | Error | 21036 | -1009137L | "Cannot perform DDL command now on table %2 as a DDL command is already in progress on that table. %1" | There is already a DDL command in progress at the moment on the table specified and you must wait until it is finished before starting another DDL command on that table. Click here for a list of possible parameters and odbc states. |
| QDC56 | Error | 21110 | -1000281L | "Column %2 has unsupported data type for index rebuild. %1" | You have tried to rebuild an FP index of unsupported index style. Click here for a list of possible parameters and odbc states. |