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
 

 

Diff btw LOAD RESUME and LOAD REPLACE

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

New User


Joined: 06 May 2005
Posts: 14

PostPosted: Tue Feb 28, 2006 2:47 am    Post subject: Diff btw LOAD RESUME and LOAD REPLACE
Reply with quote

Pls let me know the diff btw
LOAD RESUME and LOAD REPLACE

Thks
Back to top
View user's profile Send private message

amitava
Warnings : 1

Active User


Joined: 30 Oct 2005
Posts: 186
Location: India

PostPosted: Tue Feb 28, 2006 9:31 am    Post subject:
Reply with quote

Hi zatish,
I think by LOAD RESUME it means that the loading into DB2 table it will just start loading where after it was stopped. All the old datas will be available after loading here.
But by LOAD REPLACE it means that the table will be truncated and then the loading will take place. So by this way, all the old datas will not be available.
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Feb 28, 2006 10:59 am    Post subject: Re: Diff btw LOAD RESUME and LOAD REPLACE
Reply with quote

Hi,
LOAD RESUME will append the data to the table. That means you won't lost existing data.

LOAD REPLACE will delete the existing data in tablespace(i.e all the tables in tablespace will lost the data) and load the given data in mentioned table.



Hope you got me.


Thanks
Raghavendra
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 resume binary ftp in z/os meykh2014 All Other Mainframe Topics 6 Sun Jan 22, 2017 10:01 am
No new posts Replace repeated JCL with looping REXX prino CLIST & REXX 3 Thu Oct 13, 2016 5:30 am
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. Sort card to replace text using cross... Susanta SYNCSORT 32 Tue Sep 13, 2016 4:17 pm


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