SQL - SQLCODE's - Códigos negativos -628


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -628
   
 
  • Causa
    • THE CLAUSES ARE MUTUALLY EXCLUSIVE.

      Mutually exclusive clauses were specified in one or more of the following ways:

      • 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.
      • A CREATE or ALTER TABLESPACE contains both the LOCKPART YES and LOCKSIZE TABLESPACE
      • A 'column-definition' contains both NOT NULL and DEFAULT NULL clauses.
      • A 'column-definition' contains both FIELDPROC and DEFAULT clauses.
      • A select-statement contains both the update-clause and the FOR FETCH ONLY clause.
      • An ALTER TABLE statement contains both a DROP CONSTRAINT clause and either a DROP FOREIGN KEY, DROP CHECK, DROP PRIMARY KEY, or DROP UNIQUE clause .
      • A CREATE or ALTER TABLESPACE statement contains both LOCKPART YES and LOCKSIZE TABLESPACE.
      • A CREATE TRIGGER statement specifies more than one correlation name for OLD, NEW, OLD_TABLE, or NEW_TABLE.
        Each of these correlation specifications can appear no more than once in the CREATE TRIGGER statement.
      • 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 (For example, EXTERNAL, LANGUAGE, NO SQL).
      • A CREATE or ALTER PROCEDURE statement attempts to use the NO WLM ENVIRONMENT and PROGRAM TYPE SUB options.
        When NO WLM ENVIRONMENT is used, then SECURITY must also be used.
      • A CREATE or ALTER PROCEDURE statement attempts to use both NO WLM ENVIRONMENT and either USER or DEFINER for SECURITY.
        When NO WLM ENVIRONMENT is used, then SECURITY DB2 must also be used.
      • A CREATE or ALTER PROCEDURE statement contains both a LANGUAGE REXX clause, and a PARAMETER STYLE DB2SQL or PARAMETER STYLE JAVA 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.
      • The AS (subselect) clause of a DECLARE GLOBAL TEMPORARY TABLE statement contains both an INCLUDING COLUMN DEFAULTS clause and a USING TYPE DEFAULTS clause.
      • A CREATE DATABASE statement contains both the AS WORKFILE clause and the AS TEMP clause.
      • If INSENSITIVE or SENSITIVE is specified, then SCROLL must also be specified, either on DECLARE CURSOR or with the ATTRIBUTES clause of the PREPARE statement.
      • If SCROLL is specified, then either INSENSITIVE or SENSITIVE STATIC must also be specified, either on DECLARE CURSOR or with the ATTRIBUTES clause of the PREPARE statement.
      • The attribute-string specified in the ATTRIBUTES clause of the PREPARE statement cannot specify conflicting options.
  • Resposta ao Desenvolvedor
    • Change the options specified in the statement, and reissue the statement.

      SQLSTATE: 42613

© Copyright IBM Corp.