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:

your schema name need to match either current SQLID of the current user