473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
Aug 6 '08 #1
2 1781
Ian
ga***********@yahoo.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/infoce.../r0008304.html

Aug 6 '08 #2
Hi!

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

<ga***********@yahoo.comwrote in message news:78**********************************@27g2000h sf.googlegroups.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

Aug 7 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Naresh Agarwal | last post by:
Hi I've written a Custom class loader, which reads the bytecode from a database and returns the Class object. For example, bytecode of a class "Test" is stored in the database. Through custom...
2
by: Bo Brunsgaard | last post by:
I have a problem trying to run SQL*Loader after migrating to Oracle 9. It used to run with no hicups on Oracle 8i, and I'm at my wits' end. Any help? I'm trying to run SQL*Loader from a command...
6
by: Hari Om | last post by:
Here are the details of my error log files: I execute the command and get following message at console: ---------------------------------------------------------------------- ../sqlldr...
0
by: stef | last post by:
Hi, I have a range partitioned (one partition = one month) table. On this table I have a local unique index and a local domain index (Oracle Text) on a CLOB column. I'm running Oracle...
1
by: Roy Chastain | last post by:
I have read and re-read KB 814472. There appears to be a little 1984 New Speak in it. I am referring to option 3. DLL that contains consumers that use managed code and dll exports or managed...
3
by: noleander | last post by:
Im getting a runtime error because Ive got a static object that is not properly initialized. ---------- header file xxx.hpp --------------- class SomeClass { SomeClass() { .. constructor here...
6
by: Wilfried Mestdagh | last post by:
Hi, I'm trying out the demo version of FastReports. All is running fine in a small test project. I just copy my code from test project into a large application to demonstrate tomorrow but have...
0
by: gaikwadrachit | last post by:
Hi We are uploading a picture image(jpg) as a BLOB in a table using SQL Loader. We are parallely uploading the images at the same time from 2 different sessions on the server. The command for...
1
by: annappa | last post by:
hi friends, I have some doubt regarding loader, last stage in compilation is loader. After compilation we agail load the program, then what loader do in...
5
by: vshalpatel | last post by:
Hi I want to use SQL*Loader , an Oracle-supplied utility to load data from a flat file into one database tables. for this I have write the scripts in the SQL*LOADER control file named ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.