Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1000062L | Error | 20722 | QDC35 | "Cannot add column '%3' with 'not null' constraint on table %2 with data. %1" | The user tried to ALTER ADD a NOT NULL column to a table that has data. The newly added column would violate the NOT NULL constraint as it would have null data. Click here for a list of possible parameters and odbc states. |
| -1000063L | Error | 20723 | QDC34 | "Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1" | The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data. The user has to first delete the null rows before altering the column to enforce the NOT NULL constraint. Click here for a list of possible parameters and odbc states. |
| -1000064L | Error | 20724 | QDA64 | "Column %2 can not be altered because it participates in join %3. %1" | A column/field that participates in a join cannot be altered. Joins on this field must be deleted before an ALTER can be performed. Click here for a list of possible parameters and odbc states. |
| -1000065L | Error | 20725 | QDA65 | "Table %2 must be owned by the creator of the join. %1" | This error message is given during CREATE JOIN when one of the tables specified is not owned by the owner of the join. Joins can only be created from tables of the same owner. Click here for a list of possible parameters and odbc states. |
| -1000066L | Error | 20726 | QDA66 | "ALTER on the column would interfere with the natural join to table %2 in join %3. %1" | This message is displayed when using the ALTER command or adding columns to a table that participates in a join. Click here for a list of possible parameters and odbc states. |
| -1000067L | Error | 20727 | QDA67 | "Table '%2' is not defined in the catalog. %1" | This is an internal error. The table does not exist in the catalog. If this error occurs, it should be reported to Sybase. Click here for a list of possible parameters and odbc states. |
| 1000068L | Warning | 20728 | 00A68 | "The '%1' join index is in use for table '%2'." | This is an informational message. Click here for a list of possible parameters and odbc states. |
| 1000069L | Warning | 20729 | QDA69 | " %1; %2 blocks; %3" | This message is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000070L | Warning | 20730 | QDA70 | "File listing:" | This message is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000071L | Warning | 20731 | QDA71 | " %1" | This message is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000072L | Warning | 20732 | QDA72 | "Hole listing (%1):" | This message is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000073L | Warning | 20733 | QDA73 | " start: %1; size: %2" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000074L | Warning | 20734 | QDA74 | "Offset %1 Length %2, %3%4%5" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000075L | Warning | 20735 | QDA75 | "%1, %2%3%4" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000076L | Warning | 20736 | QDA76 | "%1, %2%3%4" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000077L | Warning | 20737 | QDA77 | "%1, %2%3%4" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| -1000078L | Error | 20738 | QDA78 | "IQ PAGE SIZE of '%2' for database '%3' is not valid. %1" | An invalid IQ PAGE SIZE was specified. IQ PAGE SIZE must be one of 1024, 2048, 4096, 8192, 16384, 32768, 65536, 131072, 262144, 524288. See the Reference Manual and Admin and Performance Guide for IQ PAGE SIZE recommendations. Click here for a list of possible parameters and odbc states. |
| -1000079L | Error | 20739 | QDA79 | "IQ SIZE of '%2' for database '%3' is not valid. %1" | The maximum IQ SIZE is 128GB. Click here for a list of possible parameters and odbc states. |
| 1000080L | Warning | 20740 | 00A80 | "Join index %1 already synchronized." | The join index is already synchronized. Click here for a list of possible parameters and odbc states. |
| -1000081L | Error | 20741 | QDA81 | "The field array for table '%2' must have at least 1 entry; it has %3 entries. %1" | This is an internal error. At least one column must be specified to populate a join index. If this error occurs, it should be reported to Sybase. Click here for a list of possible parameters and odbc states. |