DB2 WSE LUW 8.1.5

A few questions:

Why doesn't IMPORT have IDENTITYOVERRIDE 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

aj wrote:

> DB2 WSE LUW 8.1.5
>
> A few questions:
>
> Why doesn't IMPORT have IDENTITYOVERRIDE 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