473,387 Members | 1,549 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Cannot Load

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
0 1082

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

Similar topics

12
by: ~~~ .NET Ed ~~~ | last post by:
Hi, I have a standalone XML file (with the appropriate xml document header) that works fine when I load it using XmlDocument. I can have child elements like this without problems: ...
1
by: David C. allen | last post by:
I have created a simple Client-side SOAP Extension for a webclass that I have. When I apply the extension attribute to the the calling function in the proxy class I get an error 'Value cannot be...
5
by: Nathan Sokalski | last post by:
When running a page I am working on, I recieve the following error: Cannot use a leading .. to exit above the top directory. I suspect this has something to do with the problem I posted in a...
1
by: Simon Harvey | last post by:
Hi everyone, If anyone can help me with the following - I would be VERY grateful. I need to deploy an 2 ASP.net applications that I've been creating onto one of our live servers. Both...
3
by: navyliu | last post by:
I have raised a discussion about assembly unloading.But we can't get a final solution. Since we cannot unlaod a assembly,Is there any reference about this indicate that this problem won't make...
0
by: Madhu_TN | last post by:
Hi All, I am new to this board. I am trying to create a Crystal Report viewer into a VS C++ Dot NET 2003 app ( This uses both managed and unmanaged code). I get the following compilation error:...
1
by: edfialk | last post by:
Hi all, I'm desperately trying to get a simple mysql connection working in php 4.3.9 and I think I have a doozy for you guys. First of all, I didn't set up ANY of this system, I'm just working...
1
by: Fawad Ahsan | last post by:
Hi i am having problem with the microsoft enterprise library. i have uploaded the site to the hosting server and it gives the following error it works well in my server. can some one help me...
1
by: pzero24 | last post by:
Ok so I am making plugins for my application and I have the plugins located in a subdirectory: /AppDir /AppDir/Plugins All my plugins reference a Plugins interface file, which is also located...
1
by: kw.housing | last post by:
I have all the library already in path: $ ls -l /opt/IBM/db2/lib64 | grep libdb2o -r-xr-xr-x 1 bin bin 7757295 Jul 12 2006 libdb2osse.a* -r--r--r-- 1 bin bin ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.