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 |
|---|---|---|---|---|---|
| -1000239L | Error | 21010 | QDC46 | "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. |
| 1000240L | Warning | 20900 | 01C40 | "Inserting into table '%1',\nColumn '%2'.\nOn input record %3, the value was rejected." | Some data was rejected on insert. Examine the input data and column definition to determine why. Click here for a list of possible parameters and odbc states. |
| -1000240L | Error | 21011 | QDC47 | "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. |
| 1000241L | Warning | 20901 | QDC41 | "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. |
| 1000242L | Warning | 20902 | 01C42 | "Insert completed. Index '%1',\n in %2 seconds." | This is an informational message that is displayed after an insert to an index. Click here for a list of possible parameters and odbc states. |
| -1000242L | Error | 21012 | QDC48 | "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. |
| 1000243L | Warning | 20903 | 01C43 | "\nInsert into join virtual table '%1' started.\n\t\t%2 tables will be modified (in all)." | This is an informational message. Click here for a list of possible parameters and odbc states. |
| -1000243L | Error | 21013 | QDC49 | "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. |
| 1000244L | Warning | 20904 | 01C44 | "\nInsert into join virtual table '%1' completed\n in %2 seconds.\n\t\t%3 tables modified (in all).\n" | This is an informational message. Click here for a list of possible parameters and odbc states. |
| -1000244L | Error | 21014 | QDC50 | "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. |
| 1000245L | Warning | 20905 | 01C45 | "Insert into join virtual table '%1' started.\n%2 rows will be inserted (in all)." | This is an informational message. Click here for a list of possible parameters and odbc states. |
| -1000245L | Error | 21015 | QDC51 | "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. |
| 1000246L | Warning | 20906 | 01C46 | "%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. |
| -1000246L | Error | 21016 | QDC52 | "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. |
| 1000247L | Warning | 20907 | 01C47 | "Insert into join virtual table '%1' completed in %2 seconds.\n%3 rows inserted (in all)." | This is an informational message. Click here for a list of possible parameters and odbc states. |
| -1000247L | Error | 21017 | QDC54 | "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. |
| 1000248L | Warning | 20908 | 01C48 | "\nJoin virtual table passes started for '%1'.\n" | This is an informational message. Click here for a list of possible parameters and odbc states. |
| 1000249L | Warning | 20909 | 01C49 | "\nJoin Virtual Table Pass 1 started for '%1'.\n" | This is an informational message. Click here for a list of possible parameters and odbc states. |
| 1000250L | Warning | 20910 | 01C50 | "\nJoin virtual table Pass %1 completed for '%2', %3 seconds.\n\t\t%4 rows processed.\n" | This is an informational message. Click here for a list of possible parameters and odbc states. |
| 1000251L | Warning | 20911 | 01C51 | "\nJoin virtual table passes 1 and 2 complete for '%1' in %2 seconds.\n%3 rows processed.\n" | This is an informational message. Click here for a list of possible parameters and odbc states. |