Currently I want to document all the tables, columns in the DB2
server. How can I grab the layout from DB2?
Thanks,
Tony

I am trying to access an 8.2 database through openoffice.org version 2.0 or
2.1. I am using the type 4 JDBC driver. Tables work OK, but when I attempt
to access a view I always get an sqlcode error value of -243 that seems to
indicate that the cursor sensitivity is incorrect. Has ...

I am new to DB2 and have been SQL Server developer. Is there any DB2
client tool that works like SQL Server's Enterprise Manager? Any help
is appreciated.
Thanks,

I am not able to really understand the explain plan output in case of
hash joins.
When tables A & B are being joined, how do I know which table is
being

Am a bit new to DB2. I have a small question though it may look silly
to most of u.
In which language is the Native API of DB2 / DB2 developed.
Thanx in andvance,

Hello I am a newbie in DB2.
I am trying out the Mapping Java definitions to SQL on UDT from the
article "DB2's object-relational highlights: Store and invoke
structured type objects" by Kathryn Zeidenstein.

I need to create a DB2 system DSN programmatically. I need to set the
currentschema parameter to be equal to the appropriate database name. I
am able to create the DSN ok, but am unable to add the currentschema
parameter. I am using visual fox pro 9. My code follows:

DB2 LUW 8.2 FP14 Red Hat AS 2.1
Before I call support, anyone have any idea what this is about?
The instance is otherwise healthy..
ps of PID 27441 is:

Within a stored procedure, I am looking for the command to end
execution.
I assume end, return, exit, quit.  All seem to fail.
In the event a condition occurs, I want to stop all processing within

We have a case where we want to attempt to do some processing, but if
the records are currently locked, we'd like to avoid processing (for
now, and move on to something else until the records are unlocked).
The problem is: how do we manage this?

I wondered if it is supported to extend the developer workbench by 3rd-
party eclipse plugins (specifically Subclipse and Web Tools) or, if
not, if it is possible the other way round: to put the DB2-extensions
into a "standard" eclipse environment.

Some of our SAS users seem to initiate 20+ idle connections to DB2 every
time they start SAS. I'm inclined to tell them to cut down on their DB2
connection number, but then again, if the connections are very cheap why
bother.

Can some one suggest me a way of putting Stored procedure output into a
file, the file should be available on my Computer, I don't want to use
FTP process.
Thanks

Hi , I am new to DB2. I would be glad if you can help me on this
following problem :
When i create a structured type , the following exception is thrown :
SQL0107N  The name "ADMINISTRATOR" is too long.  The maximum length is

We have a batch process that inserts large numbers (100,000 - 1,000,000) of
records into a database each day.  (DL/I database.)  We're considering
converting it to a DB2 table.  Currently we have logic in place that, prior
to inserting any data, reads the first input record and ...