View previous topic :: View next topic
|
Author |
Message |
op
New User
Joined: 31 Oct 2006 Posts: 48 Location: Chennai
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
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 |
|
|
op
New User
Joined: 31 Oct 2006 Posts: 48 Location: Chennai
|
|
|
|
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 |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
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 |
|
|
op
New User
Joined: 31 Oct 2006 Posts: 48 Location: Chennai
|
|
|
|
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 |
|
|
|