OS/400 Messages

Are you looking for the description of OS/400 (System i) messages e.g. CPF9801? Then you have come to the right place. Below you can see a (hoefully) complete list of of all OS/400 messages with all “second level texts”.

Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43


Complete OS/400 Messages Documentation From SDY0763 up to SQL7906

Complete OS/400 Messages Documentation From SDY0763 up to SQL7906

This documentation is copyright by IBM.
Count: 1086 Skipped: 0
OS/400 Messages
Description
XPath expression cannot be processed.
XML declaration in XML document not valid.
Incomplete annotation mapping at or near &1 in XML schema document &2. The reason code is &3.
Source XML type &1 cannot be mapped to target SQL type &2.
Unknown annotation &1 at or near &2 in XML schema document &3.
The db2-xdb:expression annotation &1 at or near &2 in XML schema document &3 is too long.
More than one db2-xdb:defaultSQLSchema exists within the XML schema.
Duplicate annotation defined for &1 at or near &2 in XML schema document &3.
The db2-xdb:rowSet &1 near &2 in the XML schema document &3 is associated with another table.
The db2-xdb:condition annotation &1 at or near line &2 in XML schema document &3 is too long.
A db2-xdb:locationPath &1 near &2 in XML schema document &3 is not valid with reason code &4.
A db2-xdb:rowSet value conflicts with a db2-xdb:table annotation with the same name.
XML schema feature &1 is not supported for decomposition.
The XML schema contains a recursive element which is an unsupported feature for decomposition.
Many-to-many mappings relationship between elements that map to the same rowset is not valid.
XML schema annotations include no mappings to any column of any table.
The annotated XML schema has no columns mapped for the rowset &1.
THE ROWSET NAME &1 AT OR NEAR &2 IN THE XML SCHEMA DOCUMENT &3 IS NOT USED IN ANY MAPPING.
ROWSET NAME &1 AT OR NEAR &2 IN THE XML SCHEMA DOCUMENT &3 CANNOT BE USED MORE THAN ONCE UNDER &4.
XML schema &1 in &2 is not enabled for decomposition.
Error occurred during decomposition of XML document &1.
THE GLOBAL ANNOTATION &1 APPEARS MORE THAN ONCE IN THE XML SCHEMA.
XSLT processor error.
File &1 in &2 has DataLinks in link pending mode.
Result column not compatible with column &1 in materialized query table.
Subselect for materialized query table &1 not valid for reason code &3.
Attribute not valid for function &1 in &2.
Attempt to ALTER table &1 in &2 failed. Reason code &3.
&3 cannot be specified for routine &1.
Cannot implicitly connect to a remote site with a savepoint outstanding.
The maximum number of savepoints has been reached.
SQL TABLE function must return a table result.
Truncation of value with length &1 occurred for &2.
Encryption or decryption function failed.
Encryption password length not valid.
The decryption function failed.
The decryption function failed. The data is not encrypted.
The ENCRYPT function failed. Data is already encrypted.
RETURN statement must be specified in function &1 in &2.
Data change table reference not allowed where specified.
View or logical file &1 not allowed for data change table reference.
INSTEAD OF trigger not created for view &1.
Trigger cannot be created for view &1 that uses a WITH CHECK OPTION.
Column &1 cannot be altered.
ALTER TABLE partitioning clause not valid for &1.
The install or replace of &1 in &2 failed because &3 could not be located.
The install, replace, or remove of &1 in &2 failed because the jar name is not valid.
The replace or remove of &1 in &2 failed because &3 is in use.
Signature not valid for Java method in user defined function or procedure &1 in &2.
The user defined function or procedure &1 in &2 was unable to map to a single Java method.
User defined function or procedure &1 in &2 has an input argument with a null value.
The procedure &1 in &2 returned too many result sets.
The install or remove jar procedure for &1 in &2 specified the use of a deployment descriptor.
Clause not allowed for CREATE VIEW.
Table designator &1 is not ordered.
The encryption or decryption function failed. Encryption facility error.
Encrypted data that was originally a binary string cannot be decrypted to a character string.
The maximum number of stacked diagnostics areas has been exceeded.
AS clause required for XML function.
A STACKED diagnostic is not available.
Alter of materialized query table &1 in &2 not valid.
Cursor &1 cannot be returned.
Index &1 cannot be both an encoded vector index and span all partitions.
&1 in &2 cannot be altered.
Table &1 cannot be partitioned and contain an identity or ROWID column.
Partition &1 cannot be dropped.
INSERT into view &1 in &2 with INSTEAD OF trigger not allowed.
Use of INPUT SEQUENCE ordering not correct.
View &2 not allowed in data change table reference.
Sort sequence cannot be applied. Reason code &4.
XML name &1 not valid.
XML namespace prefix &1 not valid.
VALUE specified for GET DESCRIPTOR is greater than current COUNT.
Item &1 already set for descriptor.
DEBUG MODE cannot be changed for routine &1 in &2.
XML name &1 too long.
An XML schema document with the same target namespace and schema location already exists.
The completion check for the XML schema failed because one or more XML schema documents are missing.
XML schema identified by target namespace &3 and schema location &5 not found in the repository.
The XML comment value &1 is not valid.
The XML processing instruction &1 is not valid.
More than one XML schema exists identified by the target namespace and schema location.
The data type of the XMLCAST specification must be XML.
XML schema &1 in &2 not in correct state for operation &3.
XML schema document is not connected to the other XML schema documents.
XML value not a well-formed document.
Specified global element not in XML schema.
Required root element not in XML document.
Row change timestamp column not valid for key.
Signaling NaN encountered, or exception occurred involving DECFLOAT.
Clause &1 ignored.
Character &1 cannot be mapped to a valid XML character.
XML parsing failed.
XML parsing or validation failed.
XML schema document did not process.
Serialization of XML value resulted in conversion error.
Table &1 in &2 must contain a column that is not hidden.
Error occurred during text search processing.
Text search support is not available for reason &1.
Text search not allowed for column &1.
Conflicting text search administration procedure already running.
Error occurred during text search administrative procedure.
Global variable &1 in &2 may not be used in this context.
ROW CHANGE TIMESTAMP expression not valid for table &1 in &2.
UPDATE statement cannot have all columns set to UNASSIGNED value.
Data type not valid for array.
Operation only allowed for array variables.
Array subscript value not correct data type.
Value &1 not valid for array subscript.
Cardinality &1 of source array greater than maximum &2 of target array.
Array type not valid where specified.
CCSID was changed.
Format string not valid for function &1.
Expression not valid using format string specified for TIMESTAMP_FORMAT.
CYCLE DETECTED IN HIERARCHICAL QUERY.
HIERARCHICAL QUERY CONSTRUCT &1 NOT USED CORRECTLY.
Text search index &1 may be out of date.
Result sets not returned because procedure called by function or trigger.
Index &1 cannot be both an encoded vector index and span all partitions.
Distributed Relational Database Architecture (DRDA) protocol error.
Call to distributed SQL program not allowed.
Distributed Relational Database Architecture (DRDA) protocol error.
Distributed relational database not supported by the remote system.
DRDA resources at relational database &1 unavailable.
DRDA resources at relational database &1 unavailable.
DDM command &1 not valid while bind process in progress.
Bind process for specified package name and consistency token not active.
Program preparation assumptions not correct.
Not authorized to create package for owner &1.
User is not authorized to relational database &1.
Relational database &1 not found.
Distributed Data Management (DDM) command &1 not supported.
Distributed Data Management (DDM) object &1 not supported.
Distributed Data Management (DDM) parameter &1 not supported.
Distributed Data Management (DDM) parameter value &1 not supported.
Distributed Data Management (DDM) reply message &1 not supported.
Communication error occurred during distributed database processing.
Communication error has been detected during distributed database processing.
Authorization failure on distributed database connection attempt.
Communication error occurred during DB2 Multisystem processing.
Change request not valid for read-only application server.
Bind or precompile option &1 with value &2 not valid.
The input data for a multiple row insert is not valid.
A request to release record read locks on close of cursor was ignored.
Error occurred in SQL Call Level Interface
Member &1 for SQL INCLUDE not found or not authorized.
Character &1 (HEX &2) not valid in SQL statement.
Nested INCLUDE statements not supported.
String constant beginning &1 not delimited.
Comment not closed.
Correlation without qualification occurred for column &1 to table &2.
&1 assumed.
Bind or precompile option(s) &1 (name or value) are not supported.
INTO clause missing from embedded statement.
Number of host variables less than result values.
Program contains more than 32766 SQL statements.
Cursor or procedure &1 previously declared.
No SQL statements found.
RETURN statement in an SQL function must return a value.
Value specified on RETURN statement must be an integer.
Value &3 for argument &1 of &2 function not valid.
Descriptor COUNT &1 is not valid.
Descriptor item number &1 is not correct.
DATA or INDICATOR item not correct.
Descriptor name &1 not correct.
Parameter name required for routine &1 in &2.
Schema &2 for object &1 not valid.
Indicator variable &1 not SMALLINT type.
SQL statement not allowed.
Variable cannot be NULL.
&1 applies to entire table.
Host variable not permitted here.
Use of data type not valid.
Operator in JOIN condition not valid.
Row not found for &1.
SQL statement too long or complex.
String constant beginning with &1 too long.
Numeric constant &1 not valid.
Token &1 was not valid. Valid tokens: &2.
Mixed, graphic, or UTF-8 string constant not valid.
Precision specified for FLOAT or DECFLOAT not valid.
&1 too long. Maximum &2 characters.
&1 clause not allowed.
Hexadecimal constant beginning with &1 not valid.
Column function &1 does not include column name.
Argument of function &1 contains another function.
Name &1 not allowed.
Relational database &1 not the same as current relational database &2.
Comparison operator &1 not valid.
Statement contains wrong number of values.
Table &1 in &2 also specified in a FROM clause.
Column &1 or expression in HAVING clause not valid.
Use of function &1 not valid.
Duplicate name &1 not allowed.
Column &1 or expression in SELECT list not valid.
ORDER BY column number &1 not valid.
Use of NULL is not valid.
Too many tables in SQL statement.
ESCAPE character &1 or LIKE pattern is not valid.
Operands of LIKE not compatible or not valid.
LIKE predicate not valid.
Operator on correlated column in SQL function not valid.
String, argument, or path too long.
ORDER BY, GROUP BY, or join columns too long.
Result too long.
Argument &1 of substringing function not valid.
SET SESSION AUTHORIZATION statement is not allowed.
Statement &1 ignored.
Section number &1 not valid. Current high section number is &3. Reason &2.
Recursion not supported for application server other than DB2 for IBM i.
View or logical file &1 in &2 read-only.
Column &1 in table &2 in &3 is not updatable.
Constraint type not valid for constraint &1 in &2.
Column list required.
UNION and UNION ALL for CREATE VIEW not valid.
Transition table &1 read-only.
&1 in &2 not correct type.
&1 in &2 not valid in FOREIGN KEY clause.
Number of columns specified not consistent.
&1 in &2 not correct type.
WITH CHECK OPTION not allowed for view &1 in &2.
INSERT or UPDATE not allowed because a resulting row does not satisfy view definition &1 in &2.
Number of arguments for function &1 not valid.
Argument &1 of function &2 not valid.
Function &1 not allowed in INCLUDE.
Maximum number of sections exceeded. Program has too many SQL statements.
COMMIT, ROLLBACK, or SAVEPOINT failed.
CHECK condition text too long.
Query expression text for view &1 in &2 too long.
Syntax of date, time, or timestamp value not valid.
Value in date, time, or timestamp string not valid.
A date, time, or timestamp expression not valid.
Result of date or timestamp expression not valid.
Parameter marker not valid in expression.
Use of labeled duration not valid.
&1 not a valid string representation of a name.
Coded Character Set Identifier &1 not valid.
Attributes of column &3 in &1 in &2 not compatible.
Mixed data or UTF-8 data not properly formed.
Argument of translation function not valid.
KEEP LOCKS not allowed.
Last column of &1 in &2 cannot be dropped.
Column &3 in &1 in &2 cannot be dropped.
Column &1 cannot be qualified.
SQL statement empty or blank.
Keyword &1 not expected. Valid tokens: &2.
Name &1 is ambiguous.
&1 in &2 type *&3 not found.
Column &1 not in table &2 in &3.
Column or global variable &1 not found.
ORDER BY column &1 or expression not in result table.
Duplicate table designator &1 not valid.
Parameter &1 not in routine &2 in &3.
ORDER BY expression is not valid.
Number of values in predicate lists do not match.
Number of rows &2 not valid.
FETCH not valid; cursor &1 not scrollable.
Current row deleted or moved for cursor &1.
FETCH not valid, cursor &1 in unknown position.
FOR UPDATE clause not valid with SCROLL for cursor &1.
Position of cursor &1 not valid for FETCH of current row.
Not enough SQLVAR entries were provided in the SQLDA.
Not enough entries were provided in the SQLDA or descriptor area.
Duplicate attribute name or partition name &1.
SENSITIVE cursor &1 cannot be defined for the specified SELECT statement.
Local relational database not defined in the directory.
Character in relational database name &1 not valid.
Function not supported for query.
Constraint &1 in &2 not allowed on distributed file.
Function not allowed for table &1 in &2.
Input variable &2 or argument &1 not valid.
Conversion error on variable or parameter &2.
Variable &2 not compatible or value too long.
Conversion error in assignment to variable &2.
Indicator variable required.
REXX input host variable &1 not defined.
Length in varying-length, LOB, or XML host variable not valid.
Variable &1 not defined or not usable.
Number of host variables not valid.
Host variable &1 not unique.
Too many variables specified.
Partitioning key does not correspond to a defined partition.
Column &1 not allowed in partitioning key.
The SET PATH name list is not valid.
Character conversion cannot be performed.
Character conversion cannot be performed.
Character conversion between CCSID &1 and CCSID &2 not valid.
Character conversion resulted in truncation.
Character conversion resulted in substitution characters.
Identity or sequence attribute is not valid.
JOIN predicate or MERGE ON clause not valid.
Duplicate name &1 for common table expressions.
Cyclic references between common table expressions.
Keyword not allowed in recursive common table expression &1.
Column list not valid for table.
Recursive common table expression &1 is not valid.
Recursion not allowed for common table expressions.
&1 expression not used correctly.
Column &1 not valid.
The AR is not at the same level and DB2 cannot transform the data type to a compatible type.
The AS is not at the same level and DB2 cannot transform the data type to a compatible type.
Index expression &1 not valid.
File server &1 used in DataLink not currently available.
Error &1 occurred using DataLink data type.
Value for identity column or sequence not available.
DataLink in table &1 in &2 may not be valid due to pending links.
Flagging detected an error in the current SQL statement.
Extended indicator variable value for item &1 not valid.
DECFLOAT exception &1 during arithmetic operation or assignment.
Use of extended indicator variable value not valid.
Only one ROWID, IDENTITY, or ROW CHANGE TIMESTAMP column allowed.
DEFAULT cannot be specified for column &1.
SQL routine &1 in &2 created with assignment to SQLCODE or SQLSTATE.
No additional result sets returned.
Use of function &1 in &2 not valid.
Table function cannot be argument of function &1.
Assignment of LOB or XML to specified host variable not allowed.
Value specified for condition or diagnostic is not valid.
AS LOCATOR can only be specified for a LOB or XML parameter.
Value for ROWID column &1 not valid.
Comparison operator &1 operands not compatible.
&1 use not valid.
Alias &1 in &2 created but table or view not found.
Value for column or variable &1 too long.
Numeric constant &1 out of range.
Conversion error on assignment to column &2.
Null values not allowed in column or variable &5.
Value for column or variable &1 not compatible.
Floating point literal &1 not valid.
Subselect with more than one result column not valid.
Operand not valid in LIKE predicate.
UNION, EXCEPT, INTERSECT, or VALUES operands not compatible.
Combination of parameter markers not valid.
Use of parameter marker not valid.
Negative scale not valid.
Character in CAST argument not valid.
Number of columns not consistent.
Locator &1 not valid.
Dynamic COMMIT is not valid for the application environment.
Dynamic ROLLBACK is not valid for the application environment.
SQL statement cannot be run.
The maximum number of concurrent LOB and XML locators has been reached.
A parameter marker cannot have the user-defined type name &1.
Significant data truncated during CAST or XMLSERIALIZE.
SQLSTATE value &1 not valid.
Message &1 returned from SIGNAL, RESIGNAL, or RAISE_ERROR.
Routine &1 in &2 not found with specified parameters.
Clause or keyword &1 not valid where specified.
Too many parameters for procedure &1 in &2 on CALL statement.
Trigger program or external routine detected an error.
External program &4 in &5 not found.
Value of parameter &4 in procedure &1 in &2 too long.
Conversion error in assignment of argument &2.
Too many parameters or result sets for routine &1 in &2.
External program name for routine &1 in &2 not valid.
Attributes of parameter &1 not valid for procedure or function &3 in &4.
Unable to access a file that is referred to by a file reference variable.
Return type for function &1 in &2 not compatible with CAST TO type.
Routine &1 in &2 already exists.
Schema &2 for specific name not same as routine schema &3.
Specific name &3 in &2 already exists.
Name &1 in &2 not allowed for function.
Function &1 in &2 not found with matching signature.
Truncation of data may have occurred for ALTER TABLE of &1 in &2.
CAST from &1 to &2 not supported.
Procedure or user-defined function &1 in &2 returned a warning SQLSTATE.
SQLSTATE &4 returned from routine &1 in &2 not valid.
Procedure &1 returned &3 result sets, which exceeds the defined limit of &4.
&3 result sets are available from procedure &1 in &2.
Another result set exists for procedure &1 in &2.
IN, OUT, or INOUT not valid for parameter &4 in procedure &1 in &2.
Null values not allowed for parameter &4 in procedure &1 in &2.
Name &1 cannot be used for user-defined type.
RETURNS data type for function &3 in &4 not valid.
Routine &1 in &2 not unique.
Object &1 of type &3 cannot be dropped or altered.
Procedure &1 not previously called.
Procedure &1 returned no locators.
Parameters for function &1 in &2 not same as sourced function.
Routine &1 in &2 already exists.
SQL statements not allowed.
Numeric value &1 not valid.
Clause not correct for procedure or function.
Data type for function &1 in &2 not valid for source type.
Fewer locators than number of result sets.
Cursor &1 already assigned to result set.
Cursor &1 not open.
Cursor &1 already open or allocated.
Column &3 cannot be updated.
Cursor &1 not declared.
Cursor &1 not open.
Cursor &1 not positioned on locked row.
Table &2 in &3 not same as table in cursor &1.
Cursor &1 for table or view &2 read-only.
FOR UPDATE clause not valid.
Statement references objects in multiple databases.
Alias &1 in &2 cannot reference another alias.
Prepared statement &2 not found.
Prepared statement &2 not found.
Prepared statement &2 not select-statement.
Prepared statement &1 not found.
Prepared statement &2 in use.
Cannot UPDATE or DELETE on cursor &1.
Statement not valid on application server.
Statement not valid for &1 TEMPORARY TABLE &2 in &3.
ALWCPYDTA(*NO) specified but temporary result required for &1.
Operation not allowed by referential constraint &1 in &2.
Update prevented by referential constraint &1 in &2.
Delete prevented by referential constraint &1 in &2.
Delete not allowed because table &1 in &2 in subquery can be affected.
Duplicate column name &1 in definition of key.
The FOREIGN key in constraint &1 in &2 not same as the parent key.
Table &1 in &2 does not have a primary or unique key.
Duplicate UNIQUE constraint exists for table &1 in &2.
Null values not allowed for column &1 of a PRIMARY key.
Constraint &1 conflicts with SET NULL or SET DEFAULT rule.
CHECK constraint &1 cannot be added.
INSERT, UPDATE, or MERGE not allowed by CHECK constraint.
CHECK condition of constraint &1 not valid.
Not authorized to object &1 in &2 type *&3.
Not authorized to &1.
Schema name &1 not allowed.
Privilege not valid for table or view &1 in &2.
Authorization name &1 is not allowed.
Not all requested privileges revoked from object &1 in &2 type *&3.
Not all requested privileges to object &1 in &2 type *&3 granted.
Table &1 in &2 does not have a matching parent key.
Column or sequence attribute is not valid.
Modifying SQL data not permitted.
RETURN statement not executed for SQL function &1 in &2.
Reading SQL data not permitted.
At least one result in CASE expression must be not NULL.
The results in a CASE expression are not compatible.
Use of function &1 in &2 not valid.
NULL or parameter marker in VALUES not allowed.
Schema &1 used incorrectly in the specified path.
Name &1 specified in procedure or function &2 not unique.
Row change timestamp column &1 must be NOT NULL.
Commit level *&1 escalated to *&2 lock.
Error occurred during DISCONNECT of relational database &1.
&1 in &2 type *&3 already exists.
More than 120 columns specified for CREATE INDEX.
Unique index cannot be created because of duplicate keys.
Attributes not valid.
Operation not allowed on system table &1 in &2.
&1 is a duplicate column name.
Key is too long or contains too many columns.
Length of columns for CREATE INDEX too long.
Object &1 in &2 type *&3 not dropped. It is in use.
&1 in &2 type &3 cannot be dropped with RESTRICT.
Table &1 in &2 already has a primary key.
Clauses not valid in same definition.
SET NULL not allowed for referential constraint &1 in &2.
Foreign key for referential constraint &1 in &2 too long.
Ranges specified for partition &1 not valid.
Keyword or clause starting with &1 not valid.
Maximum number of constraints exceeded for &1 in &2.
ATTRIBUTES value &1 not valid.
WHERE NOT NULL clause ignored for index &1 in &2.
Function &1 in &2 cannot be dropped.
Partitioned index cannot be created for &1 in &2.
Number of partitioning values is not correct.
The partition name or number &1 is not valid.
SQL query exceeds specified time limit or storage limit.
FOREIGN key value does not match a value in the parent key of constraint &1 in &2.
Specified delete rule not allowed with trigger on table &1 in &2.
Data type of literal &1 not compatible with column &3.
Object &1 in &2 type *&3 not created due to pending operation.
Too many columns specified.
Field procedure on column &1 returned SQLSTATE &5.
Program name &1 for field procedure cannot be used.
Clause not valid for specified type.
FIELDPROC list of constants too long.
Field procedure on column &1 has returned invalid data.
Correlation name or table &3 not valid.
REFERENCING OLD or NEW not valid for statement trigger.
Name &1 in &2 not allowed.
Value for &2 is not correct.
SQL trigger &1 in &2 failed with SQLCODE &3 SQLSTATE &4.
Too many cascaded trigger programs.
Evaluation of global variable &5 in &6 failed.
SQL statement &1 not allowed.
Connection cannot be changed. Reason code is &1.
Use of ROWID not valid.
Case not found for CASE statement.
Statement cannot be executed within a compound SQL statement.
Statement not allowed in specified SQL routine.
Cursor &1 specified in FOR statement not allowed.
Nested compound statements not allowed.
End label &1 not same as begin label.
Label &1 specified not valid.
UNDO specified for a handler not valid.
Condition &1 specified in handler not defined.
Condition value &1 specified in handler not valid.
Select list for cursor &1 in FOR statement not valid.
Constraint &1 cannot be dropped.
Use of SQLCODE or SQLSTATE not valid.
RESIGNAL statement not within a handler.
Duplicate row identified for MERGE target &1 in &2.
Value cannot be specified for GENERATED ALWAYS column &1.
Special register &1 does not exist at the application server.
Data conversion or data mapping error.
Duplicate key value specified.
SQLDA or descriptor area not valid.
SQL package &1 in &2 not found at DRDA Server.
Row length exceeds 3.5 gigabytes.
Result of SELECT more than one row.
Update operation not allowed.
Consistency tokens do not match.
Address in the SQLDA or descriptor area not valid.
&1 in &2 type *SQLPKG cannot be accessed.
Number of selected items exceeds 8000.
Connection to relational database &1 already exists.
Connection to relational database &1 does not exist.
PREVIOUS VALUE for sequence &1 cannot be used.
Attributes not valid for IDENTITY column or sequence.
Cannot disconnect relational database &1 due to LU6.2 protected conversation.
Local program attempted to connect to a remote relational database.
Mixed or DBCS CCSID not supported by relational database &1.
Constraint attempted to update or delete a row of table &3.
Too many CCSID values specified.
Savepoint &1 does not exist or is not valid in this context.
Savepoint &1 already exists.
Savepoint does not exist.
Application process not in a connected state.
SQL system error.
Resource limit exceeded.
Operation not performed because of previous error.
Data change violation occurred.
Object &1 in &2 type *&3 has a pending change.
Row or object &1 in &2 type *&3 in use.
ROLLBACK required.
Relational database &1 not in relational database directory.
Object &1 in &2 not altered.
Processing of the SQL statement ended. Reason code &1.
Error occurred while passing request to application requester driver program.
Constraint &4 in check pending state.
Trigger &1 attempted to modify a row in table &3.
Outcome unknown for the unit of work.
External file definition for &1 not found.
Member &3 file &1 in &2 for /COPY not found.
Nested /COPY statements not allowed.
END-EXEC or continuation expected but not found.
SQL statement not in calculation specifications.
SQL statement &1 is out of order.
END DECLARE SECTION statement is missing.
Column definitions for table &1 in &2 not found.
Not authorized to object &1 in &2 type *&3.
Object &1 in &2 not found.
RPG specification out of order.
Not authorized to object &1 in &2 type *&3 at &4.
Column definitions for table &1 in &2 at &4 not found.
Column definitions for table &1 in &2 at &4 not found. SQLCODE returned: &5, Message: &6
Input file CCSID is &1 but &3 was created with CCSID of &2.
Parser tokens cannot be converted using source file CCSID &1. Precompile may fail.
&1 Flagging -- Parameter &2 not supported.
&1 Flagging -- BEGIN DECLARE SECTION statement required.
&1 Flagging -- DB2 for IBM i errors detected. Flagging still attempted.
&1 Flagging -- Name &2 too long. Maximum length &3 characters.
&1 Flagging -- Reserved word &2 used as an SQL identifier.
&1 Flagging -- Name &2 not allowed.
&1 Flagging -- Statement &2 not supported.
&1 Flagging -- Syntax deviation. Token &2 not valid. Previous tokens &3 &4.
&1 Flagging -- Host variable &2 declared by copying DDS.
&1 Flagging -- Host variable definition of &2 not supported.
&1 Flagging -- Indicator array &2 not supported.
&1 Flagging -- Multiple DISTINCT keywords in SELECT list.
&1 Flagging -- DECLARE CURSOR not allowed in DATA DIVISION.
&1 Flagging -- Subquery contains GROUP BY or HAVING clauses.
&1 Flagging -- Embedded ILE RPG not supported.
&1 Flagging -- Host variable name &2 not valid.
&1 Flagging -- Floating point constant &2 out of range.
&1 Flagging -- Constant &2 too long. Maximum length &3.
&1 Flagging -- Indicator &2 must be small integer.
&1 Flagging -- Declaration of &2 not valid.
&1 Flagging -- Host variable &2 too long. Maximum length &3.
&1 Flagging -- &2 not supported for dynamic SQL.
&1 Flagging -- Stand-alone SQLCODE attribute not supported.
&1 Flagging -- Number of items in select list exceeds 255.
&1 Flagging -- Column &2 longer than &3 characters.
&1 Flagging -- Duplicate column name &2.
&1 Flagging -- Number of columns in GROUP BY exceeds 16.
&1 Flagging -- Number of columns in ORDER BY exceeds 16.
&1 Flagging -- Number of columns in key definition exceeds 16.
&1 Flagging -- Number of columns in table definition not correct.
&1 Flagging -- PRIMARY KEY specified more than one time.
&1 Flagging -- Number of columns in view exceeds 140.
&1 Flagging -- Statement references more than 15 tables.
&1 Flagging -- Statement contains more than 256 host variables.
&1 Flagging -- Number of predicates in WHERE or HAVING exceeds 200.
&1 Flagging -- Column lists do not match.
&1 Flagging -- Option specified more than one time.
&1 Flagging -- Key cannot allow the NULL value.
&1 Flagging -- CHECK condition not valid.
&1 Flagging -- NOT NULL column must have default that is not NULL.
&1 Flagging -- Default value not compatible with column.
&1 Flagging -- ESCAPE character does not have length of 1.
&1 Flagging -- Embedded RPG not supported.
&1 Flagging -- Embedding of host language comments not supported.
&1 Flagging -- Data Definition Language (DDL) statement not in a schema.
&1 Flagging -- Declaration of &2 not valid.
&1 Flagging -- Declaration of indicator variable &2 not valid.
&1 Flagging -- Stand-alone SQLCODE attribute not supported.
&1 Flagging -- No stand-alone SQLSTATE declared.
&1 Flagging -- Stand-alone SQLSTATE is preferred over stand-alone SQLCODE.
&1 Flagging -- Parameter name &2 not correct.
&1 Flagging -- &2 specified more than one time.
&1 Flagging -- External routine clause not correct.
&1 Flagging -- SQL routine clause not correct.
&1 Flagging -- Literal value not correct.
&1 Flagging -- Variable name &2 not specified correctly.
System column name &1 ignored.
Data type changed to equivalent data type supported by the standards option.
Data type changed to similar data type supported by the standards option.
DATALINK or ROWID data type changed to character data type.
Number of members for &1 in &2 not valid.
Key or attribute for &1 in &2 ignored.
Format, number of dependent tables, or select/omit specifications ignored for &1 in &2.
Nodegroup or partitions ignored for &1 in &2.
Format name &3 for &1 in &2 ignored.
System trigger &1 in &2 ignored.
&3 in table &1 in &2 ignored.
&3 for schema &1 ignored.
&4 in column &3 ignored.
&3 changed to &4.
&3 changed to equivalent language supported by the standards option.
&3 ignored for &1 in &2.
Column &3 changed to input-only.
SST changed to SUBSTRING for column &3.
MODE DB2ROW changed to MODE DB2SQL.
Schema qualifier in &1 in &2 was removed.
SET CURRENT DEGREE statement not fully enabled.
PAGESIZE value &1 not correct.
WITH EMPTY TABLE not valid for &1 in &2.
Request &1 to module &2 not valid.
Temporary result created.
Reusable ODP sort used.
UNION, EXCEPT, or INTERSECT.
SUBQUERY.
Query optimizer timed out for table &1.
All indexes considered for table &1.
Query implementation for join position &1 table &2.
Index &1 used for table &2.
Index created for table &1.
Temporary distributed result file &1 was created to contain join result. Result file was directed.
Temporary distributed result file &1 was created to contain join result. Result file was broadcast.
Optimizer debug messages for distributed query step &1 of &2 follow:
GROUP BY processing generated.
Temporary distributed result file &1 was created while processing distributed subquery.
Table scan access for table &1.
Index scan-key row positioning used on table &1.
Index created from index &1 for table &2.
Access plan has not been built.
&1 join column pair(s) are used for this join position.
From-column &1.&2, to-column &3.&4, join operator &5, join predicate &6.
Subselects processed as join query.
Host variables implemented as reusable ODP.
Host variables implemented as non-reusable ODP.
Host variables implemented as file management row positioning reusable ODP.
Processing grouping criteria for query containing a distributed table.
Temporary distributed result table &1 was created while processing grouping criteria.
Performing distributed join for query.
Temporary distributed result table &1 was created because table &2 was directed.
Temporary distributed result table &1 was created because table &2 was broadcast.
Table &1 used in distributed join.
Estimated query run time is &1 seconds.
Access plan last saved on &1 at &2.
Access plan was saved with SRVQRY attributes active.
Parallel table prefetch used.
Parallel index preload access method used.
Parallel table preload access method used.
Index only access used on table number &1.
Access plan was saved with DB2 Symmetric Multiprocessing installed on the system.
The query contains a distributed table.
Hashing algorithm used to process the grouping.
Hashing algorithm used to process join.
Table &1 used in hash join step &2.
Temporary table created for hash join results.
Query attributes overridden from query options file &2 in library &1.
&1 tasks specified for parallel scan on table &2.
&1 tasks specified for parallel index create over table &2.
Index &1 used for bitmap processing of table &2.
&1 tasks specified for parallel bitmap create using &2.
Multiple join classes used to process join.
Table &1 used in join class &2.
Java support is not installed or properly configured on this platform.
Java interpreter startup or communication failed for reason code &1.
Java stored procedure or user-defined function &1, specific name &2 aborted with an exception "&3".
Java stored procedure or user-defined function &1, specific name &2, could not be identified from external name &3.
Java stored procedure or user-defined function &1, specific name &2 could not load Java class &3 for reason code &4.
Java stored procedure or user-defined function &1, specific name &2 could not call Java method &3, signature &4.
Too many partitions specified.
&1 cannot be specified for routine &2.
The length of parameter &1 of function &2 is not valid.
The value of parameter &1 of function &2 is not within the valid range.
Element &1 in the option array is not valid.
Column qualifier or table &2 undefined.
Collection must be specified for table &1.
Cannot perform operation under commitment control.
Operator &4 not consistent with operands.
Continuation symbol not valid.
Right parenthesis or right brace not found.
Default schema name &1 not valid.
Host structure array &1 not defined or not usable.
Host variable &1 not numeric with zero scale.
Qualified object name &1 not valid.
Too many users specified for GRANT or REVOKE.
FOR UPDATE column &1 not valid.
Statement name &1 previously referred to.
Variable &1 not character, UCS-2 graphic, or UTF-16 graphic.
Program &1 in &2 does not contain SQL statements.
Program &1 in &2 not a distributed SQL program.
OPTION(*SYS) valid only if relational database &1 (product identification &2) is DB2 for IBM i.
COMMIT(*NONE) valid only if relational database &1 (product identification &2) is DB2 for IBM i.
Create package function attempted while already doing a create package.
Program &1 in &2 does not contain SQL distributed modules.
&1 from DECLARE VARIABLE not defined or usable as a host variable.
&1 from DECLARE VARIABLE is not unique. Qualifier, if specified, is &2.
&1 from DECLARE VARIABLE is referred to in a prior SQL statement.
DECLARE VARIABLE not valid for &1.
&1 has been specified on a prior DECLARE VARIABLE statement.
SQL package creation has failed for &2 in &3 at &1.
SQL Package &2 in &3 created at relational database &1.
&1 can not be used on a DECLARE VARIABLE. &1 is a level 49 variable character definition.
DATE format &3 not supported by &1 (product identification &2). Must be USA, ISO, EUR, or JIS.
TIME format HMS with separator &3 not supported by &1 (&2). Must be USA, ISO, EUR, or JIS.
Program does not require an SQL package.
Length of host variable &1 is not valid.
SQL statement was not used.
Length of host variable &1 is too long.
Module &1 not in program &2 in library &3.
SRTSEQ parameter not supported by &1 (product identification &2). Must be *HEX.
Error processing SRTSEQ or LANGID parameter. Message is &3, &4.
DYNUSRPRF(*OWNER) not supported by &1 (product identification &2).
Module &1 in program &3 in library &4 does not contain SQL statements.
Module &1 in program &3 in library &4 was not created as a distributed SQL module.
Qualifier &1 not same as name &2.
SQL statement not allowed in a CREATE SCHEMA statement.
Substitution characters found in translated constant.
Cannot convert alternative collating sequence table.
*JOBRUN required for both SRTSEQ and LANGID if specified for either one.
SQL package creation for module &4 failed. Package name was to be &2 in &3 at &1.
SQL Package &2 in &3 created at &1 from module &4.
Program &1 in &2 contains more than 1024 modules.
Error processing SRTSEQ or LANGID parameter. Message is &1.
SQLSTATE attributes are not correct.
&1 in &2 type *&3 does not contain SQL statements.
Create package function attempted on a read-only connection.
USRPRF(&3) not supported by &1 (product identification &2).
Access plan not found.
Precompile option &1 changed by SET OPTION statement.
Record length parameter not valid.
Number of source records not valid.
Character for delimited host string not valid.
Character for delimited SQL string not valid.
Language parameter not valid.
Naming convention not valid.
Margins not valid.
CCSID not valid.
Character specified as decimal point not valid.
Operation parameter not valid.
Key field &1 not valid.
Number of keys not valid.
Target release not valid.
Length of data for key &1 not valid.
Length of area for statement information not valid.
The cursor is out of range for this operation.
List selections may not be inserted into IGC data.
Library list being built.
Collection list being built.
File, package or procedure list being built.
Table, package or procedure list being built.
Field list being built.
Column list being built.
Retrieve (F9) not allowed when cursor not on statement.
No statements to retrieve.
Already at bottom of list.
Already top of list.
Library &1 not valid.
Length of statement exceeds 32,767 characters.
Before using a list, library must be selected.
Before using a list, collection must be selected.
Before using field list, select at least one library.
Before using column list, select at least one collection.
Maximum of 256 files can be selected.
Maximum of 256 tables can be selected.
Before using field list, select at least one file.
Before using the column list, select at least one table.
Already top of session.
Already bottom of session.
Invalid message &1 returned from SQL processor.
No libraries match selection values.
No collections match selection values.
File list cannot be built because library not selected.
Table list cannot be built because collection not selected.
File list not built because no libraries available.
Table list not built because no collections available.
No files available for chosen library or libraries.
No tables available for chosen collection.
Field list not built because library not selected.
Column list not built because collection not selected.
Field list not built because no libraries available.
Column list not built because no collections available.
Field list not built because file not selected.
Column list not built because table not selected.
Field list not built because no files available.
Column list not built because no tables available.
No fields available in chosen file or files.
No columns available in table or tables.
Files being added to list from library &1.
Tables being added to list from collection &1.
Library list not available.
Collection list not available.
File lists are not available.
Table lists are not available.
Cannot change session attributes.
PROGRAM changed to PACKAGE.
Specify either relational database or host variable name.
RUN changed to EXECUTE.
Field list not built because file not specified.
Column list not built because table not specified.
SYNONYM changed to ALIAS.
Syntax check found no errors.
The syntax and validity checks found no errors.
SELECT statement run complete.
Printer &1 not found.
File &1 in &2 already exists.
Options 1, 2, and 3 not valid when member is *ALL.
Commitment control option changed.
Statement processing control option changed.
SELECT output option changed.
List of libraries changed.
List type option changed.
Session printed.
Entries from current session removed.
List of collections changed.
Member &1 already exists in &2 in &3.
Data refresh option changed.
Programming language changed.
Decimal point value changed.
SQL string delimiter changed.
Error in module &1 not expected.
Session was saved and started again.
There are no parameters to specify for this statement.
&1 is not a valid host variable name.
Statement processing canceled by user.
Statement processing canceled by user.
Session ended abnormally. It has been recovered.
The session saved in member &1 in file &2 in &3.
This parameter is required.
Incorrect host identifier.
String expressions are not supported by the prompter.
Commit set to *NONE with changes pending.
Changes waiting for COMMIT or ROLLBACK.
The value for this parameter must be in the range &1 and &2.
Either a Y or N must be specified.
Variable name is too long for prompter use.
Collection list requested but table name already specified.
&1 is a reserved word and must be delimited.
DATABASE or SCHEMA changed to COLLECTION.
Library list requested but file name already specified.
Collection list requested but view name already specified.
Library list requested but view name already specified.
Collection list requested but index name already specified.
Library list requested but index name already specified.
&1 is not a valid host label.
Prompting was cancelled by the user.
Incorrect combination of parameters specified.
Incorrect combination of parameters specified.
Incorrect combination of parameters specified.
Incorrect combination of attributes specified.
Incorrect Type specified.
A, D, or blank must be specified.
1 must be specified.
Length must be specified if scale is used.
Incorrect combination of attributes specified.
List selections may not be inserted into a literal.
Cannot use interactive SQL now.
Statement processing canceled by user.
Incorrect combination of CCSID attributes.
Data option and CCSID must be blank.
Interactive SQL session has exceeded system limit.
No constraints defined, press Enter to add a constraint
Specified option number is not valid.
REFERENCES table must be specified.
REFERENCES file must be specified.
The FOREIGN key must have same number of columns as the parent key.
This parameter is required when attributes have been specified.
No constraints available for chosen file.
No constraints available for chosen table.
Incorrect combination of attributes specified.
No node groups available for chosen library or libraries.
No node groups available for chosen collection or collections.
Node group list cannot be built because library not selected.
Node group list cannot be built because collection not selected.
No procedures available for chosen library or libraries.
No procedures available for chosen collection or collections.
Procedure list cannot be built because library not selected.
Procedure list cannot be built because collection not selected.
Index list cannot be built because library not selected.
Index list cannot be built because collection not selected.
Index list not built because no libraries available.
Index list not built because no collections available.
No indexes available for chosen library or libraries.
No indexes available for chosen collection.
Alias list cannot be built because library not selected.
Alias list cannot be built because collection not selected.
No aliases available for chosen library.
No aliases available for chosen collection.
No members available for specified file.
No members available for specified table.
Library list requested but alias name already specified.
Collection list requested but alias name already specified.
At least one privilege must be selected.
BEFORE or AFTER only valid with Fetch type of 3.
One and only one value must be specified.
If one parameter is supplied then supply the other also.
Value for Data not valid.
Row or rows value out of range.
1, 2, 3, 4 or 5 must be specified.
Value for Nulls not valid.
Maximum of 32 packages can be selected.
Packages being added to list from library &1.
Packages being added to list from collection &1.
Package list cannot be built because library not selected.
Package list cannot be built because collection not selected.
Package list not built because no libraries available.
Package list not built because no collections available.
No packages available for chosen library or libraries.
No packages available for chosen collection.
Package lists are not available.
At least one text description must be specified.
Row or rows value out of range.
Attribute choice not valid.
Structure and field cannot be specified
Relational database list is not available.
1, 2, 3, or 4 must be specified.
1, 2, 3, 4, 5, 6 or 7 must be specified.
You are currently working with SELECT &1 of &2.
Either a 1 or a 2 must be specified.
Specify either WHERE condition or WHERE CURRENT OF cursor.
Comment must be specified.
Label must be specified.
The SELECT clause must be specified.
The FROM clause must be specified.
GROUP BY clause must be specified if HAVING clause is used.
Not allowed with UNION
At least one value must be specified.
Duplicate names are not allowed.
The value specified must be in the range from 1 to 999.
At least one name must be specified.
Name must be specified.
File &1 in library &2 is not available.
Column &1 not defined for table &2.
Field &1 not defined for file &2.
The INTO clause is required.
Only one selection allowed.
Table &1 in collection &2 is not available.
At least one comment must be specified.
At least one column heading must be specified.
Parentheses for UNION or UNION ALL are not supported.
Verify DBCS data; press Enter to continue.
Right margin specified incorrectly.
Left margin not specified correctly.
FLDLEN (and the text width) must be at least 20.
You are at level &1 in a hierarchy of subqueries.
String delimiter missing from continued literal.
Shift-in and shift-out added to literal.
Continuation marker missing from continued literal.
Allow copy data option changed.
Authorization list &1 does not exist.
Naming Convention changed.
Session attributes changed by the database manager.
STRSQL parameters were ignored.
Date format value changed.
Date separator value changed.
Time format value changed.
Time separator value changed.
Sort sequence changed.
Language identifier value changed.
Sort sequence &1 is not valid.
Language identifier &1 is not valid.
A problem occurred retrieving the sort sequence.
&1 has been replaced with &2. &2 is the preferred syntax.
ALL may not be specified with other privileges.
Parameter &1 not defined for procedure &2.
At least one comment must be specified.
At least one name must be specified.
Duplicate names are not allowed.
The parameter usage specified is not valid for language selection REXX.
Incorrect combination of parameter attributes specified.
Incorrect combination of parameter attributes specified.
Parameter name must be preceded by a colon.
The language specified is not valid
The parameter usage specified is not valid
1, 2, 3, 4, 5 or 6 must be specified.
SQLSTRDLM(*APOSTSQL) only allowed with PGMLNG(*CBL) and PROCESS(*SYN).
No common fields were found for specified files.
No common columns were found for specified tables.
Field &1 not defined for specified file or files.
Column &1 not defined for specified table or tables.
Only common field names are displayed.
Only common column names are displayed.
Same privilege cannot be specified for both table and column.
At least one field must be chosen.
At least one column must be chosen.
Same privilege cannot be specified for both file and field.
Prompting not supported.
1 or 2 must be specified.
Have you considered using System i Navigator's Run SQL Scripts instead of STRSQL.
At least one parameter required.
New name is not valid.
Table &1 in &2 not database file.
Override parameter not valid.
File &1 in &2 has more than one format.
Cannot drop schema &1.
COMMIT, ROLLBACK, or SAVEPOINT not valid.
&1 in &2 not valid for operation.
&1 in &2 not valid for operation.
Logical file &1 in &2 not valid for CREATE VIEW.
&1 in &2 not table, view, or physical file.
&1 not found in source program.
Component ID &3 was not valid for program &1 in &2.
SQL access plans were not found for program &1 in &2.
SQL area for program &1 in &2 already exists.
Unable to run statement with specified commit level.
COMMIT HOLD or ROLLBACK HOLD not allowed.
Specified server &1 is no longer the current server; &2 is now the current server.
SQL package creation failed.
Local program attempting to run on application server.
User &1 not the same as current user &2.
Parameter value not valid. Reason code is &1.
CCSIDs incompatible.
Auxiliary storage pool &4 or &5 not found.
Cannot GRANT specified privileges on object &1 in &2 type *&3.
Owner and primary group cannot be the same.
New name &3 is not valid.
Alias &1 for table &2 in &3 not valid for statement.
Sort sequence table &1 too long.
SQL procedure, function, trigger, or variable &1 in &2 not created.
Alias name &1 in &2 not allowed.
LOB and XML locators are not allowed with COMMIT(*NONE).
System User-Defined Type name used in SQLDA.
Data in a distributed file &1 in &2 cannot be redistributed.
Delete cascade not valid for &1 in &2.
QSQGNDDL API input template field values not compatible.
Message severity &1 exceeds specified severity level &2.
&1 in &2 not valid for object type &3.
Value not valid for QSQGNDDL API input template.
System-generated function or built-in data type &1 in &2 not allowed.
&3 not supported by the standards option for &1 in &2.
Function &1 in &2 not allowed.
Generate SQL for &1 in &2 object type &3 failed.
System trigger &1 in &2 not allowed.
Operation not allowed because trigger is invalid.
An internal object limit has been exceeded.
Result sets are not available from procedure &1 in &2.
MODE DB2SQL before trigger converted to MODE DB2ROW.
Object &1 type *&3 cannot be created in &2.
Relational database directory not available.
The open failed due to exit program &1.
Cursor &1 is ambiguous.
XML database support not available for reason &1.
&1 was changed to PROGRAM TYPE MAIN.
Dynamic SQL error - SQLSTATE &1, SQLCODE &2.
Connection exception - SQLSTATE &1, SQLCODE &2.
Triggered data change violation - SQLSTATE &1, SQLCODE &2.
Authorization not valid - SQLSTATE &1, SQLCODE &2.
Transaction termination not valid - SQLSTATE &1, SQLCODE &2.
Connection name not valid - SQLSTATE &1, SQLCODE &2.
Cursor name not valid - SQLSTATE &1, SQLCODE &2.
Feature not supported - SQLSTATE &1, SQLCODE &2.
External function exception - SQLSTATE &1, SQLCODE &2.
Ambiguous cursor name - SQLSTATE &1, SQLCODE &2.
WITH CHECK OPTION violation - SQLSTATE &1, SQLCODE &2.
Transaction state not valid - SQLSTATE &1, SQLCODE &2.
Savepoint exception - SQLSTATE &1, SQLCODE &2.
Cursor sensitivity exception - SQLSTATE &1, SQLCODE &2.
Condition number not valid - SQLSTATE &1, SQLCODE &2.
Diagnostic exception - SQLSTATE &1, SQLCODE &2.
Statement is not allowed in a trigger - SQLSTATE &1, SQLCODE &2.
Character cannot be mapped to XML value - SQLSTATE &1, SQLCODE &2.
COMMIT(*ALL) or COMMIT(*CS) requested but not allowed.
Program does not include SQL statements.
Scope message for cleanup.
Table &1 in &2 created but was not journaled.

Length: 215537 Date: 20200926 Time: 131756

Count: 1086     sap01-206 ( 1079 ms ) This documentation is copyright by IBM.