Using a utility to load an extract file to my table

Sivagurunathan Jagadeesan · New User Joined: 06 Mar 2007 Posts: 32 Location: India

Hi,

I am using a utility to load an extract file to my table. I would like to know what will be the impact to the table or Database in general, when the following statements are used,

A)
LOAD DATA LOG NO RESUME NO REPLACE NOCOPYPEND
STATISTICS TABLE ALL INDEX ALL DISCARDS 0
INDDN SYSREC00 INTO TABLE XXXX.YYYYY.ZZZZZ

B)
LOAD DATA LOG YES RESUME NO REPLACE ENFORCE NO
STATISTICS TABLE ALL INDEX ALL DISCARDS 0
INDDN SYSREC00 INTO TABLE XXXX.YYYYY.ZZZZZ

We are using the second (B) statement to load 12 tables in parallel through batch jobs. My concern is that I have read that an Enforce NO option would leave the table in check pending status (meaning it cannot be queried isn?t?), so I would like to understand the meaning of the above statements as a whole.

Thanks in Advance,
Siva

wanderer · Posted: Mon Jun 11, 2007 10:16 pm

To be sure of exactly what they mean, please go through the cpater on LOAD in utility guide listed under the link on top of the forum called 'Manuals.

That is really helpful!

Sivagurunathan Jagadeesan · New User Joined: 06 Mar 2007 Posts: 32 Location: India

Hi,

Sure, will do, Thanks for the pointer.

Regards,
Siva

kavisuresh · New User Joined: 22 May 2007 Posts: 7 Location: chennai

LOAD DATA LOG NO RESUME NO REPLACE NOCOPYPEND
Above control card will delete the existing records from the table and load with the records which needs to be loaded

LOAD DATA LOG YES RESUME NO REPLACE ENFORCE NO
This control card will append the existing records and load the records
inside the table.

Checkpending is nothing but whenever you load a child without the parent you will get the tables into checkpending status but not as mentioned by you

Sivagurunathan Jagadeesan · New User Joined: 06 Mar 2007 Posts: 32 Location: India

Hi,

Thanks for the info, going by the definition you had given, I guess "NO COPYPEND" is the keyword which will delete the existing records and then load the table. In that case, I will have to include that as well.

Regards,
Siva

wanderer · Posted: Wed Jun 13, 2007 10:02 am

Siva,

I thought you were going through the manual!.

It is nice to verify things for yourself in an official manual if possible, rather than believe in someone blindly.

What Kavisuresh has written is incorrect.

Pandora-Box · Posted: Wed Jun 13, 2007 11:15 am

I agree with you wanderer.

Siva,
please go through those manuals by clicking at manuals link given at the top of this page.The manuals are very clear and has numerous examples.

Sivagurunathan Jagadeesan · New User Joined: 06 Mar 2007 Posts: 32 Location: India

Hi All,

The concern that is shown over someone going wrong is amazing. Thanks a lot.

Actually I too realized (on my way to office!) that Kavisureh was not wholly correct, and am going through the manual.

Kavi not a problem it is just a learning experience

Thanks,
Siva