Folks,
 I am having problem running select query from a sequence. I get SQL0204N
 error. I am running UDB 8.2 on AIX 5.2.
# oslevel

Hoping someone can help here..
Our application (C#.Net) was receiving  IBM.Data.DB2.DB2Exceptions
ERROR [57011] [IBM][CLI Driver][DB2] SQL0904N  Unsuccessful execution
caused by an unavailable resource.  Reason code: '', type of resource:

I'm running DB2 v 7.2 FP 9.
After connecting to DB2, i ran the following commands:
set path = "SYSIBM","SYSFUN","DB2ADMIN","SYSPROC"
SELECT * FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS INSTANCEINFO

my error is:
"SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "sqlriResolveOpFunc:
invalid opcode ...".) SQLSTATE=58004"

Also, noticed there is now a separate fixpak 9 for Linux 2.6 Kernel in
addition to the regular Linux fixpaks.

Quick question on port numbers (V8.1 or V8.2):
Is it true that on HP11, db2icrt command ignores -p option for port
(Non DPF)? Does DB2 always take 60000 (assuming this is the first
instance),  regardless of what's passed to -p option (only on HP11)

How can I get the DB2 version installed on the Red hat linux server ?.
Not the 'release.notes' file but the actual DB2 version installed on
the particular server. What is the command line syntax for it ?
Thanks.

All:
I am writing a MAIN CALLING PROCEDURE. This call lot of procedures.
Some of the CALLED PROCEDURES end with an OPEN C1 (cursor). How to I
read this open cursor in my main procedure?? In java or C we can

All:
I want to debug stored procedures in V8.2 and specifically see the
values of my dynamic constructs.
 set v_sql ='SELECT COUNT(*) FROM  DB2ADMIN. ' || v_table_name;

i saw that Jacelyn Yswan has posted already at 23th of February for the
same problem, but apparently there was no solution. Maybe someone knows the
reason today.
We use Fix 8 since 7th of march on AIX 5L and we still get the error

You can use the following SQL to construct rows with column names
on the fly, rather than from an existing table like sysibm.sysdummy1:
 SELECT * FROM TABLE (
  VALUES (0, 1, 2), (3, 4, 5), (6, 7, 8)

Hey all,
at the company where I work we had a strange situation yesterday.
Our DB2 database locked up, or as it later seemed, the DBM, or some
connection manager.

I'm connecting to a db2 8.2 database and
schema using the following two commands :
db2 connect to MYDB user me using helloworld
db2 current schema MYSCHEMA