Messages QDB26 through QDB47

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
QDB26 Error 20786 -1000126L "This database must be upgraded. %1" This database must be upgraded with the ALTER DATABASE UPGRADE command in order to continue.

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

QDB27 Error 20787 -1000127L "The LIMIT specified, '%2', is too large. %1" The LIMIT entered is too large. The LIMIT entered on the command line must be between 0 and 4294967295. However, this limitation is only for the LIMIT clause in the sql command. See the ASIQ Reference Manual for the actual, valid LIMIT size.

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

QDB28 Error 20788 -1000128L "You must delete from join index %2 before you can delete from table %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.

QDB29 Warning 20789 1000129L "%1 row(s) deleted from index '%2' in %3 seconds." This is an informational message displayed after a delete.

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

QDB31 Error 20791 -1000131L "The DELIMITED BY and LIMIT options are valid for WD indexes only. %1" The DELIMITED BY and LIMIT options may be used only when creating a WD (WORD) index.

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

QDB32 Error 20792 -1000132L "In table '%2', the START ROW ID value (%3) must be greater than %4. Data has already been inserted at this location. %1" You have entered an incorrect START ROW ID and are trying to insert into a column that already contains data. See the Administration and Performance Guide's chapter Moving Data in and out of Databases. The section on partial width inserts contains information regarding the START ROW ID option.

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

QDB33 Error 20793 -1000133L "During the LOAD into table '%2', the LOAD statement's column count (%3) must be between 1 and %4. Check the LOAD statement's 'load-specification'. %1" The number of columns you are trying to insert to is not consistent with the number of columns specified in the LOAD statement's 'load-specification'. You must specify by name each column you are attempting to insert to via the LOAD statement.

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

QDB34 Error 20794 -1000134L "Column '%2' is being inserted into twice by this INSERT command. %1" The specified column was listed twice in the insert command.

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

QDB35 Error 20795 -1000135L "Cannot open the existence list for table '%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.

QDB36 Error 20796 -1000136L "A mismatch exists between the existence bitmaps in the insert object. %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.

QDB37 Error 20797 -1000137L "While inserting, table '%2' already had a Complete started. %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.

QDB38 Error 20798 -1000138L "A data conversion error has occurred while loading record %2. This error should be reported to Sybase. %1" A data conversion error occurred during an insert. The input datatype cannot converted to the datatype of the data's destination field. This error should be reported to Sybase. Diagnostic information has been output to the iqmsg file.

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

QDB39 Error 20799 -1000139L "You cannot insert into table '%2' past the original end of the table while there are %3 join virtual tables based on it. %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.

QDB40 Error 20800 -1000140L "You cannot change column '%2' because it is a 'link' column. %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.

QDB41 Error 20801 -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.

QDB43 Error 20803 -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.

QDB44 Error 20804 -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.

QDB45 Error 20805 -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.

QDB46 Error 20806 -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.

QDB47 Error 20807 -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.


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