|
View previous topic :: View next topic
|
| Author |
Message |
sudhee_rb
New User
Joined: 29 Mar 2006
Posts: 34
|
|
|
|
Hi All,
How to load data(REPLACE) in more than one table(non partitioned table) in single job step.
I Used the load card as given below and got the error
KEYWORD 'REPLACE' REQUIRES KEYWORD 'PART'
| Code: |
----+----1----+----2----+----3----+----4----+----5----+----6----
LOAD DATA LOG NO
ENFORCE CONSTRAINTS
SHRLEVEL NONE
WORKDDN (SYSUT1,SORTOUT)
NOCOPYPEND
STATISTICS TABLE (ALL) INDEX (ALL KEYCARD)
REPORT YES UPDATE ALL HISTORY ALL
INTO TABLE owner.table1 REPLACE INDDN SYSRE001
DISCARDDN DISCARD
(
col1
POSITION ( 1 ) INTEGER
,
col2
POSITION ( 5 ) CHAR ( 3 ) )
INTO TABLE owner.table2 REPLACE INDDN SYSRE002
DISCARDDN DISCARD
(
col1
POSITION ( 1 ) CHAR(10)
,
col2
POSITION ( 11 ) CHAR ( 13 ) ) |
Edited: Please use BBcode when You post some code, that's rather readable...Anuj |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| KEYWORD 'REPLACE' REQUIRES KEYWORD 'PART' |
why do You feel that the messages is related to the multiple load ??
it looks like a simple keyword congruence mismatch |
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
| Also, you need to specify LOAD statement for each table seperately. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
also I dare to ask...
what savings are You expecting to achieve...
just troubles,
if one load fails instead of..
fixing the problem and resubmit the job
You will have to ...
fix the problem and modify the job to change the commands
also, remember, Your approach will not pass a decent production quality assurance |
|
| Back to top |
|
|
sudhee_rb
New User
Joined: 29 Mar 2006
Posts: 34
|
|
|
|
| Yes, i have tried with load statement for each table but still getting the same error. |
|
| Back to top |
|
|
sudhee_rb
New User
Joined: 29 Mar 2006
Posts: 34
|
|
|
|
Hi Enrico,
The tables which we are trying to load involves lot of RI's among them. so loading table one at a time may give problem due to cyclic RI's.
That's why I am going for this special way of loading..
Thanks,
Sudheer |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| yes, i have tried with load statement for each table but still getting the same error. |
before or after posting,?
in any case it looks like You did not care to read the manual for the message explanation |
|
| Back to top |
|
|
sudhee_rb
New User
Joined: 29 Mar 2006
Posts: 34
|
|
|
|
This message was for Srihari G.
"yes, i have tried with load statement for each table but still getting the same error."
enrico..Sorry for the confusion |
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
| Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005
Posts: 306
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If you have RI defined, then you need to load the tables in the proper order. Using one step or multiple steps will not correct loading the tables improperly. |
|
| Back to top |
|
|
|
|
