-683   THE SPECIFICATION FOR COLUMN, DISTINCT TYPE, FUNCTION, OR PROCEDURE data-item CONTAINS INCOMPATIBLE CLAUSES

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.