DB2 EE LOADER

[gayathri_infa@yahoo.com]

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

[Ian]

Re: DB2 EE LOADER

gayathri_infa@y ahoo.com wrote:

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/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0008304.html

[Dan van Ginhoven]

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@27 g2000hsf.google groups.com...

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