The FLAGGER messages use both SQL and ANSI terms. The ANSI terms are defined below. For a definition of the SQL terms, refer to the DB2 Server for VSE & VM SQL Reference manual.
These terms are in uppercase letters in both this manual and the DB2 Server for VSE & VM SQL Reference manual.
| ARI5500I | FLAGGER Message: The FIPS standard is used for syntax flagging. |
Explanation: Information message to identify the standard used for flagging during preprocessing.
System Action: Processing continues.
| ARI5501I | FLAGGER Message: The SAA standard is used for syntax flagging. |
Explanation: Information message to identify the standard used for flagging during preprocessing.
System Action: Processing continues.
| ARI5502I | FLAGGER Message: The statement deviates from the SQL standard syntax at the token starting with the text text . |
Explanation: A syntax deviation from the standard named in the earlier message (FIPS or SAA) was encountered in the SQL statement.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5503I | FLAGGER Message: A data definition statement is not within a CREATE SCHEMA statement. |
Explanation: The FIPS standard requires that all data definition statements are contained within a CREATE SCHEMA statement.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5504I | FLAGGER Message: There is a nonstandard embedded comment. |
Explanation: A comment embedded in an SQL statement does not meet the requirements of the standard being flagged:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5505I | FLAGGER Message: An SQL syntax deviation occurred. The statement is not complete. |
Explanation: The SQL statement terminated before all required elements were found.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5506I | FLAGGER Message: Identifier identifiername is more than 18 characters. |
Explanation: AUTHORIZATION IDENTIFIER, table identifier, column name, correlation name, module name, cursor name, procedure name, or parameter name has a length of more than 18 characters.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5507I | FLAGGER Message: Column column has an invalid length, precision, or scale attribute. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5508I | FLAGGER Message: The data type of datatype should be an exact numeric with a scale of zero. |
Explanation: Data type of an indicator variable should be exact numeric with a scale of zero.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5509I | FLAGGER Message: The SET FUNCTION SPECIFICATION references column column . |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5510I | FLAGGER Message: A VALUE EXPRESSION containing column cannot include operators. |
Explanation: A VALUE EXPRESSION cannot include operators in an OUTER REFERENCE COLUMN SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5511I | FLAGGER Message: The COLUMN SPECIFICATION is missing or is invalid for the ALL SET FUNCTION function . |
Explanation: The VALUE EXPRESSION of an ALL SET FUNCTION SPECIFICATION should include a COLUMN SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5512I | FLAGGER Message: Column column is not unique and requires qualification. |
Explanation: The specified column is not unique with the current scope. Qualification must be given to uniquely identify the required column.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5513I | FLAGGER Message: A VALUE EXPRESSION may not contain a SET FUNCTION SPECIFICATION. |
Explanation: The VALUE EXPRESSION of an ALL SET FUNCTION must not contain a SET FUNCTION SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5514I | FLAGGER Message: Column column does not identify a column of a table within the current scope. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5515I | FLAGGER Message: A column function that contains the OUTER REFERENCEd column column is not in the subquery of a HAVING clause. |
Explanation: A column function must be contained in a subquery of a HAVING clause if it contains an OUTER REFERENCE COLUMN SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5516I | FLAGGER Message: The result of a SUM or AVG function cannot be a character string. |
Explanation: Character string is not valid for the result of a SUM or AVG SET FUNCTION SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5517I | FLAGGER Message: Operator operator is invalid in this context. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5518I | FLAGGER Message: The exptype EXPRESSION is comparing incompatible data types. |
Explanation: The data types of one of the following (identified by exptype) do not match:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5519I | FLAGGER Message: The operand in the LIKE predicate is not a character string. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5520I | FLAGGER Message: The ESCAPE character must be a one-byte character string. |
Explanation: Escape character in a LIKE predicate must have the data type of character string with the length of 1.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5521I | FLAGGER Message: The WHERE clause, GROUP BY clause, or HAVING clause is invalid for the GROUPed view view . |
Explanation: If the table identified in the FROM clause is a GROUPed view, then the TABLE EXPRESSION must not contain a WHERE clause, GROUP BY clause, or HAVING clause.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5522I | FLAGGER Message: Name occurs more than once in a FROM clause. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5523I | FLAGGER Message: Only one table reference is allowed in the FROM clause for a GROUPed view. |
Explanation: If the table identified by table name is a GROUPed view, then the FROM clause must contain exactly one table reference.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5524I | FLAGGER Message: A reference to column column derived from a column function is invalid in a WHERE clause. |
Explanation: A VALUE EXPRESSION directly contained in the SEARCH CONDITION of a WHERE clause must not include a reference to a column derived from a column function.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5525I | FLAGGER Message: A HAVING clause must contain the WHERE clause when the WHERE clause has a column function. |
Explanation: If a VALUE EXPRESSION directly contained in the SEARCH CONDITION is a column function, then the WHERE clause must be contained in a HAVING clause.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5526I | FLAGGER Message: The COLUMN SPECIFICATION for column must be an OUTER REFERENCE. |
Explanation: If a VALUE EXPRESSION directly contained in the SEARCH CONDITION is a function, then the COLUMN SPECIFICATION in the column function expression must be an OUTER REFERENCE.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5527I | FLAGGER Message: Column column is duplicated within the current scope. |
Explanation: The specified column is duplicated within the current scope.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5528I | FLAGGER Message: The COLUMN SPECIFICATION for table should be a GROUPing column or should be specified within a column function. |
Explanation: Each COLUMN SPECIFICATION contained in a subquery in the SEARCH CONDITION of a HAVING clause must reference a GROUPing column or be specified within a column function.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5529I | FLAGGER Message: DEGREE of table table should be 1 when using a RESULT SPECIFICATION of *. |
Explanation: The DEGREE of the TABLE EXPRESSION must be 1 if the RESULT SPECIFICATION * is specified in a subquery of any predicate other than an EXISTS predicate.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5530I | FLAGGER Message: The column function is not valid for the TABLE EXPRESSION beginning with table table . |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5531I | FLAGGER Message: The COLUMN SPECIFICATION for column is invalid. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5532I | FLAGGER Message: DISTINCT is specified more than once. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5533I | FLAGGER Message: The COMPARISON PREDICATE subquery cannot contain a GROUP BY or HAVING clause. |
Explanation: If a subquery is specified in a COMPARISON PREDICATE, then the TABLE EXPRESSION whose FROM clause identifies the named table must not contain a GROUP BY clause or a HAVING clause.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5534I | FLAGGER Message: The COMPARISON PREDICATE subquery cannot identify a GROUPed view. |
Explanation: If a subquery is specified in a COMPARISON PREDICATE, then the TABLE EXPRESSION whose FROM clause identifies the named table must not identify a GROUPed view.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5535I | FLAGGER Message: Invalid AUTHORIZATION IDENTIFIER authid . |
Explanation: The AUTHORIZATION IDENTIFIER prefixed to the table name is invalid.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5536I | FLAGGER Message: Table or view name already exists. |
Explanation: The table name or view name specified already exists in the catalogue.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5537I | FLAGGER Message: The COLUMN DEFINITION is missing. |
Explanation: At least one COLUMN DEFINITION should be specified for a CREATE TABLE.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5538I | FLAGGER Message: The data type type1 of the target is not compatible with the data type type2 of the source. |
Explanation: Data types should match between both the target and source:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5539I | FLAGGER Message: You must specify a VIEW COLUMN LIST for table . |
Explanation: If any two columns in the table specified by the QUERY SPECIFICATION have the same column name, or if any column of that table is an unnamed column, then a VIEW COLUMN LIST must be specified.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5540I | Warning: There is not enough memory for the FLAGGER. Flagging is suspended for this statement. |
Explanation: The FLAGGER has run out of stack space.
System Action: Flagging continued for subsequent statements.
User Response: Notify the system programmer.
System Programmer Response: Check whether the memory allocation for the preprocessor can be expanded. Allocate more memory for the FLAGGER operation if possible. Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5541I | Warning: An error occurred when attempting to load the FLAGGER modulename . Flagging capability is affected. |
Explanation: The FLAGGER data or load module used to describe the syntax for the standard being flagged was not found during FLAGGER initialization.
System Action: If the module that failed to load was a syntax module (ARIFF00 or ARIFS00), then flagging is discontinued. If the module was a semantics module, then semantics checking stops, and only syntax checking continues.
User Response: Notify the system programmer.
System Programmer Response: Refer to the message produced by the operating system for details of causes and proceed as instructed for that message. Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5542I | Warning: An error occurred when initializing the FLAGGER. Flagging is discontinued. |
Explanation: An internal error occurred during FLAGGER initialization.
System Action: Preprocessing continues but FLAGGER operation is discontinued.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5543I | Warning: The FLAGGER could not process the SQL statement. Flagging is discontinued. |
Explanation: An SQL statement passed to the FLAGGER caused an internal error within it.
System Action: Preprocessing continues but FLAGGER operation is discontinued.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5544I | Warning: An error occurred when terminating the FLAGGER. |
Explanation: An internal error occurred during FLAGGER termination.
System Action: Preprocessing continues but FLAGGER operation is discontinued.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5545I | Warning: Error during FLAGGER access to the system catalog. Flagging continues to check syntax only. SQLCODE = nnn SQLERRP = modname SQLERRD1 = nnn Creator = creatorname Table = tablename |
Explanation: An internal error occurred during FLAGGER access to the system catalog.
System Action: Flagging continues for syntax checking only.
User Response: Notify your system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5546I | Warning: An error occurred when processing FLAGGER internal memory blocks. |
Explanation: The FLAGGER could not find an internal memory block.
System Action: Preprocessing continues but FLAGGER operation is discontinued.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5547I | Warning: Not enough memory for FLAGGER operation. |
Explanation: The FLAGGER does not have enough memory available to operate.
System Action: Preprocessing continues but FLAGGER operation is discontinued.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5548I | Warning: Error releasing FLAGGER memory during termination. |
Explanation: The FLAGGER could not release memory back to the operating system.
System Action: Flagging termination stops.
User Response: Notify the system programmer.
System Programmer Response: Refer to the DB2 Server for VSE & VM Diagnosis Guide and Reference manual for more information on failure analysis procedures.
| ARI5570I | FLAGGER Message: You must declare column column as NOT NULL. |
Explanation: All columns identified as UNIQUE must be defined with the NOT NULL option.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5571I | FLAGGER Message: The viewed table table must be updateable. |
Explanation: When the WITH CHECK OPTION is specified then the viewed table must be updateable.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5572I | FLAGGER Message: Invalid number of column names. |
Explanation: The number of column names in the VIEW COLUMN LIST should be the same as the DEGREE of the table specified by the QUERY SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5573I | FLAGGER Message: You must declare cursor cursor before using it. |
Explanation: The cursor specified has not been declared in a DECLARE CURSOR statement.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5574I | FLAGGER Message: Cursor cursor is already declared. |
Explanation: The cursor specified has already been declared in a DECLARE CURSOR statement.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5575I | FLAGGER Message: Only * or column names are valid in this context. |
Explanation: When UNION is specified, the SELECT LIST for the specification of the two TABLE EXPRESSIONs identified by the QUERY EXPRESSION and QUERY TERM should consist of * or COLUMN SPECIFICATIONs.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5576I | FLAGGER Message: The descriptions of tables identified by the QUERY EXPRESSION beginning with table table1 and the QUERY TERM beginning with table2 should be identical. |
Explanation: When UNION is specified, the descriptions of the two tables should be identical, except for the column names.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5577I | FLAGGER Message: The SORT SPECIFICATION number is outside the DEGREE of cursor cursor . |
Explanation: If the SORT SPECIFICATION contains an unsigned integer, it should be greater than 0 and not greater than the number of columns in the table.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5578I | FLAGGER Message: Table table is a read-only table. |
Explanation: A DELETE, an INSERT, or an UPDATE statement was specified for a read-only table.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5579I | FLAGGER Message: Table table must not be identified in a FROM clause of any subquery contained in a SEARCH CONDITION. |
Explanation: A table specified in a DELETE or an UPDATE cannot be used in a FROM clause of any subquery contained in its SEARCH CONDITION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5580I | FLAGGER Message: Table table1 is not the first table table2 specified in the DECLARE CURSOR statement. |
Explanation: The table specified in a DELETE or an UPDATE statement should be the first table specified in the FROM clause of the DECLARE CURSOR statement.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5581I | FLAGGER Message: The number of TARGET SPECIFICATIONs does not match the DEGREE of cursor cursor . |
Explanation: The number of TARGET SPECIFICATIONs in the FETCH statement does not match the DEGREE of the table specified.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5582I | FLAGGER Message: The target table table of the INSERT statement is also in the FROM clause or in the subquery. |
Explanation: The named table must not be identified in a FROM clause of a QUERY SPECIFICATION or of any subquery contained in the QUERY SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5583I | FLAGGER Message: The number of columns specified does not match the number of values specified. |
Explanation: In an INSERT statement, the number of columns specified does not match the number of values specified.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5584I | FLAGGER Message: The number of columns specified does not match the DEGREE of the QUERY SPECIFICATION beginning with table table . |
Explanation: In an INSERT statement, the number of columns specified does not match the DEGREE of the table specified in the QUERY SPECIFICATION.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5585I | FLAGGER Message: There is a data type or length mismatch between column column and the INSERT or UPDATE item. |
Explanation: One of the following conditions has not been met:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5586I | FLAGGER Message: You cannot use a GROUP BY or HAVING clause or identify a GROUPed view in this context. |
Explanation: The table identified in the FROM clause of the TABLE EXPRESSION in a SELECT statement should not include a GROUP BY or HAVING clause and should not identify a GROUPed view.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5587I | FLAGGER Message: The number of elements specified in the SELECT LIST should match the number in the SELECT TARGET LIST. |
Explanation: In the SELECT statement, the number of elements specified in the SELECT LIST should match the number of elements in the SELECT TARGET LIST.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5588I | FLAGGER Message: Column function function is not allowed in an UPDATE statement. |
Explanation: A VALUE EXPRESSION in a SET clause of an UPDATE statement should not include a column function.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5589I | FLAGGER Message: You cannot specify NULL for NOT NULL column column . |
Explanation: If NULL is specified in the SET clause of the UPDATE statement, then the corresponding column should allow nulls.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5590I | FLAGGER Message: Invalid SQL terminator for host language. |
Explanation: The SQL statement was not terminated by the correct construct for the host language being processed.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5591I | FLAGGER Message: You must define the host variable identifier . |
Explanation: The host variable named was either:
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5592I | FLAGGER Message: Table table not found in the catalog. |
Explanation: The named table or view does not exist in the system catalog.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.
| ARI5593I | FLAGGER Message: For the host language language , there is an invalid IDENTIFIER or LABEL name . |
Explanation: The format of the IDENTIFIER name or LABEL name displayed does not meet the requirements of the host language.
System Action: Processing continues.
User Response: Correct the SQL statement to meet installation standards.