473,387 Members | 1,742 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,387 software developers and data experts.

What data loading tool for DB2?

I'm in the Oracle and SQL Server world. In those worlds, we use
SQL*Loader or DTS, respectively, to load large amounts of data from a
flat file to the database. I'm assuming that DB2 has something similar.
Can someone point me in the right direction? What tool do you use in
DB2?

Thanks,
Brian
--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Nov 12 '05 #1
4 1869
How about the DB2 Load Utility?

Larry Edelstein

Brian Peasland wrote:
I'm in the Oracle and SQL Server world. In those worlds, we use
SQL*Loader or DTS, respectively, to load large amounts of data from a
flat file to the database. I'm assuming that DB2 has something similar.
Can someone point me in the right direction? What tool do you use in
DB2?

Thanks,
Brian


Nov 12 '05 #2
How about the DB2 Load Utility?

Larry Edelstein

Brian Peasland wrote:
I'm in the Oracle and SQL Server world. In those worlds, we use
SQL*Loader or DTS, respectively, to load large amounts of data from a
flat file to the database. I'm assuming that DB2 has something similar.
Can someone point me in the right direction? What tool do you use in
DB2?

Thanks,
Brian


Nov 12 '05 #3
The name of the command is LOAD. It's documented in the Command
Reference manual.

Brian Peasland wrote:
I'm in the Oracle and SQL Server world. In those worlds, we use
SQL*Loader or DTS, respectively, to load large amounts of data from a
flat file to the database. I'm assuming that DB2 has something similar.
Can someone point me in the right direction? What tool do you use in
DB2?

Thanks,
Brian


Nov 12 '05 #4
"Blair Adamache" <ba*******@2muchspam.yahoo.com> wrote in message
news:c7**********@hanover.torolab.ibm.com...
The name of the command is LOAD. It's documented in the Command
Reference manual.

Manual? You expect someone to read the manual?
Nov 12 '05 #5

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

Similar topics

125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
6
by: Dave | last post by:
Hi We need to migratedata for about 300 tables from MS SQL server database to Linux DB2 V8.1. Total size of all 300 tables is @ 3 GB. We have converted tables DDL using IBM migration tool...
0
by: Brian Peasland | last post by:
I'm in the Oracle and SQL Server world. In those worlds, we use SQL*Loader or DTS, respectively, to load large amounts of data from a flat file to the database. I'm assuming that DB2 has something...
3
by: serge | last post by:
I have all the scrips to create a database. I have a few questions: 1- I am creating a batch file that it will call many lines like: db2 -td@ -f filename.sql -z output.txt The order i am using...
0
by: Namratha Shah \(Nasha\) | last post by:
Hey Group, After a long week end I am back again. Its nice and refreshing after a short vacation so lets get started with .NET once again. Today we will discuss about Isolated Storage. This is...
1
by: Brian | last post by:
I've looked through the previous posts on this one and have verified permissions and location of my Dlls, but I am still getting an exception when I try to Load an assembly. The directory where...
10
by: abcd | last post by:
I have PIL 1.1.5 on python 2.4.1 and I am attempting to get a smaller (file size) of an image. for example: im = ImageGrab.grab() im.save("tmp.gif") ---- about 1.7mb im.save("tmp.jpeg") ...
17
by: Luc Mercier | last post by:
Hi Folks, I'm new here, and I need some advice for what tool to use. I'm using XML for benchmarking purposes. I'm writing some scientific programs which I want to analyze. My program generates...
5
by: DR | last post by:
Why is its substantialy slower to load 50GB of gzipped file (20GB gzipped file) then loading 50GB unzipped data? im using System.IO.Compression.GZipStream and its not maxing out the cpu while...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.