DSNH628I E csectname LINE nnnn COL cc MUTUALLY EXCLUSIVE CLAUSES HAVE BEEN SPECIFIED.

Explanation

Mutually exclusive clauses were specified in one or more ways.

• A column-definition value contains both NOT NULL and DEFAULT NULL clauses.
• A column-definition value contains both FIELDPROC and DEFAULT clauses.
• A select-statement value contains both the update-clause and the FOR FETCH ONLY clause.

ALTER FUNCTION or CREATE FUNCTION statements

• A CREATE FUNCTION statement contains both a CAST FROM clause and a SOURCE clause.
• A CREATE FUNCTION statement contains both a SOURCE clause and a RETURNS TABLE clause.
• A CREATE FUNCTION statement contains both a SOURCE clause and a clause used to define an external function (EXTERNAL, LANGUAGE, NO SQL).
• A CREATE FUNCTION or ALTER FUNCTION statement contains a clause other than the CAST FROM clause for external scalar functions.

ALTER INDEX or CREATE INDEX statements

• A CREATE INDEX statement contains both GENERATE KEY USING and a column specified as ASC or DESC.
• A CREATE INDEX statement contains both a GENERATE KEY USING clause, and a column specified as ASC or DESC.
• A CREATE INDEX or ALTER INDEX statement attempted to specify either CLUSTER, PARTITION BY, or both, for an XML index or an extended index.
• A CREATE INDEX or ALTER INDEX statement attempted to specify either CLUSTER, PARTITION BY, or both, for an XML index or an extended index.

ALTER PROCEDURE or CREATE PROCEDURE statements

• A CREATE PROCEDURE or ALTER PROCEDURE statement attempts to use the NO WLM ENVIRONMENT and PROGRAM TYPE SUB options. When NO WLM ENVIRONMENT is used, then PROGRAM TYPE MAIN must also be used.
• A CREATE PROCEDURE or ALTER PROCEDURE statement attempts to use both NO WLM ENVIRONMENT and either USER or DEFINER for EXTERNAL SECURITY. When NO WLM ENVIRONMENT is used, then PARAMETER STYLE must be either GENERAL or SIMPLE CALL WITH NULLS.
• A CREATE PROCEDURE or ALTER PROCEDURE statement contains both a LANGUAGE REXX clause, and a PARAMETER STYLE DB2SQL or PARAMETER STYLE JAVA clause.

ALTER TABLE statements

• An ALTER TABLE statement contains both a DROP CONSTRAINT clause and either a DROP FOREIGN KEY clause or a DROP CHECK clause.
• An ALTER TABLE statement contains both an ALTER COLUMN clause and a VALIDPROC clause.
• An ALTER TABLE statement contains both an ALTER COLUMN clause and a clause other than the check constraint clause.
• An ALTER TABLE statement contains a clause and one of the following clauses: ADD CLONE, DROP CLONE, RENAME COLUMN, ADD ORGANIZED BY HASH, ALTER ORGANIZATION, or DROP HASH ORGANIZATION. When one of these clauses is specified, no other clause is allowed on the ALTER TABLE statement.
• An ALTER TABLE statement distinctly contains two or more of the following clauses: ALTER COLUMN, ADD PARTITION, ALTER PARTITION, and ROTATE PARTITION. The clauses are mutually exclusive with each other, unless the ADD PARTITION and ALTER PARTITION clauses are specified together to add a new partition between existing logical partitions.

ALTER TABLESPACE or CREATE TABLESPACE statements

• A CREATE TABLESPACE or ALTER TABLESPACE contains both the LOCKPART YES and LOCKSIZE TABLESPACE
• A CREATE TABLESPACE or ALTER TABLESPACE contains both the LOCKPART YES and LOCKSIZE TABLESPACE
• A CREATE TABLESPACE statement contains both the SEGSIZE and NUMPARTS clauses
• A CREATE TABLESPACE statement contains both the SEGSIZE and LARGE clauses.
• A CREATE TABLESPACE statement contains both the SEGSIZE and MEMBER CLUSTER clauses.

CREATE TRIGGER statements

• A CREATE TRIGGER statement specifies more than one correlation name for OLD, NEW, OLD_TABLE, or NEW_TABLE. Each of these correlation specific can appear no more than once in the CREATE TRIGGER statement.

DECLARE CURSOR statements

• A DECLARE CURSOR statement specifies both the WITH RETURN TO CLIENT option and one the following options: WITH RETURN (TO CALLER) or WITHOUT RETURN.