Messages 20801 through 20820

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
20801 Error QDB41 -1000141L "Column '%2' must be included in the LOAD since it is used in a join. %1" All columns participating in a join index must be included in the insert.

Click here for a list of possible parameters and odbc states.

20802 Warning 01B42 1000142L "Insert into '%1', \n%2 Inners added, %3 Left Outers converted to Inners, %4 Right Outers added." This is an informational message displayed upon completion of an insert to a join.

Click here for a list of possible parameters and odbc states.

20803 Error QDB43 -1000143L "While inserting, table '%2' must be Complete(d) before it can be (re)Prepare(d). %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20804 Error QDB44 -1000144L "Cannot insert into table '%2'. Column %3 does not have a name. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20805 Error QDB45 -1000145L "The insert for table '%2' has no insertable columns in the column list. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20806 Error QDB46 -1000146L "Cannot get the index buffer for the column '%2'. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20807 Error QDB47 -1000147L "Table '%2' must be Prepare(d) before inserting. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20808 Error QDB48 -1000148L "The table being inserted to does not have a name. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20809 Error QDB49 -1000149L "Unable to open table '%2' with Read/Write access for insert. %1" The table cannot be opened for write access. The insert cannot proceed. Another user has this table open with write access.

Click here for a list of possible parameters and odbc states.

20810 Error QDB50 -1000150L "Cannot insert into the table. Column '%2' has no index. %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20811 Error QDB51 -1000151L "NOT NULL column '%2' was not included in this insert. Data is needed at row %3. %1" Data must be provided for insertion into columns defined as "NOT NULL".

Click here for a list of possible parameters and odbc states.

20812 Error QDB52 -1000152L "The NOT NULL column '%2' was not included in this insert. %1" Data must be provided for insertion into columns defined as "NOT NULL".

Click here for a list of possible parameters and odbc states.

20813 Error QDB53 -1000153L "Table '%2', pass-x index count mismatch (%3/%4). %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20814 Error QDB54 -1000154L "While inserting into table '%2', the record number recycled (%3). %1" This is an internal error. If this error occurs, it should be reported to Sybase.

Click here for a list of possible parameters and odbc states.

20815 Error QDB55 -1000155L "The attempted insert length (%3) for column %2 is longer than the maximum allowed (%4). %1" The attempted insert length is too long. The maximum length allowed is 65535.

Click here for a list of possible parameters and odbc states.

20816 Error QDB56 -1000156L "Tried to insert into too many (%2) LOW FAST indexes at one time in table '%3'. %1" The maximum number allowed is 32727.

Click here for a list of possible parameters and odbc states.

20817 Error QDB57 -1000157L "Columns for the index must be in ascending sort order. %1" It is required that ASC (ascending) sort order be used for the columns in the indexes.

Click here for a list of possible parameters and odbc states.

20818 Error QDB58 -1000158L "An Identity size mismatch has occurred. The current transaction will rollback. %1" IQ has encountered an Identity size mismatch. The current command will be rolled back. If this error occurs, the operation that caused it may be tried again. If the error occurs again, the server should be stopped and restarted. If the problem persists, Sybase should be notified of the error.

Click here for a list of possible parameters and odbc states.

20819 Warning 00B59 1000159L "\nIn table '%1', the %2 width insert of %3 columns will begin at record %4." Informational message displayed during insert.

Click here for a list of possible parameters and odbc states.

20820 Warning 00B60 1000160L "Option %1 has an invalid setting: %2." The named OPTION is set to an invalid value. See the documentation for the valid values for the option.

Click here for a list of possible parameters and odbc states.


Created November 10, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com