Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Warning 1000130 | "%1 row(s) deleted from index '%2' on field '%3', %4 seconds." |
|---|---|
Constant | EMSG_DELETE_1INDEX |
SAP Sybase Error Number | 20790 |
SQL State | 01B30 |
SQL Code | 1000130L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | Number of rows |
Parameter 2 | index name |
Parameter 3 | field name |
Parameter 4 | number of seconds to complete the operation |
Probable Cause | This is an informational message displayed after a delete. |
| Error 1000131 | "The DELIMITED BY and LIMIT options are valid for WD indexes only. %1" |
|---|---|
Constant | EMSG_OPTION_FOR_WDINDEX_ONLY |
SAP Sybase Error Number | 20791 |
SQL State | QDB31 |
SQL Code | -1000131L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | The DELIMITED BY and LIMIT options may be used only when creating a WD (WORD) index. |
| Error 1000132 | "In table '%2', the START ROW ID value (%3) must be greater than %4. Data has already been inserted at this location. %1" |
|---|---|
Constant | EMSG_INSRT_BADSTARTRECID |
SAP Sybase Error Number | 20792 |
SQL State | QDB32 |
SQL Code | -1000132L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Parameter 3 | requested START ROW ID value |
Parameter 4 | row id value |
Probable Cause | 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. |
| Error 1000133 | "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" |
|---|---|
Constant | EMSG_INSRT_COLUMNCOUNT |
SAP Sybase Error Number | 20793 |
SQL State | QDB33 |
SQL Code | -1000133L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Parameter 3 | number of columns attempting to insert to |
Parameter 4 | number of columns in the table. |
Probable Cause | 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. |
| Error 1000134 | "Column '%2' is being inserted into twice by this INSERT command. %1" |
|---|---|
Constant | EMSG_INSRT_DUPFIELD |
SAP Sybase Error Number | 20794 |
SQL State | QDB34 |
SQL Code | -1000134L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column name |
Probable Cause | The specified column was listed twice in the insert command. |
| Error 1000135 | "Cannot open the existence list for table '%2'. %1" |
|---|---|
Constant | EMSG_INSRT_EXISTENCEBM |
SAP Sybase Error Number | 20795 |
SQL State | QDB35 |
SQL Code | -1000135L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000136 | "A mismatch exists between the existence bitmaps in the insert object. %1" |
|---|---|
Constant | EMSG_INSRT_EXISTENCEMISMATCH |
SAP Sybase Error Number | 20796 |
SQL State | QDB36 |
SQL Code | -1000136L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000137 | "While inserting, table '%2' already had a Complete started. %1" |
|---|---|
Constant | EMSG_INSRT_HADDONE |
SAP Sybase Error Number | 20797 |
SQL State | QDB37 |
SQL Code | -1000137L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000138 | "A data conversion error has occurred while loading record %2. This error should be reported to Sybase. %1" |
|---|---|
Constant | EMSG_INSRT_CONVERTDATA |
SAP Sybase Error Number | 20798 |
SQL State | QDB38 |
SQL Code | -1000138L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Parameter 2 | The input record number when the error occurred. |
Probable Cause | 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. |
| Error 1000139 | "You cannot insert into table '%2' past the original end of the table while there are %3 join virtual tables based on it. %1" |
|---|---|
Constant | EMSG_INSRT_HASJOINPASTEND |
SAP Sybase Error Number | 20799 |
SQL State | QDB39 |
SQL Code | -1000139L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Parameter 3 | number of join virtual tables |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000140 | "You cannot change column '%2' because it is a 'link' column. %1" |
|---|---|
Constant | EMSG_INSRT_HASLINK |
SAP Sybase Error Number | 20800 |
SQL State | QDB40 |
SQL Code | -1000140L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column name |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Warning 1000142 | "Insert into '%1', \n%2 Inners added, %3 Left Outers converted to Inners, %4 Right Outers added." |
|---|---|
Constant | EMSG_INSRT_JOINTABLEDONE |
SAP Sybase Error Number | 20802 |
SQL State | 01B42 |
SQL Code | 1000142L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | Join name |
Parameter 2 | number of inners added |
Parameter 3 | number of left outers converted to inners |
Parameter 4 | number of right outers added |
Probable Cause | This is an informational message displayed upon completion of an insert to a join. |
| Error 1000143 | "While inserting, table '%2' must be Complete(d) before it can be (re)Prepare(d). %1" |
|---|---|
Constant | EMSG_INSRT_NODONE |
SAP Sybase Error Number | 20803 |
SQL State | QDB43 |
SQL Code | -1000143L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000144 | "Cannot insert into table '%2'. Column %3 does not have a name. %1" |
|---|---|
Constant | EMSG_INSRT_NOFIELDNAME |
SAP Sybase Error Number | 20804 |
SQL State | QDB44 |
SQL Code | -1000144L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Parameter 3 | column number |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000145 | "The insert for table '%2' has no insertable columns in the column list. %1" |
|---|---|
Constant | EMSG_INSRT_NOINSERTABLEFIELDS |
SAP Sybase Error Number | 20805 |
SQL State | QDB45 |
SQL Code | -1000145L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | table to insert into |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000146 | "Cannot get the index buffer for the column '%2'. %1" |
|---|---|
Constant | EMSG_INSRT_NOSINDEX |
SAP Sybase Error Number | 20806 |
SQL State | QDB46 |
SQL Code | -1000146L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column name |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000147 | "Table '%2' must be Prepare(d) before inserting. %1" |
|---|---|
Constant | EMSG_INSRT_NOPREPARE |
SAP Sybase Error Number | 20807 |
SQL State | QDB47 |
SQL Code | -1000147L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000148 | "The table being inserted to does not have a name. %1" |
|---|---|
Constant | EMSG_INSRT_NOTABLENAME |
SAP Sybase Error Number | 20808 |
SQL State | QDB48 |
SQL Code | -1000148L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |
| Error 1000149 | "Unable to open table '%2' with Read/Write access for insert. %1" |
|---|---|
Constant | EMSG_INSRT_NOTABLE |
SAP Sybase Error Number | 20809 |
SQL State | QDB49 |
SQL Code | -1000149L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | tablename |
Probable Cause | The table cannot be opened for write access. The insert cannot proceed. Another user has this table open with write access. |
| Error 1000150 | "Cannot insert into the table. Column '%2' has no index. %1" |
|---|---|
Constant | EMSG_INSRT_NOTNULLNOIDX |
SAP Sybase Error Number | 20810 |
SQL State | QDB50 |
SQL Code | -1000150L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column name |
Probable Cause | This is an internal error. If this error occurs, it should be reported to Sybase. |