Hi again folks, I know I have been thrashing this newsgroup over the
past week, and asking all manner of silly questions, but I ask for
your patience with a newbie.
Ive been reading a lot of articles in here regarding the autocommit

I am creating a dynamic table that will only contain between 1-500
rows.
Once the row is processed it is deleted. during prime time there will
be close to 500 rows. on weekends and off hours there will be close to

Id like to profile an SQL (a very sloow sql) in order to optimise the
query. i.e to know  how long it takes to process and whats its doing
(the equivalent of the used EXPLAIN in mySQL.)
In DB2 Im running 'explain all...' and then obtaining the output using

(Windows 2000, db2 version info below)
I have something weird going on that I can't figure out.
I can connect to a database and run a query fine using CLP.
When I try to run it with any GUI app (e.g. Command Center or Quest

For the life of me, I cannot find in the manuals, how to change the
delmiting character of a DEL type file we are using for a load. The
file uses | instead of commas, and I need to accommodate.
P.S. I hate the new "information centre".  Give me the command

Best regards Lars Wikstrom

I wonder if federation uses index on other DB2 databases?
Best regards Lars

Dept    Date        State        Plan
D1    20040309    CA        p1
D1    20040309    NY        p1
D1    20040309    PA        p2

I am thinking about joining 4 different databases using the federated
feature. If I then look in the database using ODBC can I then see these
"new" tables?
Best regards Lars

I have created a User Defined Function(UDF) on db27.1 Z/os. I am using
the function in one of my Java Stored Procedures. When i build the
stored procedure through stored proc builder i get the following
error. Any pointers on this would be of greate help.

hi, we are using db2 udb v8.1, i would like to know is there a way by
using sql to query two different tables which exists on  two different
database on the same server. thanks

I am new with V8 windows.  I am looking to get the data that the
journal provides and display it on a web page.  I am looking for the
data on the output tab of the show results window.
I have found a few things that I think are pointing in the right

hi, i am using db2 udb v8.1, i would like to know if there are more
than one database under DB2 instance, i have updated one of the
database configuration parameter( such as logfilsiz,  dbheap,
locktimeout ...), can only this database restart to effect the change?

hi, currently i have a licensed DB2 UDB v8.1 installed, and i put the
fixpack 4 on top of it, but when i do db2binding, i get the error
stating that the driver is not licensed, why is that? please help?
C:\Program Files\IBM\SQLLIB\BIN>java -cp "c:\program

Tokunaga T. (tonkuma@jp.ibm.com) rote