sakreg
Beginner
Joined: 28 Feb 2005
Posts: 80
Topics: 26
|
 Posted: Mon Jun 06, 2005 6:02 am Post subject: Anything wrong with my Delete JCL?!?!?!? |
 |
|
Hi,
I am trying to Flush Off data from MY_TABLE and also Unload all those data to be purged to a Dataset using the below JCL.
I am getting a SQL CODE -199. I do not see anything wrong in the DELETE SQL. Can you guys find anything wrong in the below JCL. If so plz correct me.
| Quote: |
***************************** Top of Data ******************************
//XXXXXX0 JOB (XXXX),'TEST DELETE SQL',CLASS=E,
// MSGLEVEL=(2,0),REGION=2M,NOTIFY=XXXXXX,MSGCLASS=T,TIME=(0,30)
//***************************************************************
//* FLUSH OUT ALL THE DATA FROM DB2 TABLE AND WRITE TO A DATASET*
//***************************************************************
//JOBLIB DD DSN=XXXX.DSNLOAD,DISP=SHR
//STEP0100 EXEC PGM=IKJEFT01
//*
//SYSTSPRT DD SYSOUT=*,DCB=BLKSIZE=121
//SYSPRINT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(XXXX)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) LIB('XXXX.RUNLIB.LOAD')
END
//SYSREC00 DD DSN=XXXXXX.XXXXXX.PURGED,
// DISP=SHR,
// UNIT=SYSDA,
// SPACE=(TRK,(1,2),RLSE)
//SYSPUNCH DD SYSOUT=*
//SYSIN DD *
DELETE FROM MY_TABLE;
/*
**************************** Bottom of Data ****************************
|
In Short what I want to achieve is to flush off data from the specified DB2 table using JCL. There actually is no need to write to the Dataset also. So if there is any better JCL, please post that also. |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
