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_spa m." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three" 4 1891
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
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
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
"Blair Adamache" <ba*******@2muc hspam.yahoo.com > wrote in message
news:c7******** **@hanover.toro lab.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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 software giant such as Microsoft SQL
Server, Oracle, and Sybase?
Is PostgreSQL reliable enough to be used for high-end commercial
application? Thanks
|
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 kit and created them
in DB2
but having tough time in transferring the data.
There are tons of identity colums (GENERATE ALWAYS AS IDENTITY) in these
tables.
|
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 similar.
Can someone point me in the right direction? What tool do you use in
DB2?
Thanks,
Brian
|
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 is:
1- Create the database
2- Tables
3- Insert the data
|
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 one of the topics
which I find interesting as I feel that it has a lot of practical usage or
applicability.
We all know that all applications need some storage space to archive certain
| |
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 my Dlls are located give the ASPNET user full
control, and all Dlls used by the Assembly in question are in the
local folder with the rest of the web application Dlls.
Could someone take a look at my error and shed some light on this?
|
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") ---- about 290kb
anyways I want to save the image as a GIF, but not have it be so
|
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 large XML logs
giving semi-structured information on the flow of the program. The XML
tree looks like the method calls tree, but at a much higher level, and I
add many values of some variables.
|
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
loading the gzip data! Im using the default buffer of the stream that i open
on the 20GB gzipped file and pass it into the GZipStream ctor. then
System.IO.Compression.GZipStream takes an hour! when just loading 50GB file
of data takes a few minutes!
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |