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 |
|---|---|---|---|---|---|
| -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. |
| 1000252L | Warning | 20912 | 01C52 | "Processing completed for join index '%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. |
| -1000253L | Error | 20913 | QDC53 | "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. |
| 1000254L | Warning | 20914 | 01C54 | "\t%1 Rows, JP%2, %3 Seconds" | This is an informational message displayed in the context of other messages. Click here for a list of possible parameters and odbc states. |
| 1000255L | Warning | 20915 | 01C55 | "Join Record Rejected: '%1', duplicate rows in 1st table. \nRow# %2 & %3, row %4 rejected." | This is an informational message describing duplicate rows encountered. Click here for a list of possible parameters and odbc states. |
| 1000256L | Warning | 20916 | 01C56 | "Join virtual table '%1'. \nTotal rows rejected: %2" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000257L | Warning | 20917 | 00C57 | "Delete of %1 rows started for table: " | This is an informational message foretelling the number of rows to be deleted from a table. Click here for a list of possible parameters and odbc states. |
| 1000258L | Warning | 20918 | QDC58 | "Portions of the insert/load will be single threaded." | The load will proceed, but portions of it will be done serially. This can be caused by constraining the amount of memory available to the load with the LOAD_MEMORY_MB option; executing a variable length load without row delimiters; or executing a partial width, variable length load. Click here for a list of possible parameters and odbc states. |
| 1000259L | Warning | 20919 | 01C59 | "\nDelete of %1 rows completed for table: %2, %3 seconds." | This is an informational message displayed at the end of a delete. Click here for a list of possible parameters and odbc states. |
| -1000260L | Error | 20920 | QDC60 | "ALTER DBSPACE <dbspace-name> ADD <number> is not supported. %1" | For a Sybase IQ database, one can add space to a database only using the CREATE DBSPACE command. The size of existing dbspaces cannot be changed. Click here for a list of possible parameters and odbc states. |
| -1000261L | Error | 20921 | QDC61 | "A Sybase IQ system dbspace, '%2', cannot be renamed. %1" | You cannot rename a dbspace in a Sybase IQ database. Click here for a list of possible parameters and odbc states. |
| -1000262L | Error | 20922 | QDC62 | "You cannot specify BLANK PADDING OFF for CREATE DATABASE. %1" | The BLANK PADDING OFF clause is not valid while creating a Sybase IQ database. Click here for a list of possible parameters and odbc states. |
| -1000263L | Error | 20973 | QDC63 | "Undo failure for row %2. Statement will rollback to statement before the first insert..values. %1" | There was a unrecoverable error encountered while attempting to undo an 'insert' operation for the specified row. Consequently, the statement now rolls back to the first insert..values statement that occurred since the most recent commit, rollback, or non-insert..values command. Click here for a list of possible parameters and odbc states. |
| -1000264L | Error | 21077 | QDB04 | "Ambiguous index name '%2'. Please specify owner. %1" | The specified index name is shared by more than one owner. The owner can be specified as OWNER.TABLE.INDEX Click here for a list of possible parameters and odbc states. |