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 |
|---|---|---|---|---|---|
| QDC58 | Warning | 20918 | 1000258L | "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. |
| QDC59 | Error | 22004 | -1013106L | "logical file %2 not part of dbspace %3. %1" | this logical filename is not part of this dbspace Click here for a list of possible parameters and odbc states. |
| QDC60 | Error | 20920 | -1000260L | "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. |
| QDC61 | Error | 20921 | -1000261L | "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. |
| QDC62 | Error | 20922 | -1000262L | "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. |
| QDC63 | Error | 20973 | -1000263L | "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. |
| QDC64 | Error | 21109 | -1000280L | "Secondary server version information has not changed" | ev_iqmpxstatus has run the query event but there is nothing for it to do. Click here for a list of possible parameters and odbc states. |
| QDC65 | Error | 20030 | -1000283L | "Identity/Autoincrement Column value range exceeded for column %2. %1" | Data overflow: An Identity/Autoincrement Column has reached its maximum value. To correct this create a new table in which the datatype of the new Identity/Autoincrement Column is larger and copy this table into the new table. Alternatively add a new Identity/Autoincrement Column to the table with a larger datatype and delete the old one. Click here for a list of possible parameters and odbc states. |
| QDC66 | Error | 20032 | -1000284L | "Identity/Autoincrement Column value for column %2 must be positive. %1" | All values in Identity/Autoincrement Columns must be positive. To correct this, only use positive values when manually inserting into Identity/Autoincrement Columns. Click here for a list of possible parameters and odbc states. |
| QDC67 | Error | 20034 | -1000285L | "The value specified for the Identity/Autoincrement Column %2 exceeds the range of its datatype. %1" | The value specified does not fit in the Identity/Autoincrement Column. To correct this, choose a smaller value Click here for a list of possible parameters and odbc states. |
| QDC68 | Error | 20035 | -1000286L | "Invalid table argument %2 to sp_iq_reset_identity, Table has no Identity/Autoincrement Column. %1" | Table's without Identity/Autoincrement Columns cannot be used in calls to stored procedure sp_iq_reset_identity. Click here for a list of possible parameters and odbc states. |
| QDC69 | Error | 20036 | -1000287L | "Invalid table argument %2 to sp_iq_reset_identity, Table cannot be a JVT. %1" | Tables of type JVT are not allowed as arguments to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| QDC70 | Error | 20037 | -1000288L | "Invalid table argument %2 for set option 'identity_insert', Table cannot be a JVT. %1" | Tables of type JVT are not allowed as a value for the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| QDC71 | Error | 20038 | -1000289L | "Invalid table argument %2 for set option 'identity_insert', Table must be an IQ table. %1" | Only IQ tables are allowed as an argument value to the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| QDC72 | Error | 20039 | -1000290L | "Invalid table argument %2 for stored procedure sp_iq_reset_identity, Table must be an IQ Table. %1" | Only IQ tables are allowed as a table argument to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| QDC73 | Error | 20041 | -1000291L | "You do not have insert permission on table %2. %1" | You cannot set the option 'identity_insert' to a table for which you do not have insert permission Click here for a list of possible parameters and odbc states. |
| QDC74 | Error | 20474 | -1000292L | "Invalid use of set option 'identity insert'. Table %2 does not have an Identity/Autoincrement Column. %1" | the set option 'identity insert' cannot be used on a table without an Identity/Autoincrement Column. Click here for a list of possible parameters and odbc states. |
| QDC75 | Error | 20644 | -1000293L | "Cannot insert or update Column %2: set option 'identity_insert' to the specific table name containing the identity column to be modified. %1" | set option 'identity_insert' must be set to the specific table for which you want to insert or update an Identity column. To turn it on use set identity_insert <table_name> Click here for a list of possible parameters and odbc states. |
| QDC76 | Error | 20645 | -1000294L | "Cannot set 'identity_insert', it is already on for a different table. %1" | the set option 'identity_insert' can only be set for one table at a time. To set it for a different table, first turn it off using 'set identity_insert '' ' then set it to the desired table. Click here for a list of possible parameters and odbc states. |
| QDC77 | Error | 20646 | -1000295L | "Invalid table name %2 specified for option 'identity_insert'. %1" | The table associated with the table name specified for the 'identity_insert' option could not be found. Click here for a list of possible parameters and odbc states. |