DB2 SQL-Error: -683
SQLState: 42842
Short Description: THE SPECIFICATION FOR COLUMN DISTINCT TYPE FUNCTION OR PROCEDURE CONTAINS INCOMPATIBLE CLAUSES
There is an error in the data item specification in a CREATE or ALTER statement. Incompatible specifications are present such as ?INTEGER and FOR BIT DATA?. The location of the error is given by data-item as follows: v 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. v 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? or ?RETURNS? or ?CAST FROM?. v For a CREATE DISTINCT TYPE statement, data-item gives the name of the type being defined. v generation-alteration cannot be specified for a column that is not defined as an identity column.System action: The statement cannot be executed. Programmer response: Correct the SQL statement by removing the incompatible specification.