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 |
|---|---|---|---|---|---|
| -1000018L | Error | 20678 | QDA18 | "The object cannot be opened for DROP or ALTER. It is already open. %1" | The object that you have requested to DROP or ALTER cannot be opened for META access. Either the current connection or another connection has a cursor open on the table you are trying to DROP or ALTER or on the table to which the field or index you are trying open for META belongs. In order to proceed, all cursors open on this object must be closed. Click here for a list of possible parameters and odbc states. |
| -1000022L | Error | 20682 | QDA22 | "Index '%2' has an invalid index type: %3. %1" | This is an internal error. The index is of a type that is unknown to ASIQ. If this error occurs, it should be reported to Sybase. Click here for a list of possible parameters and odbc states. |
| -1000023L | Error | 20683 | QDA23 | "The proposed join does not form a clearly connected list. (table '%2') %1" | Join Indexes can be entered in one of two ways. Using the order of the tables in the SQL statement or using primary<->foreign keys. When using the order method the order determines the relationships between the tables. The order is from a one to many or one to one. It is possible to ask for a join Index that can not be constructed. This error could be from one of the following: 1) The same table is specified twice. 2) The relationships of one to one/many are not consistent with the indexes defined. 3) A table specified has no relation to the tables previously encountered in the syntax. For example: A FULL OUTER JOIN B FULL OUTER JOIN C FULL OUTER JOIN D In this example C has no relation (fields in common) to A or B. The user intended C to Join with D. Some joins can not be defined using the ANSI syntax which depends on order to determine the one to one/many relationship. It is recommended to use the primary and foreign keys syntax to avoid any join definition problems. Click here for a list of possible parameters and odbc states. |
| -1000024L | Error | 20684 | QDA24 | "For table pair %2, table '%3' has a datatype mismatch for column %4. %1" | Corresponding columns' in the table pairs must be of the same datatype. (For example, INTEGER and INTEGER or CHAR and CHAR.) Matching datatypes such as CHAR and VARCHAR or INT and SMALLINT are not allowed. Click here for a list of possible parameters and odbc states. |
| -1000026L | Error | 20686 | QDA26 | "The join virtual table for table '%2' has duplicate columns in positions %3 and %4. %1" | The join virtual table for table has duplicate columns. Perhaps the join predicate is improperly specified. Click here for a list of possible parameters and odbc states. |
| -1000027L | Error | 20687 | QDA27 | "The join virtual table '%2' does not have any data. %1" | It was requested that the join index be opened only if it is not empty. 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. |
| -1000028L | Error | 20688 | QDA28 | "For table pair %2, table '%3' has a length value mismatch for column %4. %1" | Corresponding columns in the table pair must be of the same length. Click here for a list of possible parameters and odbc states. |
| -1000029L | Error | 20689 | QDA29 | "Cannot open the requested object for write in the current transaction (%2). Another user has write access in transaction %3. %1" | The ASIQ catalog allows only one transaction at a time to have write access to an object. The id of the user that is currently writing to the object can be found by running sp_iqtransaction and scanning the output for the transaction id of the writer that currently has write access. Click here for a list of possible parameters and odbc states. |
| 1000030L | Warning | 20690 | QDA30 | "\nMaster archive header information\n" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000031L | Warning | 20691 | 00A31 | "Join Index '%1' created from the following join relations:" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 1000032L | Warning | 20692 | 00A32 | "The ultimate/top table is %1\n" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 1000033L | Warning | 20693 | QDA33 | "Database: %1" | This message is displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000034L | Warning | 20694 | 00A34 | " Table Name Relationship" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| -1000035L | Error | 20695 | QDA35 | "Using views in CREATE JOIN INDEX is not supported. %1" | Using views in CREATE JOIN INDEX is not supported. Click here for a list of possible parameters and odbc states. |
| 1000036L | Warning | 20696 | 00A36 | "%1. %2 joined to '%3' %4" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 1000037L | Warning | 20697 | 00A37 | "------------------------------------------------------------------" | This information message appears in the log when the CREATE JOIN command is executed. Click here for a list of possible parameters and odbc states. |
| 1000038L | Warning | 20698 | QDA38 | "Backup date: %1" | This message displays the backup date. Click here for a list of possible parameters and odbc states. |
| 1000039L | Warning | 20699 | QDA39 | "Backup created by: %1" | This message displays the user who created the backup. Click here for a list of possible parameters and odbc states. |
| 1000040L | Warning | 20700 | QDA40 | "Comment: %1" | This is an informational message displayed in context with other messages. Click here for a list of possible parameters and odbc states. |
| 1000041L | Warning | 20701 | QDA41 | "Backup version: %1" | This message displays the backup version. Click here for a list of possible parameters and odbc states. |