DB2 Server for VM: Messages and Codes

Chapter 11. ARI5500-ARI5593 FLAGGER Messages

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.

ALL SET FUNCTION

ALL column function. Any column function where ALL is implicitly or explicitly specified. (In other words, duplicate values are not eliminated.)

AUTHORIZATION IDENTIFIER

The name of the owner or creator of an object, such as a table.

COLUMN DEFINITION

The definition of a column of a table.

COLUMN SPECIFICATION

Reference to a named column.

COMPARISON PREDICATE

A basic predicate. A predicate that compares two values.

DEGREE

The number of columns or expressions selected in an SQL statement.

DISTINCT SET FUNCTION

DISTINCT column function. Any column function with which DISTINCT has been specified. (In other words, duplicate values are to be eliminated.)

GROUPed view or GROUPed table

A view or table that is a result of a GROUP BY clause, a HAVING clause or both of these clauses. A view can also be GROUPed view if any view referenced in the FROM clause is a GROUPed view.

GROUPing column

A column referenced in a GROUP BY clause.

IDENTIFIER

An alphameric token used to form a name.

OUTER REFERENCE

A correlated reference.

QUERY EXPRESSION

A fullselect.

QUERY TERM

A subselect or a fullselect that is surrounded by parentheses.

QUERY SPECIFICATION

A subselect.

RESULT SPECIFICATION

The columns to be searched for in a subquery.

SEARCH CONDITION

One or more Boolean terms.

SELECT LIST

List of columns or expressions, or * specified in the SELECT statement.

SELECT TARGET LIST

One or more TARGET SPECIFICATIONs.

SET FUNCTION SPECIFICATION

One of the following column functions:

• COUNT (*)
• A column function with DISTINCT explicitly specified
• A column function with ALL implicitly or explicitly specified.

SORT SPECIFICATION

The clause comprised of column names, integers, ASC, and DESC that follows the keywords in an ORDER BY clause. For example, in the clause ORDER BY COL1 DESC, COL1 DESC would be the SORT SPECIFICATION.

TABLE EXPRESSION

A FROM clause optionally followed by a WHERE clause, a GROUP BY clause, or a HAVING clause.

TARGET SPECIFICATION

Specification of a parameter or variable that can be assigned a value.

VALUE EXPRESSION

A value specified as the value itself, through a variable name, or as an arithmetic expression.

VIEW COLUMN LIST

A list of column names provided on the CREATE VIEW statement.

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:

• The SAA standard is being checked and the comment is not introduced as required by the host language.

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:

• Length value should be greater than zero.
• Precision value should be greater than zero.
• Scale value should not be greater than precision.

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:

• The COLUMN SPECIFICATION of a DISTINCT SET FUNCTION cannot reference a column derived from a SET FUNCTION SPECIFICATION.
• COLUMN SPECIFICATIONs in the VALUE EXPRESSION of an ALL SET FUNCTION cannot reference a column derived from a SET FUNCTION SPECIFICATION.

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:

• The table or correlation name used as a qualifier does not exist.
• The column name does not exist within the current scope or the scope of the qualifier.

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:

• A VALUE EXPRESSION containing a DISTINCT SET FUNCTION cannot include dyadic operators.
• The first character following a monadic operator cannot be a plus or minus sign.
• A VALUE EXPRESSION should not contain operators if primary is of type character string.

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:

• exptype = COMPARISON - Comparison operators must match.
• exptype= BETWEEN - The three VALUE EXPRESSIONs must match.
• exptype = IN - VALUE EXPRESSION, subquery and all VALUE SPECIFICATIONs must match.
• exptype = QUANTIFIED - VALUE EXPRESSION and subquery must 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:

• Data type of the column in a LIKE predicate is not a character string.
• Data type of the pattern in a LIKE predicate is not a character string.

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:

• Table name occurs more than once in a FROM clause.
• Correlation name is identical to a table name or to another correlation name in a FROM clause.

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:

• If the TABLE EXPRESSION is a GROUPed view, the RESULT SPECIFICATION of a subquery cannot contain a SET FUNCTION SPECIFICATION.
• If the TABLE EXPRESSION is a GROUPed view, the SELECT LIST of a QUERY SPECIFICATION cannot contain a column function.

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:

• For a GROUPed table, the COLUMN SPECIFICATION must reference a GROUPing column or be specified within a SET FUNCTION SPECIFICATION.
• If not a GROUPed table and VALUE EXPRESSION includes a SET FUNCTION SPECIFICATION, then each COLUMN SPECIFICATION must be specified within a SET FUNCTION SPECIFICATION.

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:

• DISTINCT must not be specified more than once in a QUERY SPECIFICATION, excluding any subquery of that QUERY SPECIFICATION.
• DISTINCT must not be specified more than once in a subquery, excluding any subquery contained in that subquery.

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:

• In a FETCH statement
• In a SELECT statement.

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. Return Code =  nn .

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.

ARI5549I

Warning: You requested semantics flagging while using the DRDA protocol. The SQLFLAG option is ignored.

Explanation: When preprocessing under DRDA protocol, only syntax flagging is available.

System Action: Preprocessing continues without FLAGGER operation.

User Response: If semantics flagging is required, preprocess in a non-DRDA environment. Refer to the DB2 Server for VSE & VM Database Administration manual for a discussion of protocol alternatives for the SQLINIT EXEC.

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:

• If the data type of the column name is a character string, then the corresponding item in the INSERT or UPDATE statement should be a character string of length equal to or less than the length of the column name.
• If the data type of the column name is exact numeric, then the corresponding item in the INSERT or UPDATE statement should be exact numeric.
• If the data type of the column name is approximate numeric, then the corresponding item in the INSERT or UPDATE statement should be approximate numeric or exact numeric.

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:

• Not defined within the program
• Defined outside the SQL Declare Section.

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.