Hanfur
Active User
Joined: 21 Jun 2006 Posts: 104
|
|
|
|
Hmurli,
Try executing DSNTIAUL program using TMP as given below.Here you should point to the library where DSNTIAUL prog is available and should refer the correspodning PLAN failing to do so would ends up in -818.Also need to mention the SYSTEM properly.
//STEP1 EXEC PGM=IKJEFT1B,DYNAMNBR=20,TIME=120,REGION=3072K
//STEPLIB DD DSN=DBP8.DB2.SDSNLOAD,DISP=SHR
//ISPPROF DD UNIT=SYSDA,SPACE=(TRK,(9,1,4)),
// DCB=(LRECL=175,BLKSIZE=27825,RECFM=FB,DSORG=PO)
//SYSUDUMP DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//REPORT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DB2T)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB71) PARMS('SQL') -
LIB('DBPT.DB2.RUNLIB.LOAD')
/*
//SYSPRINT DD SYSOUT=*
//SYSPUNCH DD DUMMY
//SYSREC00 DD DSN=UNLOADFILENAME,
// DISP=(NEW,CATLG,KEEP),
// SPACE=(CYL,(200,200),RLSE),
// UNIT=SYSDA,STORCLAS=SCNORMAL
//SYSIN DD *
SELECT NAME,EMPID FROM TABLE1
WHERE NAME='NAME'
/*
You can put your query inside SYSIN card.
-Han. |
|