SQLSTATE values

Successful completion

The last row fetched by this cursor was updated or deleted between the FETCH and UPDATE/DELETE...WHERE CURRENT... of statements.

A string overflow occurred during the evaluation of a character expression.

Some of the specified privileges could not be revoked.

No privileges were granted. You lack grant option on the specified privileges.

Not all privileges were granted. You lack grant option on some of the specified privileges.

A syntax error occurred.

Catalog catalog does not exist, or has not been registered on node node

Schema schema does not exist.

does not exist or object type is invalid for the current operation.

Constraint constraint-name does not exist.

Index index-name does not exist.

The statement just specified is currently not supported.

Privileges were not revoked. Dependent privilege descriptors still exist.

were specified in the constraint or trigger definition.

You are not authorized to perform this operation.

Privilege settings on metadata tables cannot be changed.

Schema

already exists.

Only the super ID can name an authorization ID other than the current user name.

Request failed. One or more dependent objects exist.

Only the schema owner or super ID user can drop a schema.

SQL/MX was not able to initialize.

Catalog catalog-name already exists

Only super ID can execute DROP SQL.

SQL/MX is not installed on systemnode.

Not all catalogs have been dropped from the system.

The drop SQL statement could not be executed.

The use of ALTER on metadata tables is not permitted.

The primary key has already been defined.

All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.

Constraint constraint-name already exists.

Constraint constraint-name could not be created because the referenced columns in the referenced table are not part of a unique constraint.

The unique constraint cannot be used because it is deferrable.

Referenced and referencing column lists do not match for constraint name.

Request failed. Dependent view view-name exists.

Currently only supporting restrict drop behavior.

Attempting to drop a NOT DROPPABLE constraint.

Cannot drop constraint used as a referenced object for a foreign key.

Insufficient privilege on table name.

Trying to drop a constraint that does not belong to requested table.

Unique index table namecould not be created because the column(s) specified contain duplicate data.

Index table name already exists.

Table, view, or stored procedure table name already exists.

The DAM volume specified ( name) is not available or is not audit protected.

Lock table name already exists.

Request failed. Dependent constraint name exists.

Cannot drop metadata catalog name.

Cannot drop metadata schema name.

Cannot drop metadata index table name.

Cannot drop metadata view table name.

Cannot create constraint name in metadata schema.

Cannot create index table name in metadata schema.

Unable to drop schema name.

Unable to create object table name (file errornum).

Only the super ID user can execute INITIALIZE SQL.

Catalog name contains at least one schema. The catalog must be empty.

Metadata table name does not contain information for view name.

The format of the specified location name name is invalid.

Unable to prepare the statement.

Duplicate references to column name in the create request.

Loading of index table name failed unexpectedly.

Validation for constraint name failed unexpectedly.

Validation for constraint name failed; incompatible data exists in table.

Invalid default value for column name

The calculated key length is greater than 255 bytes.

Lock table name does not exist.

Lock cannot be granted, conflicting operation is in progress.

Cannot instantiate object table name , conflicting lock exists.

Self-referencing constraints are currently not supported.

Unable to drop object table name because it is not a name.

The partition by column name should also be part of the clustering/storage key.

Duplicate partition key (name) specified for object name.

Column num is unnamed. You must specify an AS clause for that column expression, or name all the columns by specifying a view column list.

Unable to select table.schema.name

Unable to update table.schema.name

Unable to insert rows into table.schema.name

Unable to delete rows from table.schema.name

Default value string too long for column name.

CREATE TABLE LIKE statement cannot contain both HORIZONTAL PARTITIONS and STORE BY clauses.

The specified partition name of object name does not exist.

The number of columns specified in the view column list, num , does not match the degree of the query expression, num.

The WITH CHECK OPTION clause appears in the definition of view table name, but the view is not updateable.

Error starting transaction. table name name name

Unable to create catalog name metadata tables on name.

Unable to create label for name (file error num) text.

The current partitioning scheme requires a user-specified primary key on object name.

Cannot drop the only partition of the table. There must be at least two partitions available to perform the drop.

Cannot create object name in metadata schema.

Cannot drop metadata object name.

Attempting to change the audit flags for a table in an unsupported way.

Attempting to perform a partition add, move, or drop on table name. Partition operations are not allowed on tables with vertical partitions, entry sequenced operations, and SYSKEY-only partitioned tables.

The number of specified partition key values (name) for object name exceeds the number of key columns used, num.

Unable to process the partition key values (name ) for object name . Please verify that the correct key value data types were specified.

Schema name is an unknown version.

API request version number mismatch.

Referential integrity is not yet supported. Constraint name will not be enforced.

The specified table name is not a base table. Please verify that the correct table was specified.

Invalid API request. Details: text.

The column requires a default value.

An added column cannot have both DEFAULT NULL and NOT NULL.

Only the super ID can perform this operation.

Concurrent DDL operations are being performed on the given object. The current operation cannot be performed.

Clustering key column name must be assigned a NOT NULL NOT DROPPABLE constraint.

For an added column, the PRIMARY KEY clause cannot be NOT DROPPABLE.

Invalid index status. Details: text.

Invalid input parameter(s). Object name and status are required.

System-generated column name of base table name cannot appear in the search condition of a check constraint definition.

Row-length num exceeds the maximum allowed row-length of num for table name.

Could not obtain an up-and-audited DAM volume. Please check your system configuration.

Attempting to add a column with a NULL, UNIQUE, CHECK, PRIMARY KEY, or FOREIGN KEY constraint defined. This is not supported for a nonaudited table.

Validation for constraint name failed; incompatible data exists in referencing base table name and referenced base table name. To display the data violating the constraint, please use the following DML statement: text

Unable to alter object name because it is not a name.

System-generated column name of base table name cannot appear in a unique or primary key constraint definition.

The location name is either invalid or missing.

Error messages for compiler main, IPC, and DEFAULTS table; assertions for optimizer.

Internal error: cannot create MXCMP server.

Internal error: cannot establish connection with MXCMP server.

Internal error: error from MXCMP; cannot work on this query.

Internal error: out of virtual memory.

The user transaction must be rolled back (or committed, if that makes sense in the application) before MXCMP can be restarted and proceed.

Internal IPC error.

ASSERTION FAILURE CAUGHT BY OPTIMIZER! Attempting to recover and produce a plan.

A procedure body must be a SELECT, INSERT, UPDATE, DELETE, DECLARE CATALOG, DECLARE SCHEMA, or a static DECLARE CURSOR.

A static cursor declaration might appear only in the body of a procedure.

Invalid statement type in this context.

A module timestamp statement has already appeared in this module. The previous timestamp is being retained and this latest one ignored.

Break was received. The compilation has been aborted.

Compilation failure due to internal error.

Unable to compile this query with 'MINIMUM' optimization level. Suggestion: Retry with 'MEDIUM' optimization level.

Unable to compile this query for one/both of the following reasons: a) Use of 'MINIMUM' optimization level, or b) Incompatible Control Query Shape specifications.

Unable to compile this query for one of two reasons: a) Incompatible Control Query Shape (CQS) specifications, or b) 'MEDIUM' optimization level is not sufficient to satisfy the CQS in effect. Suggestion: a) Inspect the CQS in effect; or b) Raise the optimization level to 'MAXIMUM'. Note that for this query, 'MAXIMUM' optimization level might result in a long compile time.

Unable to compile this query because of incompatible Control Query Shape (CQS) specifications. Suggestion: Inspect the CQS in effect.

Unable to compile this statement since it is too long. Suggestion: Break up large statements into smaller pieces.

Unable to compile this statement. Suggestion: Address the issue(s) raised in the reported warning(s).

Statement was compiled as if query plan caching were off.

Length or precision must be greater than zero.

A delimited identifier must contain at least one non-blank character.

A DECLARE CURSOR statement cannot dynamically get its cursor name from a host variable while also statically declaring a cursor specification. A dynamic cursor requires the name of a previously prepared statement, or a host variable containing such a name; a static cursor requires a fixed, static name.

In a dynamic cursor declaration both the cursor and the statement must be named in the same way: both must be literals or both must be string host variable expressions.

In an ALLOCATE CURSOR statement both the cursor and the statement must be named using string host variables.

DROP ASSERTION statement is not yet supported.

COUNT is the only aggregate function that accepts (*) as an operand.

Subtraction is the only operation allowed in the parenthesized expression preceding an interval qualifier.

The COLLATE clause in a sort specification is not yet supported.

The MATCH PARTIAL clause is not yet supported.

A comma must be used to separate file attributes.

Specifying a privilege column list in the INSERT clause is not yet supported.

The PARALLEL EXECUTION clause is not yet supported.

CASCADE drop behavior is not yet supported.

The COLUMN clause in the ALTER TABLE statement is not yet supported.

The MOVE clause in the ALTER TABLE statement is not yet supported.

The PARTITION clause in the ALTER TABLE statement is not yet supported.

The RENAME clause in the ALTER TABLE statement is not yet supported.

The SET CONSTRAINT clause in the ALTER TABLE statement is not yet supported.

PIC X types cannot have leading signs, or any signs at all.

PIC X types do not have any COMP representation.

Precision zero is invalid. Add a '9' to the PICTURE clause.

UNSIGNED is invalid for a numeric or decimal type with a scale greater than 9.

UPSHIFT for a numeric type is invalid.

Precision greater than 18 for a COMP numeric type is invalid.

The constraint must have the same catalog and schema as the specified table.

The NOT DROPPABLE clause is allowed only in PRIMARY KEY and NOT NULL constraint definitions.

Duplicate DELETE rules specified.

Duplicate UPDATE rules specified.

Invalid size value in the ALLOCATE clause.

The specified BLOCKSIZE value is not valid.

Invalid size value in the MAXSIZE clause.

Invalid percentage value in the DSLACK clause.

Duplicate MAXSIZE clauses in the PARTITION clause.

Duplicate DSLACK clauses in the PARTITION clause.

Duplicate ISLACK clauses in the PARTITION clause.

The primary key constraint cannot be droppable when the STORE BY PRIMARY KEY clause appears in a table definition.

ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints.

The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX statement.

The [NO]AUDIT clause is not supported.

Duplicate [NO]AUDITCOMPRESS clauses.

The BLOCKSIZE clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S) statement.

Duplicate [NO]BUFFERED clauses.

Duplicate [NO]CLEARONPURGE clauses.

The [NO]COMPRESS clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S) statement.

Duplicate DEALLOCATE clauses.

The [NO]ICOMPRESS clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S) statement.

The LOCKLENGTH clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S) statement.

Duplicate MAXSIZE clauses.

The [NO]SERIALWRITES clause is not supported.

Duplicate ALLOCATE clauses.

Duplicate [NO]AUDIT clauses.

Duplicate [NO]AUDITCOMPRESS clauses.

The BLOCKSIZE clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S) statement.

Duplicate [NO]BUFFERED clauses.

Duplicate [NO]CLEARONPURGE clauses.

The [NO]COMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S) statement.

The ALLOCATE AND DEALLOCATE cannot coexist in the same ALTER TABLE statement.

The [NO]ICOMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S) statement.

Duplicate LOCKLENGTH clauses.

The [NO]AUDIT clause is not allowed in the CREATE INDEX statements.

Duplicate BLOCKSIZE clauses.

Duplicate DCOMPRESS clauses.

The DEALLOCATE clause is not allowed in the CREATE INDEX statements.

Duplicate [NO]ICOMPRESS clauses.

Duplicate [NO]SERIALWRITES clauses.

The DEALLOCATE clause is not allowed in the CREATE TABLE statements.

Duplicate LOCATION clauses.

Duplicate FILE ATTRIBUTE(S) clauses.

Duplicate DSLACK clauses.

Duplicate ISLACK clauses.

Duplicate PARALLEL EXECUTION clauses.

Duplicate PARTITION clauses.

Only the ADD option is allowed in a PARTITION clause in a CREATE TABLE statement.

Currently only range, hash and system partitioning are supported.

Duplicate PRIMARY KEY clauses.

Duplicate LIKE clauses.

The LIKE clause and STORE BY clause cannot coexist in the same statement.

Duplicate STORE BY clauses.

The LIKE clause and ATTRIBUTE(S) clause cannot coexist in the same statement.

The LIKE clause and LOCATION clause cannot coexist in the same statement.

The LIKE clause and PARTITION clause cannot coexist in the same statement.

Transaction access mode READ WRITE is incompatible with isolation level READ UNCOMMITTED

Duplicate ISOLATION LEVEL clause specified.

Duplicate transaction access mode clause specified.

Duplicate DIAGNOSTICS SIZE specified.

Identifier too long.

The WITH LOCAL CHECK OPTION clause is not supported.

The CREATE ASSERTION statement is not yet supported.

Partitioned entry-sequenced tables are not yet supported.

The format of the system name part in the specified location name

is invalid. Currently the system name part must be \NSK or /E/NSK.

UNSIGNED option is not supported for LARGEINT type.

The statement just specified is currently not supported.

PERFORM is valid only in COBOL programs.

Only LEFT, RIGHT, and FULL OUTER JOIN are valid in {oj ...}

UNION JOIN is not yet supported.

A key-sequenced table with range partitioning requires a FIRST KEY clause.

A range-partitioned index requires a FIRST KEY clause.

The isolation level cannot be READ UNCOMMITTED for an INSERT, UPDATE, DELETE, MERGE, or DDL statement.

The transaction access mode cannot be READ ONLY for an INSERT, UPDATE, DELETE, MERGE, or DDL statement.

INTO clause host variables are not allowed in a static cursor.

BROWSE or READ UNCOMMITTED access is not allowed on a table value constructor.

Positioned UPDATE or DELETE is allowed only in embedded SQL.

In an IN predicate whose right operand is a value list, the left operand must be scalar (degree of one).

Duplicate WITH CONSTRAINTS phrases in LIKE clause in CREATE TABLE statement.

Duplicate WITH HEADING phrases in LIKE clause in CREATE TABLE statement.

Duplicate WITH HORIZONTAL PARTITIONS phrases in LIKE clause in CREATE TABLE statement.

The FIRST KEY clause is not allowed with hash partitioning.

The POPULATE and NO POPULATE clauses cannot coexist in the same CREATE INDEX statement.

Catalog name is required.

Data type mismatch between output host variable and selected value.

Duplicate [ NOT ] DROPPABLE clauses.

The FOR ... ACCESS clause is not allowed in a CREATE VIEW statement.

Transaction statements are not allowed in compound statements.

EXIT is not allowed in a compound statement.

UPDATE STATISTICS is not allowed in a compound statement.

DDL statements are not allowed in compound statements.

Dynamic SQL statements are not allowed in compound statements.

Subqueries are not allowed in the IF Condition.

STREAM statements are not allowed in compound statements.

Not supported: SET STREAM TIMEOUT per a specific stream.

Cannot set lock timeout on a view.

EXTERNAL PATH clause is required.

PARAMETER STYLE clause is required.

LANGUAGE clause is required.

EXTERNAL NAME clause is badly formed.

EXTERNAL NAME clause is required.

The name for an object of this type must be fully qualified, or set NAMETYPE ANSI.

Value for DYNAMIC RESULT SETS must be zero.

UNSIGNED numeric is not allowed for routine parameter.

Internal error in the query binder.

Within an aggregate, all column references must come from the same scope.

A subquery is not allowed inside an aggregate function.

An aggregate is not allowed inside an aggregate function.

Ambiguous star column reference name.

Column name is a system column and cannot be updated or inserted into.

The operands of an INTERSECT must be of equal degree.

Aggregate functions placed incorrectly: name.

The number of derived columns (num) must equal the degree of the derived table (num).

Derived column name name was specified more than once.

Rows cannot be deleted from an entry-sequenced table.

The select list of a subquery in a select list must be scalar (degree of one).

Arithmetic operations on row value constructors are not allowed.

The select list contains a nongrouping non-aggregated column, name.

Target column name was specified more than once.

The degree of each row value constructor (num) must equal the degree of the target table column list (num).

Column name has no default value, so must be explicitly specified in the insert column list.

Error while preparing constraint name on table name.

Reading from and inserting into, or updating in, or deleting from the same table, name, is not currently supported.

Table name is not insertable.

Table

Column name is an invalid combination of datetime fields (num, num, num).

Column name is an unknown data type, num.

Column name is an unknown class, num. It is neither a system column nor a user column.

Column name is a primary or clustering key column and cannot be updated.

The operation (name name name) name is not allowed.

Type namecannot be cast to type type.

Field name cannot be extracted from a source of type type.

The operand of an AVG or SUM function must be numeric or interval.

Column name is of type type, incompatible with the value's type, type.

The operands of a BETWEEN predicate must be of equal degree.

Type name cannot be compared with type name.

The operands of a comparison predicate must be of equal degree.

The operand of function name must be character.

Collation name does not support the name predicate or function.

The operand of function name must be numeric.

The operands of function name must be exact numeric.

The operands of function name must have a scale of 0.

The third operand of a ternary comparison operator must be of type BOOLEAN, not name.

A CASE expression cannot have a result data type of both type and type.

The operands of the name predicate must be comparable character data types (that is, of the same character set and collation).

The first operand of function name must be character.

The second operand of function name must be numeric.

The third operand of function name must be numeric.

The select lists or tuples must have comparable data types. type and type are not comparable.

Exposed name name appears more than once.

Correlation name name conflicts with qualified identifier of table name.

The first operand of function name must be numeric.

Reading from and inserting into, or updating in, or deleting from the same table, name , is not currently supported. name is contained by view(s) name.

Rows cannot be inserted into, or updated in, an individual table partition.

The preceding error actually occurred in function name.

The operands of function name must be comparable character data types (that is, of the same character set and collation).

The operands of function name must be compatible character data types (that is, of the same character set).

The operands of a UNION must be of equal degree.

The operands of function name must be character data types.

The operand of function name must contain an even number of characters.

Column name uses an unsupported collation, name.

The operand of function name must be exact numeric.

The first operand of function name must be a datetime.

The operand of function name must be a datetime containing a name.

The COLLATE clause might appear only after an expression of character data type, not name.

CONTROL QUERY successful.

Division by zero in constant expression name.

Overflow in constant expression name.

Function name accepts only one or two operands.

Function name does not accept a weight operand.

The operands of function name must be numeric.

SQL/MP error: numnum.

SQL/MP error: error

Table name does not exist or is inaccessible.

SQL/MP DDL operation failed.

SQL object name is corrupt.

File organization type of object name is not supported.

Environment variable or define name does not exist.

Prototype value 'name' is not a valid qualified name.

The number of values in each TRANSPOSE item of a TRANSPOSE set must be equal.

Check constraint name contains a subquery, which is not yet supported.

The number of output dynamic parameters (num) must equal the number of selected values (num).

The number of output host variables (num) must equal the number of selected values (num).

A DEFAULT whose value is NULL is not allowed in name.

A DEFAULT specification is currently allowed only when simply contained in the VALUES list of an INSERT.

A NULL operand is not allowed in function name.

A NULL operand is not allowed in operation name.

A NULL operand is not allowed in predicate name .

A NULL value is not allowed in a select list unless it is CAST to some data type.

If name is intended to be a further table reference in the FROM clause, the preceding join search condition must be enclosed in parentheses.

The FIRST/ANY n syntax cannot be used with in an outermost SELECT statement.

If a character literal was intended, you must use the single quote delimiter instead of the double: name instead of name.

Unknown translation.

The character set for the operand of function name must be name.

Column name has no default value, so DEFAULT cannot be specified.

Inside a ROWS SINCE, another sequence function contained an invalid reference to the THIS function.

Sequence functions placed incorrectly: name.

The query contains sequence functions but no SEQUENCE BY clause: name.

The query contains a SEQUENCE BY clause but no sequence functions.

Absolute and relative sampling cannot occur in the same BALANCE expression.

The sample size for name Sampling must be num.

An absolute sample size must have a scale of zero.

The sample size must be less than or equal to the sample period.

The second operand of function name is invalid.

The cursor query expression might be nonupdatable.

The cursor query expression is not updateable.

In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the ORDER BY clause must be one of the columns explicitly SELECTed by the query. Column in error: name.

In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the ORDER BY clause must be one of the columns explicitly SELECTed by the query. Column in error: name. Table in scope: name.

NULL cannot be assigned to NOT NULL column name.

NULL cannot be cast to a NOT NULL data type.

More than one table will be locked: name.

The select list of a subquery in a row value constructor, if the subquery is one of several expressions rather than the only expression in the constructor, must be scalar (degree of one).

The row value constructors in a VALUES clause must be of equal degree.

Type type cannot be assigned to type type.

Cannot retrieve default volume and subvolume information from =_DEFAULTS define, DEFINEINFO error num.

The operation (name) is not allowed. Try UNION ALL instead.

Statement might not compile due to an order requirement on stream expression.

Groupby not supported for stream expression. Tables in scope:

Stream expressions not supported in subqueries.

Embedded DELETE statements not allowed when using DECLARE ... FOR UPDATE clause.

Stream expressions not supported for insert statements.

Stream expression not supported for top level UPDATE statements.

JOIN_ORDER_BY_USER prevented compiler from reordering query tree.

SEQUENCE BY not supported for stream expressions.

Stream expression not supported for top level DELETE statement.

Stream expressions not supported for compound statements.

Embedded UPDATE/DELETE statements are not supported within an IF statement.

Use of rowsets in a predicate with embedded UPDATE/DELETE not supported.

A CALL statement is not allowed within a compound statement.

Rowset parameters are not allowed in a CALL statement.

Internal error in the query normalizer.

Internal error in the query optimizer.

DISTINCT aggregates can be computed only for one column per table expression.

The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid values. If you have manually modified the metadata table, then you should undo your changes using the CLEAR option in UPDATE STATISTICS.

A plan using cluster sampling could not be produced for this query.

Internal executor error.

The current nowaited operation is not complete.

The descriptor is locked by another nowaited operation.

Trying to open a statement or cursor that is not in the closed state.

Trying to fetch from a cursor that is not in the open state.

The operation has been canceled.

SELECT statement inside compound (BEGIN ... END) statement returns more than one row.

Trying to update or delete from a cursor that is not in the fetched state.

A SELECT statement within a compound statement did not return any row.

Aborting transaction because a compound statement performed an update operation followed by a SELECT statement that did not return any row.

Explain information is not available for this query.

The operation is prevented by a unique constraint.

Late name resolution failed.

The length argument of function SUBSTRING cannot be less than zero or greater than source string length.

The trim character argument of function TRIM must be one character in length.

The operand of function CONVERTTIMESTAMP is out of range.

The operand of function JULIANTIMESTAMP is out of range.

The escape character argument of a LIKE predicate must be one character in length.

An escape character in a LIKE pattern must be followed by another escape character, an underscore, or a percent character.

A numeric overflow occurred during an arithmetic computation or data conversion.

An input character host variable is missing its null terminator.

The string argument contains characters that cannot be converted.

The attempted conversion is not supported on this platform.

The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.

A datetime expression evaluated to an invalid datetime value.

An error occurred during the evaluation of a USER function.

The USER function is not supported on this platform.

An arithmetic expression attempted a division by zero.

Missing indicator parameter for a NULL value.

NULL cannot be assigned to a NOT NULL column.

The provided INTERVAL is not valid and cannot be converted.

The provided field number is not valid.

NULL cannot be assigned to a DEFAULT NULL NOT NULL column.

Stream overflow; subscription rate has fallen too far behind publishing rate.

Insufficient memory to build query.

Insufficient memory to execute query.

The statement has incurred a fatal error and must be deallocated.

Statement was recompiled.

Similarity check passed.

Error returned from file system while locking/unlocking.

Trying to begin a transaction that has already been started.

Committing a transaction which has not started.

Rolling back a transaction that has not started.

Waited rollback performed without starting a transaction.

Transaction mode cannot be set if the transaction is already running.

SQL cannot commit or rollback a transaction that was started by application.

SQL cannot begin a transaction when multiple contexts exist.

An assertion failure or out-of-memory condition occurred during parallel execution.

Trying to allocate a descriptor that already exists in the current context.

Trying to allocate a statement that already exists in the current context.

The input descriptor provided does not exist in the current context.

The input statement provided does not exist in the current context.

Trying to close a statement that is either not in the open state or has not reached EOF.

Trying to execute a statement that is not in the closed state.

Trying to fetch from a statement that is in the closed state.

Error while building the TCB tree when executing the statement.

Error while executing the TCB tree.

Error while fetching from the TCB tree.

Error from root_tdb describe.

Begin transaction failed while preparing the statement.

Transaction commit failed while closing the statement.

Rollback transaction failed during the process of fetching the statement.

Unable to prepare the statement.

The input module_id does not have a module name.

Module is already added into the current context.

Unable to add the module.

Trying to set descriptor item for an entry that is either invalid or greater than the maximum entry count for that descriptor.

There is no current context.

Either no current context or the module to which the statement belongs is not added to the current context.

Transaction has not been started.

The input parameter is an invalid SQL transaction command.

Invalid SQL descriptor information requested.

Invalid update column for cursor.

Invalid user id.

Unable to receive reply from MXCMP, possibly caused by internal errors when compiling SQL statements, processing DDL statements, or executing the built in stored procedures.

Transaction was aborted.

Object name provided to CLI is invalid.

User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK.

A transaction started by SQL that was committed or aborted by user application from outside of SQL, has now been cleaned up.

Internal error: root_tcb is null.

Empty SQL statement.

Error trying to retrieve SQL/MP metadata information.

Cancel on DDL statements or stored procedures is not supported.

The table specified in this cursor update or DELETE statement is different than the table specified in the declare cursor statement.

CLI Parameter bound check error.

Holdable cursors are only supported for streaming cursors and embedded UPDATE/DELETE cursors.

Invalid attribute definition.

Invalid attribute value.

Statement attribute cannot be set now.

Invalid attribute value. INPUT_ARRAY_MAXSIZE must be positive.

There are pending insert, delete, or update operations.

Unable to create context when current transaction is implicitly started by SQL.

The specified file number is not a QFO, or the file number is not internally associated with a QFO object (CLI internal error).

The current statement is not associated with any QFO.

Unable to execute a new operation while there is another nowaited operation pending.

The current statement is already associated with a QFO.

Cannot remove the current context.

The specified CLI context handle is not found

Containing SQL not permitted.

The current context has violation checking functions disabled. Use SQL_EXEC_SetUdrAttributes_Internal() to enable it.

Prohibited SQL statement attempted.

The SQL compiler failed to initialize properly. Query results might differ from what is expected, due to different compiler defaults.

Buffer to return SQL/MP metadata information too small.

The statement argument count does not match the descriptor entry count.

RPC exception in CLI request from non-trusted shadow client to trusted shadow server.

Internal error in CLI.

The MXUDR server for this statement is no longer running. The statement will be assigned a new MXUDR server if it is executed again.

Internal error: MXUDR returned an invalid UDR handle.

Unable to receive reply from MXUDR, possibly caused by internal errors while executing user-defined routines.

An invalid or corrupt MXUDR reply could not be processed, possibly due to memory corruption in MXUDR while executing friendly user-defined routines or an internal error in SQL/MX.

You are not allowed to generate histogram statistics on an ISO88591 CHARACTER SET column which contains a null terminator character. You need to exclude this column from the column group list in UPDATE STATISTICS.

Unable to access column definitions.

One of the column data types is not supported by UPDATE STATISTICS. You need to exclude this column from the column group list in UPDATE STATISTICS.

Cardinality statistics will be more accurate if you use SET ROWCOUNT option in the SAMPLE clause.

If you intend to update histogram statistics for columns, you must specify a column group list in the statement.

Sort Error: No error text is defined for this error

Sort Error: Warning: Scratch File EOF

Sort Error: Merge is disallowed for Sort

Sort Error: Unexpected error value. Check error

Sort Error: Previous IO failed

Sort Error: Error writing to Scratch File

Sort Error: Invalid sort algorithm selected

Sort Error: Run number is invalid

Sort Error: Error reading Scratch File

Sort Error: Scratch Block number is invalid

Sort Error: No fixed disks to sort on

Sort Error: No memory to allocate scratch space

Sort Error: PROCESSHANDLE_GETMINE_ failed

Sort Error: PROCESSHANDLE_DECOMPOSE_ failed

Sort Error: DEVICE_GETINFOBYLDEV_ failed

Sort Error: FILENAME_FINDSTART_ failed

Sort Error: FILENAME_FINDNEXT_ failed

Sort Error: FILENAME_FINDFINISH_ failed

Sort Error: FILE_GETINFOLISTBYNAME_ failed

Sort Error: FILE_CREATE failed

Sort Error: FILE_OPEN_ failed

Sort Error: SetMode failed

Sort Error: AWAITIOX failed

Sort Error: FILE_GETINFOLIST failed

Sort Error: POSITION failed

Sort Error: FILE_GETINFO_ failed

Sort Error: IO did not complete

Sort Error: Wrong length read

MXUDR: Unexpected error during message processing:

Language Manager initialization failed. Details: Unable to initialize JVM.

The Language Manager failed to create its class loader, possibly due to corrupt LmClassLoader.class file.

Specified signature is invalid. Reason: The list of parameter types must be enclosed in parentheses.

Specified signature is invalid. Reason: Java signature size is more than supported.

Specified signature is invalid. Reason: A return type must not be specified.

The operation failed because the Java Virtual Machine ran out of memory.

All SQL parameters associated with a Java main method must have a parameter mode of IN.

All SQL parameters associated with a Java main method must be an SQL character type.

Internal Error. Unable to translate SQL statement.

This feature is unsupported.

No error.

Missing output file argument after the -c option.

Missing module definition file argument after the -m option.

Missing listing file argument after the -l option.

Missing timestamp argument after the -t option.

Help for SQLC and SQLCO is available by typing SQLC or SQLCO on the command line.

The EXEC SQL MODULE statement must precede any cursor definitions or executable SQL statements.

Only one EXEC SQL MODULE statement is allowed.

Expecting a single host variable of type string.

Missing module specification string argument after -g option.

SQLCO errors

Source file name must be specified.

Missing timestamp command option.

The SQL declare section might not contain COPY or REPLACE.

End of input file while processing EXEC SQL.

Input file error while processing EXEC SQL.

The BIT data type is not implemented in SQL/MX.

The CHARACTER SET attribute is not implemented in SQL/MX.

DECLARE SECTION cannot be nested.

END DECLARE SECTION without a matching BEGIN DECLARE SECTION.

DECLARE SECTION encountered in unexpected program section.

The first declaration in an SQL DECLARE SECTION must have level 01 or 77.

SQLCI error messages.

The specified statement does not exist in the history buffer.

The requested help topic is too long.

The help file could not be opened.

File read error on the help file.

This command is not supported by the SQLCI OLE server.

Break was received. The last statement might be lost.

The USING list must contain at least one parameter value.

Cursor operations are not supported by SQLCI.

Break rejected.

Break error.

The specified define already exists. Use alter or delete and add.

The specified define does not exist.

An error occurred while adding, altering or deleting this define.

Break was received.

Invalid LOG file name.

Permission denied to access this file

Invalid Filecode OR Invalid Function Argument

SQLCI internal error.

Internal error in internal stored procedure processing.

Error in field description of internal stored procedure.

Internal stored procedure failed without any error information returned.

SQL Utilities error messages.

A rowset must be composed of host variable arrays.

Rowset size must be an integer host variable or constant.

The dimensions of the arrays composing the rowset are different. The smallest dimension is assumed.

Rowset and one-dimensional variable are in output list.

Internal error. Rowset index is out of range.

Internal error. Trying to add more elements than maximum rowset size.

More than one INTO statement in the same query is not supported.

Hostvar used to set input size of rowset has zero or negative value.

Hostvar used to set input size of rowset is not of type short, int, or long.

Embedded UPDATE/DELETE cannot be used with SELECT...INTO and rowset.

Error message file not found.

The "no data" completion condition (SQLCODE = +100).

The "no data" completion condition (SQLCODE=+100).

The statement argument count does not match the descriptor entry count.

Trying to set descriptor item for an entry that is either invalid or greater than the maximum entry count for that descriptor.

The statement just specified is currently not supported.

Currently only supporting restrict drop behavior.

SQL system metadata not supported by this catalog manager version.

Self-referencing constraints are currently not supported.

The constraint, index, or file option is not supported on a vertically partitioned table.

Attempting to change the audit flags for a table in an unsupported way.

Attempting to add a column with a NULL, UNIQUE, CHECK, PRIMARY KEY, or FOREIGN KEY constraint defined. This is not supported for a nonaudited table.

This feature is unsupported.

This command is not supported by the SQLCI OLE server.

Cursor operations are not supported by SQLCI.

A simple value specification that is a literal is not yet supported.

DROP ASSERTION statement is not yet supported.

The COLLATE clause in a sort specification is not yet supported.

The MATCH PARTIAL clause is not yet supported.

Specifying a privilege column list in the INSERT clause is not yet supported.

The PARALLEL EXECUTION clause is not yet supported.

CASCADE drop behavior is not yet supported.

The COLUMN clause in the ALTER TABLE statement is not yet supported.

The MOVE clause in the ALTER TABLE statement is not yet supported.

The PARTITION clause in the ALTER TABLE statement is not yet supported.

The RENAME clause in the ALTER TABLE statement is not yet supported.

The SET CONSTRAINT clause in the ALTER TABLE statement is not yet supported.

The [NO]AUDIT clause is not supported.

The [NO]SERIALWRITES clause is not supported.

Currently only range, hash and system partitioning are supported.

The WITH LOCAL CHECK OPTION clause is not supported.

The CREATE ASSERTION statement is not yet supported.

Partitioned entry-sequenced tables are not yet supported.

UNSIGNED option is not supported for LARGEINT type.

The statement just specified is currently not supported.

UNION JOIN is not yet supported.

A DEFAULT specification is currently allowed only when simply contained in the VALUES list of an INSERT.

DISTINCT aggregates can be computed only for one column per table expression.

The attempted conversion is not supported on this platform.