Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.
Number | Msg Type | SQL State | SQL Code | Message | Possible Cause |
---|---|---|---|---|---|
20640 | Error | QCA70 | -1013070L | "Cannot specify check constraints off and ignore all, ignore check, log all or log check during load. %1" | when check constraints off is specified during load ignore all, ignore check, log all, log check are not available. Click here for a list of possible parameters and odbc states. |
20641 | Error | QCA71 | -1013071L | "Constraint '%2' violated: Invalid value in table '%3'. %1" | The Data being inserted or updated is invalid due to a table check constraint violation. Click here for a list of possible parameters and odbc states. |
20642 | Error | QNA45 | -1008036L | "Table %1 already has an Identity/Autoincrement Column. " | An Identity/Autoincrement Column cannot be added to this table because it already has one. Click here for a list of possible parameters and odbc states. |
20643 | Error | QNA46 | -1008037L | "Cannot drop %1 %2: set option 'identity_insert' must be off. " | option 'identity insert' must not be set to any table name to drop an Identity Column. To turn it off use 'set identity_insert '' ' Click here for a list of possible parameters and odbc states. |
20644 | Error | QDC75 | -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. |
20645 | Error | QDC76 | -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. |
20646 | Error | QDC77 | -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. |
20647 | Error | QCA77 | -1013077L | "ROW DELIMITED BY is valid only when all columns are delimited or ASCII fixed-width. %1" | ROW DELIMITED BY is valid only when all columns are delimited or ASCII fixed-width. You cannot use a row delimiter with PREFIX or BINARY columns. Click here for a list of possible parameters and odbc states. |
20648 | Error | QCA78 | -1013078L | "Insert Pass 1 CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20649 | Error | QCA79 | -1013079L | "Insert Pass 1 user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20650 | Error | QCA80 | -1013080L | "Insert Pass 1 system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20651 | Error | QCA81 | -1013081L | "Insert Pass 2 CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20652 | Error | QCA82 | -1013082L | "Insert Pass 2 user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20653 | Error | QCA83 | -1013083L | "Insert Pass 2 system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20654 | Error | QCA84 | -1013084L | "Insert Commit CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20655 | Error | QCA85 | -1013085L | "Insert Commit user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20656 | Error | QCA86 | -1013086L | "Insert Commit system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20657 | Error | QCA87 | -1013087L | "Total Insert CPU utilization" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20658 | Error | QCA88 | -1013088L | "Insert Total user (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |
20659 | Error | QCA89 | -1013089L | "Insert Total system (%)" | This is displayed as part of an informational message during insert. Click here for a list of possible parameters and odbc states. |