Messages QSB75 through QTA12

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
QSB75 Error 20233 -1009179L "The last file in a dbspace may only be removed by DROP DBSPACE. %1" A dbspace must contain at least one file. The last file can only be removed by dropping the dbspace that contains it.

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

QSB76 Error 20234 -1009180L "%2 is not allowed on system dbspace %3. %1" The requested DDL operation is not allowed on system dbspaces

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

QSB77 Error 20235 -1009181L "Multiple FILE clauses are not allowed for this command. %1" Some alter dbspace commands do not allow multiple files to be specified

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

QSB78 Error 20236 -1009182L "DBFile name %2 is already in use. %1" logical filenames must be unique for dbfiles

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

QSB79 Error 20237 -1009183L "A readwrite dbspace may not be placed offline. %1" A dbspace must be readonly before it can be placed offline

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

QSB80 Error 21190 -1009184L "Operation not permitted on a READONLY DBSpace. %1" No additional information available..

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

QSB81 Error 21191 -1009185L "An IO error was encountered while writing a database page in %2 DBSpace. %1. File is readonly." No additional information available..

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

QSB82 Error 21200 -1009186L "Global Request for freelist failed. %1" Global reqest for freelist failed.

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

QTA00 Error 20154 -1005000L "Bind parameters are not supported in data flow query processing" No additional information available.

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

QTA01 Error 20155 -1005001L "Query has exceeded the supported maximum number of tables that can be joined. %1" No additional information available.

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

QTA02 Error 20156 -1005002L "Subquery predicates are not supported in the ON clause of outer joins in this release. %1" No additional information available.

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

QTA03 Error 20157 -1005003L "A maximum of one subquery predicate per conjunct is supported in this release. %1" No additional information available.

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

QTA04 Error 20158 -1005004L "Subqueries are allowed only as arguments of comparisons, IN, and EXISTS %2, %1" No additional information available.

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

QTA05 Error 20159 -1005005L "Deleting from views is not supported. %1" No additional information available.

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

QTA06 Error 20160 -1005006L "The target DELETE table must also appear in FROM. %1" No additional information available.

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

QTA08 Error 20162 -1005008L "Sybase IQ does not support nested aggregations. %1" No additional information available.

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

QTA09 Error 20163 -1005009L "Cannot perform an aggregate function on a column from a table not declared in the same query. %2, %1" No additional information available.

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

QTA10 Error 20164 -1005010L "The field '%2' is not unique and needs to be qualified, %1" No additional information available.

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

QTA11 Error 20165 -1005011L "There are two tables named '%2'. Please specify an alias for one of them. %1" No additional information available.

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

QTA12 Error 20166 -1005012L "The field '%2' specified in the query cannot be found, %1" No additional information available.

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


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com