DSNH683I E csectname LINE nnnn COL cc. THE SPECIFICATION FOR COLUMN, DISTINCT TYPE, FUNCTION, OR PROCEDURE data-item CONTAINS INCOMPATIBLE CLAUSES

Explanation

There is an error in the data item specification in a statement. Incompatible specifications are present such as "INTEGER and FOR BIT DATA", or "INTEGER AS LOCATOR". The location of the error is given by data-item as follows:
  • For a CREATE or ALTER TABLE statement, data-item gives the name of the column containing the error. The error could be an invalid specification of FOR BIT DATA, FOR SBCS DATA, FOR MIXED DATA, or FIELDPROC for column data-item.
  • For a CREATE FUNCTION or CREATE PROCEDURE statement, data-item is a token that identifies the area of the problem in the statement. For example, "PARAMETER 3", "RETURNS", or "CAST FROM".
  • For a CREATE DISTINCT TYPE statement, data-item gives the name of the type being defined
  • Otherwise, data-item is a token that identifies the area of the problem in a parameter list for a function. For example, "PARAMETER 5".

System action

The statement cannot be processed.

User response

Correct and reissue the failing statement.

Severity

8 (error)