By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

Cannot Load

P: 1
Hi
I'm trying to run a LOAD jcl but ends with a return code=08
The error is TABLESPACE IS NOT EMPTY
I need to replace the data in the table.

Here's the job

//PASO01 EXEC DSNUPROC,SYSTEM=DSND,UID=LOADEQDO,
// UTPROC='',REGION=8M,COND=(4,LT)
//SYSUT1 DD UNIT=WORK,
// SPACE=(CYL,(5,3),RLSE)
//SYSPRINT DD SYSOUT=*
//SYSDISC DD SYSOUT=*
//SORTOUT DD UNIT=WORK,
// SPACE=(CYL,(5,3),RLSE)
//SYSERR DD UNIT=SYSDA
//SYSMAP DD UNIT=WORK,
// SPACE=(CYL,(5,3),RLSE)
//UTPRINT DD SYSOUT=*
//SYSREC DD DSN=CCALE.S.DB2R.MMEQDODP.F070621,
// DISP=SHR
//SYSIN DD DSN=CCALE.S.DB2S.MMEQDODP.F070621,
// DISP=SHR
/*
-------------------------------------------------------------------
The sysin dataset starts with the command
LOAD DATA
LOG NO ENFORCE NO
EBCDIC CCSID(0284)

INTO TABLE MIRRUSEA.MMEQDODP
(
EQD_COD_CAR_CTC_CD
POSITION ( 1 ) INTEGER
,
EQD_COD_DOM_CTC_CD
POSITION ( 5 ) CHAR ( 12 )
,
EQD_COD_DOM_LAT_CD
POSITION ( 17 ) INTEGER
...


Is there anything I can do so that it makes a Load replace? I don't want to edit every dataset to add LOAD DATA REPLACE

Thanx for your help
Jun 28 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.