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
 

 

Fast load options using Platinum Fast load job (PTLDRIVM)

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

New User


Joined: 31 Oct 2006
Posts: 48
Location: Chennai

PostPosted: Thu Dec 04, 2008 9:10 pm    Post subject: Fast load options using Platinum Fast load job (PTLDRIVM)
Reply with quote

Hi,
I want to load few tables using Platinum Fast load job (PTLDRIVM).
The options needed are:
1. Empty the existing data and load the input file to the table.
2. Load the input file to table and in case of any duplicate, replace the record in the table with the new record in the file.
3. Load the input file to table and in case of any duplicate, retain the record in the table.

Could you please let me know the syntax for each of the above options.

Thanks & Regards,
OP
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Dec 05, 2008 1:54 pm    Post subject:
Reply with quote

OP,

Solutions
1. RESUME NO REPLACE
2. I don't know this, you can do this sort things with load utility
3. DITO

Sushanth
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Fri Dec 05, 2008 3:43 pm    Post subject:
Reply with quote

Quote:

Empty the existing data and load the input file to the table

Code:

LOAD DATA REPLACE LOG NO NOCOPYPEND INDDN SYSREC00     
   INTO TABLE TABLENAME
 

Quote:

Load the input file to table and in case of any duplicate, replace the record in the table with the new record in the file.


Did you mean to say if there are same unique key fields in the load file which exists in table it should be replaced by new value

Quote:

Load the input file to table and in case of any duplicate, retain the record in the table.

Code:

LOAD DATA RESUME LOG NO NOCOPYPEND INDDN SYSREC00     
   INTO TABLE TABLENAME
 
[/code]
Back to top
View user's profile Send private message
op

New User


Joined: 31 Oct 2006
Posts: 48
Location: Chennai

PostPosted: Fri Jan 16, 2009 8:44 pm    Post subject:
Reply with quote

Yes, I meant "If there are same unique key fields in the table and the file to be loaded, reatin the records already in the table and ignore (and dont load) the new record from the file."

One more question:
The fast load options for
(a)Empty the existing data and load the input file to the table
and
(b)Load the input file to table and in case of any duplicate, retain the record in the table
are the same. Can you please confirm if it is correct.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Sat Jan 17, 2009 5:57 pm    Post subject:
Reply with quote

OP Hi,
How come your question seems to be same still after a month. Prasanth has posted 2 types of load syntaxes,
i) Replace all the data of the table
ii) Add data or Append data to the table

If you are looking for FASTLOAD syntax, You r looking for,
Ans(a). RESUME NO REPLACE
Ans(b). RESUME YES

Thank You,
Sushanth
Back to top
View user's profile Send private message
op

New User


Joined: 31 Oct 2006
Posts: 48
Location: Chennai

PostPosted: Tue Jan 20, 2009 10:15 pm    Post subject:
Reply with quote

Hi Sushanth,
My question was, the syntax given by Prasanth for 2 different operations was the same. I just wanted to confirm if the syntax given was correct. Just a confirmation.
But anyway, thanks for your clarification.

Regards,
OP
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 Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
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


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