being a retrograde vi kind of guy, i can run a vi-able editor
when i use WSAD or Eclipse (both java programs), but i don't
see any plug-in menu items here.
any chance of getting plug-in support into Dev Center??

All:
What is the equivalent of Oracle BULK COLLECT  in DB2 UDB?
I do see MUTIPLE-ROW SELECT in DB2 ON Z/OS, where in INTO hostvariables
can be declared as arrays.

Occasionally we see these messages in the db2diag.log file.  Can someone
tell me what they mean and are they anything to worry about?
2005-03-03-10.42.04.286220   Instance:db2inst1   Node:000
PID:64936(db2sysc 0)   TID:1   Appid:none

I am trying to select only a certain number of records from a table.
It is easy enough with "fetch first" syntax.  What complicates this a
bit is the fact that I need to retrieve the number of rows from another
table.  So:

I'm tring to execute LOAD command with VB6.
..connection...
strSQL = "load from c:\temp\pippo.dat of del modified by coldel'|'
insert into MYTAB"

Environment: DB2 V8.2 on AIX
I find a SP SYSPROC.DB2LOAD for loading a table using cursors ... I
have tried to use the procedure and it seems to work as I want it to
... But, I am unable to find any documentation for the procedure ..

I'm having some migration problems.
On Friday, I upgraded from DB2 7.2 (FP9) to DB2 8.2 (FP7), then applied
Fixpack 8. I'm running Windows XP.
My migrations did not work and I am trying to fix them manually. The

1. In the oracle trigger we have a SINGLE INSERT STORED PROCEDURE
CALLED MUTLIPLE TIMES with different values.
But when changed to DB2, it gives SQL -746 ?? Any help??
2. In oracle we have

I installed DB2 for Linux, Unix, and Windows on V8.2 (i.e. 8.1.7) on
Windows XP on Friday. I had some problems with migration which are still
outstanding - see my earlier thread - but I managed to drop the old
SAMPLE database and create a new one that works fine. That enabled me ...

I ran a couple of testing today. One of them I ran the following:
(1). truncate mytbl. (4 db partitions; Version8.1 + FixPak5)
(2)  run "import from myfile.del of del insert into myble"
I knew I would get "Log full". But I didn't expect I still got some records

I was reading the DB2 for Linux/Unix/Windows (V7.2) manuals just now to get
some background information about UDFs when I came across this:
"Note that valuable debugging tools such as printf() do not normally work as
debugging aids for your UDF, because the UDF normally runs in a ...

Since I haven't been able to find out yet how to get my Eclipse debugger to
step through my Java UDF code, I am adding old-style File I/O debugging to
some of my UDFs. I'm not sure of the best way to design this though and am
looking for some suggestions.

Would it be possible to construct SQL to concatenate column values
from multiple rows?
SELECT ... FROM T1, T2 WHERE T1.key=T2.fkey (group by key?);
The following is an example:

I would like to know how the following task is accomplished:
Updating the Primary Key in the parent table when there are other tables
that reference this Key(Foreign Key)
Is there a way to have DB2 handle this task for you..

Shameless self promotion ;-)
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0501rielau/
I've now reached the end of my "mini-series" around SQL Procedures.
If anyone has ideas on SQL related topics that need illuination I'm all