473,698 Members | 2,283 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

A few questions: LOAD/IMPORT/CLP stderr

aj
DB2 WSE LUW 8.1.5

A few questions:

Why doesn't IMPORT have IDENTITYOVERRID E support like LOAD does??

Why doesn't LOAD have CREATE INTO (ala IXF) like IMPORT DOES?

Why doesn't:
db2 -tvf blah.sql 2> blah.err
result in any error messages winding up in blah.err (everything
goes to STDOUT rather than STDERR)??

thanks

aj
Feb 16 '06 #1
1 1659
aj wrote:
DB2 WSE LUW 8.1.5

A few questions:

Why doesn't IMPORT have IDENTITYOVERRID E support like LOAD does??
Because IMPORT runs with normal INSERT statements. That will always tell
DB2 to generate those values for you. If you don't want that, you can
declare the column as GENERATED BY DEFAULT.
Why doesn't LOAD have CREATE INTO (ala IXF) like IMPORT DOES?


I would guess that's because LOAD does not issue SQL statements but rather
works on the data pages directly. Remember that you only need LOAD
authority (and not necessarily CREATETAB privileges).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Feb 17 '06 #2

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

Similar topics

6
1518
by: John J. Lee | last post by:
I'm tearing my hair out at what seems like weird import behaviour I'm getting from Python's stdlib test script, regrtest.py (not for the first time: seem to have forgotten the resolution from last time, and the time before, and the time before that, when this damn test script of Python's had me screaming at the screen... I don't seem to be learning my lesson here :( ) *Please* somebody inform me *what* affects what file Python will pick...
5
5066
by: Firehawk® | last post by:
Hi, I have a great experience with DB (Oracle and others) and I am using DB2 now. Then, I have few questions: 1. How drop a schema (user) and all objects of this schema, like a Oracle "drop user cascade" ? 2. Suposing, 2 Databases, DB1 and DB2, each one with a schema, schema1 in DB1 and schema2 in DB2.
0
1206
by: Gregory Piñero | last post by:
Hey Folks, Some import questions that a search didn't turn up for me. 1. Will "from somemodule import onething" take as long to start up as import somemodule? 2. Is there anyway I can get at onething more quickly? 3. If I put an import statement hidden away in some function, will Python only do the import when that function is called? If I say, never use that function would that import statement affect performance
35
7679
by: dhruvaraj | last post by:
Interview Questions : http://www.dhruvaraj.com/interview/cncpp/index.html online books http://www.dhruvaraj.com
3
8499
by: Me Alone | last post by:
Hello: I am trying to edit some C code I found in "The definitive guide to using, programming, and administering MySQL" by Paul DuBois. This C client program connects and then segfaults when the function load_image is called. Would anyone be able to point me to what I might be doing wrong? Thanks in advance, C Newbie
2
1937
by: T.Crane | last post by:
I'm new to python and I seem to get different behavior depending on... well who knows what. Here's my question concerning importation of packages/modules. I want to use scipy. So at the prompt (using iPython, installed with Enthought edition on Windows XP) I type: ln : from scipy import * Now, I know integrate is a package this is in scipy. I want to use
5
6754
by: jcolino | last post by:
Hi, I usually get stuck with one of two questions that keep coming up. Perhaps some of you brilliant people can shed some light... 1. How to do use if statements in load commands (I usually need this in the task center): if (select count(*) from mytable 1000) then load from file
10
1596
by: nisp | last post by:
Hi all ! I'm trying to capture stderr of an external module I use in my python program. I'm doing this by setting up a class in my module overwriting the stderr file object method write. The external module outputs to stderr this way: from sys import std err
0
1209
by: Nomen Nescio | last post by:
SQLITE Blob writing error wizard said: Yeah, no problem. We love SQLITE around here. You may need to include the header for unlink(). On a POSIX system, this would be unistd.h.
0
8676
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8608
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9164
Oralloy
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...
0
9029
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8870
tracyyun
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...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3051
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2006
bsmnconsultancy
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...

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.