Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Using a utility to load an extract file to my table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Sivagurunathan Jagadeesan

New User


Joined: 06 Mar 2007
Posts: 32
Location: India

PostPosted: Mon Jun 11, 2007 4:44 pm    Post subject: Using a utility to load an extract file to my table
Reply with quote

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
Back to top
View user's profile Send private message

wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Mon Jun 11, 2007 10:16 pm    Post subject: Re: Using a utility to load an extract file to my table
Reply with quote

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!
Back to top
View user's profile Send private message
Sivagurunathan Jagadeesan

New User


Joined: 06 Mar 2007
Posts: 32
Location: India

PostPosted: Tue Jun 12, 2007 7:37 am    Post subject: Re: Using a utility to load an extract file to my table
Reply with quote

Hi,

Sure, will do, Thanks for the pointer.

Regards,
Siva
Back to top
View user's profile Send private message
kavisuresh

New User


Joined: 22 May 2007
Posts: 7
Location: chennai

PostPosted: Tue Jun 12, 2007 3:13 pm    Post subject: Re: Using a utility to load an extract file to my table
Reply with quote

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
Back to top
View user's profile Send private message
Sivagurunathan Jagadeesan

New User


Joined: 06 Mar 2007
Posts: 32
Location: India

PostPosted: Wed Jun 13, 2007 7:54 am    Post subject: Re: Using a utility to load an extract file to my table
Reply with quote

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
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Wed Jun 13, 2007 10:02 am    Post subject: Re: Using a utility to load an extract file to my table
Reply with quote

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. icon_sad.gif
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1530
Location: Andromeda Galaxy

PostPosted: Wed Jun 13, 2007 11:15 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Sivagurunathan Jagadeesan

New User


Joined: 06 Mar 2007
Posts: 32
Location: India

PostPosted: Wed Jun 13, 2007 10:45 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us