I've tried LOAD .... INSERT INTO TABLE_NAME. The docs say about INSERT
option:
"One of four modes under which the load utility can execute. Adds the loaded
data to the table without changing the existing table data."

aix 5.3 with DB2 UDB 8.2
I am having trouble setting this registry and making it stick. I set
it using:
db2set DB2CODEPAGE=1208

When using SQLJ stored procedures in DB2 9, one has to manually create
a Connextioncontext if the procedure should be threadsafe. Now to use
this context one has also to prexif each #sql {} statement by this
context, like this "#sql [context] {}". I wondered if there is a

$db2evmon -db DEV1926 -evm DB2DETAILDEADLOCK was showing data from all
the runs whereas i want the data just for a single run. To capture
fresh events, I deleted the old events file. caveat was, I deleted
this event file while DB2DETAILDEADLOCK  was still  active (state 1).

At my current site we use packages for everything except some legacy
CA-IDEAL code which is still PLAN based.
We would like to convert them to use from plans to packages prior
upgrading our  subsystems from DB2 V7 to DB2 V8.

I have installed DB2 version 8.1 and created two databases, TEST1 and
TEST2. Two operating system users test1 and test2  are mapped to two
database users in TEST1 and TEST2 databases respectively.
Even though test2 user does not exists in TEST1 database, I am able to

This is the present situation.
1.I have Db2 9.1 installed on 1 AIX machines(server).I have database
created and everything is runniing.
2.I have another server with db2 9.1 and I want to connect from this

Whenever delete is performed on a DB2 database, it just returns
"...command completed successfully.."
db2 => select count(*) from sales
1

Hello, I am running DB2 UDB 8.2 on AIX 5.3.  I am running some tests
on converting several tables on an existing database to Unicode.  The
database will not be converted to unicode...just this table set.
I have successfully set this up and ran some tests using Japanese

       i want to create db2 account not using os account,HOW can i do
it?
it seems that  Kerberos  can help me ,but i find from info center that
finding groups must using os account,otherwise i must implements a

I have to servers(windows) one  I have DB2 v7.2 in the second I have
DB2 8.2 with CM
I have to migrate from the old version to the new version
I read a lot of mail most of then say user MIGRATE DATABASE but I'm

How can we add a column (alter) before certain column in DB2, just
like Informix has BEFORE OPTION
tHaNks
Rick

I have DB2 9.1 running on a Linux-server.
The database  is partioned into two nodes on this server.
On another Linux-server, acting as application server, I want to initiate
the backup.

I am having a table in DB2 whose structure looks like this :
Empno        Ename       Countries Visited
-----------       -----------      ---------------------------
100               Jack         'US','Austria','India'

I just wondered how I can do a SQL SELECT on a table that has more than one
member and I want do specify the name of the member. I tried
select * from filename(member)
and