I am writing a stored procedure in db2, and I want to return a cursor
as an out parameter of the stored procedure
How can I accomplish that....
Thanks in advance

I have 3 tables in db2 database.  I would like to write a cascading
delete statement and I dont want to use a trigger.  Could you please
explain how the statement needs to be?
My table straucture is as follows:

I am writing a sql query (added below) to calulate percentage.  Its
returning an integer value whereas I would like to get a float value
(with 2 decimal precision).
The query is:

I am writing a stored procedure in db2, and I want to return a cursor
as an out parameter of the stored procedure
How can I accomplish that....
Thanks in advance

Can any one show me a sample create table structure for storing .BMP's
and .GIF images. togther with its description.
Thanks in advance,
rAinDeEr

A previous dba has created few databases on my DB2 server V8.2 on AIX 5.3
My question is:
How do I come to know where were these databases created on? (CREATE
database dbname on <path>)

Hi, I get the following error when trying to connect to a database:
(I have cataloged the node and database and they show up in list node
directory and list db directory):
SQL30081N  A communication error has been detected.  Communication

Database:  DB2 AIX V8.*
Question: I want to be able to get the 'Client login ID' aka 'Execution
ID' (as opposed to the authid or application_id) for the current
connection within a stored procedure and without requiring SYSADM,

I have a curious problem.
Occasionally executing a simple select against an AS400 DB2 database
through JDBC fails with the following error: (SQLState = 57014) -
java.sql.SQLException: [SQL7962] Cursor CRSR0002 opened.

Linux RedHat 4.0 Update 2 + UDB 8 Fixpack 10.
Our instance crashed recently. I know I´d better open a PMR (I will do
it on Monday), but any suggestion as to what may be causing the error ?
Here is the diag:

I am now developing a java program connected to db2 via jdbc, and the db2
server(version 8.2) is installed in a visual machine running also on my
computer, however, i always found that the java program suspended when
sending a request to drop a stored procedure, I don't know why, ...

I have a multi-threaded application running on AIX 5.3 and DB2 8.2 that
takes snapshots from different threads. Each thread that takes snapshot
allocates an application context (using sqleBeginCtx), and frees it
when the thread goes down (using sqleEndCtx).

I'm trying to connect to DB2 Express-C for Linux using the JDBC
Universal Driver and I get the error below. I thought it was my code
then I installed Websphere Community Edition 1.0.0.1 and I'm now using
the IBM JDK 1.4.2. I wasn't planning to work directly with Websphere

I've downloaded DB2 UDB v8.2 for solaris and tried to install it on my DELL
Inspiron 6000 laptop with solaris 10 for x86 but getting errors like:
../db2/solaris/bin/disp_msg: cannot execute
../db2/solaris/bin/disp_msg: cannot execute

Why might this trigger cause an 803 error message when only 1 record
insert is ocurring?
If I take the primary key off the FR_HACCP_EOR_RES table the insert
occurs and only inserts 1 record.  If I put the primary key back on the