Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    72

    Unanswered: DB2v8 Z/OS: What is wrong with this create table/index statements?

    Hi all,

    Can some expert take a Iook athe JCL and SQL create statement and see if they can tell what I am missing, doing wrong. i have looked at it and getting blurry-eyed.

    Input & Error msg:


    ***INPUT STATEMENT:
    CREATE UNIQUE INDEX C01DDNSF.XPK00034
    ON FSNDDC01.APPROVAL_HISTORY_GTS(ID_APRVL, TS_CR)
    USING STOGROUP FSFNSG01 PRIQTY 1440 SECQTY 2880 ERASE NO
    PCTFREE 10 GBPCACHE CHANGED DEFINE YES
    BUFFERPOOL BP2
    CLOSE YES
    DEFER NO
    COPY NO
    PIECESIZE 2G ;


    SQLERROR ON CREATE COMMAND, PREPARE FUNCTION
    RESULT OF SQL STATEMENT:
    DSNT408I SQLCODE = -20283, ERROR: A DYNAMIC CREATE STATEMENT CANNOT BE PROCESS

    FROM CURRENT SQLID
    DSNT418I SQLSTATE = 429BN SQLSTATE RETURN CODE
    DSNT415I SQLERRP = DSNXODDL SQL PROCEDURE DETECTING ERROR
    DSNT416I SQLERRD = 2 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
    DSNT416I SQLERRD = X'00000002' X'00000000' X'00000000' X'FFFFFFFF' X'000
    INFORMATION

    Input JCL:
    1 //AT98817X JOB (64SOP00),'LueK',
    // CLASS=B,MSGCLASS=H,
    //* RESTART=REBUILDX.DSNUPROC,
    // REGION=0M,NOTIFY=AT98817
    /*JOBPARM SYSAFF=CILF
    2 //JOBLIB DD DISP=SHR,DSN=SYS2.DB2.CILF.SDSNLOAD
    3 //DSNTICU EXEC PGM=IKJEFT01,DYNAMNBR=20
    4 //SYSTSPRT DD SYSOUT=*
    5 //SYSPRINT DD SYSOUT=*
    6 //SYSUDUMP DD SYSOUT=*
    7 //SYSTSIN DD DISP=SHR,DSN=CILF00.6T2D.INPUT(DSNTEP2)
    8 //SYSIN DD *

    Any help will be appreciated.

    Okonita


    Subject:

  2. #2
    Join Date
    May 2003
    Posts
    113
    your schema name need to match either current SQLID of the current user

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •