-683 THE SPECIFICATION FOR COLUMN, DISTINCT TYPE, FUNCTION, OR PROCEDURE data-item CONTAINS INCOMPATIBLE CLAUSES
Explanation
The data item specification of a CREATE or ALTER statement contains an error.
- data-item
- The source of the problem, which varies by statement.
- CREATE DISTINCT TYPE statements
- The name of the type that is being defined.
- CREATE FUNCTION or ALTER FUNCTION statements
- The area of the statement that caused the error, such as "PARAMETER 3", "RETURNS" or "CAST FROM".
- CREATE TABLE or ALTER TABLE statements
- The name of the column that caused the error. The error could
be an invalid specification of FOR BIT DATA, FOR SBCS DATA, FOR MIXED
DATA, or FIELDPROC for the column definition.
The following additional restrictions apply to CREATE TABLE statements, ALTER TABLE statements, or both:
- On an ALTER TABLE statement, generation-alteration cannot be specified for a column that is not defined as an identity column.
- The columns for a BUSINESS_TIME period must be defined with a data type of DATE or TIMESTAMP(6) WITHOUT TIME ZONE.
- The data type for a column that is defined as ROW BEGIN, ROW END, or TRANSACTION START ID must be TIMESTAMP(12) WITHOUT TIME ZONE.
- General causes
- FIELDPROC can only be specified for columns that are a built-in character string or graphic string data type that is not a LOB.
System action
The statement cannot be processed.
Programmer response
Correct the SQL statement by removing the incompatible specification.
SQLSTATE
42842