Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Loading using DSNUPROC

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

New User


Joined: 14 Mar 2006
Posts: 39

PostPosted: Fri Jul 21, 2006 11:16 am    Post subject: Loading using DSNUPROC
Reply with quote

Hi,

I 'am using DSNUPROC to load data into Db2 tables.i have a following scenario.

Initially TableA had 50 rows then I loaded 50 rows. so totally now i have 100 rows in TableA. Now i want to replace the 50 rows what ever i've loaded with the new set of data other than primary key.

I went through replace option but it will replace the entire set of 100 rows with the 50 rows whatever i loaded. Is there anyway to replace the 50 rows whatever i've loaded leaving the rest of the 50 rows intact.

Thanks in advance.
Back to top
View user's profile Send private message

ravi17s
Warnings : 1

New User


Joined: 15 Aug 2003
Posts: 57

PostPosted: Fri Jul 21, 2006 5:40 pm    Post subject: Re: Loading using DSNUPROC
Reply with quote

Krishna,

1. Unload the entire table first
2. Load the new data with REPLACE
3. Now LOAD the data wihich you have UNLOADED(SYSREC) with DISCARD OPTION.

The duplicates rows will be discarded automatically and only those First 50 rows will be loaded.But LAST_MODIFIED_DTM and CREATE DTM differs.

Hanfur please help me in solving Krishna's Requirement.Wat do you think?


Thanks,
Ravi...
Back to top
View user's profile Send private message
krk_kumar1

New User


Joined: 14 Mar 2006
Posts: 39

PostPosted: Fri Jul 21, 2006 6:09 pm    Post subject:
Reply with quote

Thanks for u'r quick response Ravi.I told that table has 50 rows as example but the table actually has arround 700 million rows and i'am trying to update nearly 10 million rows.unloading all and loading them again will be a tedious task and will take more time as well. Is it possible by any chance to replace those 50 rows alone other than writting any program.
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 Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm
No new posts unload thetable data using DSNUPROC ... Madhusudhan Prahlad DB2 4 Tue Dec 01, 2015 5:04 pm
No new posts Loading assembler table in COBOL Batc... guy jax COBOL Programming 7 Mon Mar 16, 2015 4:58 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us