DB2 EE LOADER

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

gayathri_infa@yahoo.com wrote:

Quote:

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/infoce.../r0008304.html

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:

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

DB2 EE LOADER

re: DB2 EE LOADER

re: DB2 EE LOADER

/bytes/development

/bytes/it

/bytes/about