DB2 EE LOADER

Question posted by: gayathri_infa@yahoo.com (Guest) on August 6th, 2008 11:15 AM

Dear Experts,

I would like to ask a question on Db2 Load as iam pretty new to DB2
UDB
i have to load file with million of records to a Db2 table.

Could you provide me with some sample codes for Insert, Updates or
insert else update

Your help is highly appreciated.

Thanks a Lot
Gayathri

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

Ian

Guest

n/a Posts

August 6th, 2008
06:25 PM
#2

Re: DB2 EE LOADER

Join Bytes! wrote:

Quote:

Originally Posted by

Dear Experts,
>
I would like to ask a question on Db2 Load as iam pretty new to DB2
UDB
i have to load file with million of records to a Db2 table.
>
Could you provide me with some sample codes for Insert, Updates or
insert else update

The DB2 LOAD utility does not do upsert processing.

The IMPORT utility can do this. Please see the command reference
for IMPORT for more details and examples.

http://publib.boulder.ibm.com/infoc...c/r0008304.html

Dan van Ginhoven

Guest

n/a Posts

August 7th, 2008
07:05 PM
#3

Re: DB2 EE LOADER

Hi!

You could load the file into a work table and then use the merge statement.
/dg

<gayathri_infa@yahoo.comwrote in message news:78b15b0d-f346-42a1-862d-152119d65b21@27g2000hsf.googlegroups.com...

Quote:

Originally Posted by

Not the answer you were looking for? Post your question . . .
184,013 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors