|
|
| Author |
Message |
brindha christy
New User
Joined: 26 Aug 2008
Posts: 20
Location: India
|
|
|
|
I am using the following JCL to unload DB2 table into a flat file:
//STEP10 EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)
//SYSREC00 DD DSN=XYZ.ABC.DB2.UNLOAD3,
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(CYL,(100,100),RLSE)
//SYSPUNCH DD DUMMY
//SYSTSPRT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DBXX)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL')
END
/*
//SYSIN DD *
SELECT * TABLE.TABLENAME
;
/*
I am getting MAXCC 12 with the following message:
READY
DSN SYSTEM(DBXX)
IKJ56500I COMMAND DSN NOT FOUND
READY
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL')
IKJ56712I INVALID KEYWORD, PLAN(DSNTIAUL)
IKJ56712I INVALID KEYWORD, PARMS('SQL')
READY
END
READY
END
WHat is wrong in my job |
|
| Back to top |
|
 |
References
|
|
 |
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 8728
Location: 221 B Baker St
|
|
|
|
Hello,
It looks like there may one or more libraries missing. You may need to add a steplib. |
|
| Back to top |
|
|
lc.milani
New User
Joined: 02 Oct 2008
Posts: 1
Location: Italy
|
|
|
|
Hi, i had the same problem.
you need to define a steplib with the library where the DSN load is.
my jcl:
| Code: |
//DB2SQL EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(0,NE)
//STEPLIB DD DISP=SHR,DSN=DB2P.V7.RUNLIB.LOAD
// DD DISP=SHR,DSN=DSN.V7.SDSNLOAD
//SYSTSIN DD *
DSN SYSTEM(DB2P)
RUN PROGRAM(DSNTIAUL) -
PLAN(DSNTIAUL) -
PARM('SQL')
END
/*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSPUNCH DD DSN=my.SYSPUNCH,
// DISP=(NEW,CATLG,DELETE), etc....
//SYSREC00 DD DSN=my.file.output,
// DISP=(NEW,CATLG), etc....
//SYSIN DD *
SELECT my_field
FROM mydb.mytable
WHERE my-conditions
/*
|
DB2P.V7.RUNLIB.LOAD : here is the DSNTIAUL's load module
DSN.V7.SDSNLOAD: here is the DSN's load module
you must find theme out in your system settings...try asking to db administrators...
Greetings. |
|
| Back to top |
|
|
|
|
|
