467,113 Members | 1,303 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,113 developers. It's quick & easy.

Cannot Load

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
  • viewed: 974
Share:

Post your reply

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

Similar topics

12 posts views Thread by ~~~ .NET Ed ~~~ | last post: by
1 post views Thread by David C. allen | last post: by
1 post views Thread by Simon Harvey | last post: by
1 post views Thread by edfialk | last post: by
1 post views Thread by Fawad Ahsan | last post: by
1 post views Thread by kw.housing | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.