Greetings Folks,
I am trying to understand how DB2 locks data and can't believe my eyes.
Have read the literature about the difference isolation levels and have
a general understanding about intent, update, share and exclusive

I apologize if this is off-topic. If it is off-topic, please direct me to a
more appropriate group.
I am writing an SQL query for a project and am a little stuck. I need to
classify a list of employees into age brackets. (E.g.. 16-15, 25-35, etc.) I

Good Afternoon,
I have a Java stored procedure on DB2 z/OS and it is using the Type 4
JDBC driver to access an Oracle database.  After I get the data from
the Oracle dataabse I try to return it from my SP as a result set, but

Please let me know the various choices of DB2 SQL Profilers used to
analyze Stored Procedures !!
-Vj

Why doesn't db2 allow dropping of columns?
I know this issue has been raised several times, but I never saw any
clear answer. It doesn't have to be fast, as long as it's possible.
Now I need to export data, drop table, create table, import data, create

I am migrating a DB from AIX (DB2 7.2) to Linux (DB2 8.2).
I have migrated the whole thing using db2move and reapplying DDLs to
recreate all the other objects.  The system is up and running.  This
part is OK, I have done it plenty of times.

how can I tell how many agents are used per application.
how can I tell how many agents are used per connection.
I'd appreciate your input. With 20 applications we are using around 400
agents(maxagents,max_coordagents) and getting -1223 sqlcode.

I'm have a SQL stored procedure where I need to filter a string of
Char(35), this code gave me a compilation error:
SET vCTR1=2;
CLEAN_Name: WHILE vCTR1 <= 34

We are connecting to a DB2 database residing on an AIX machine via
JDBC.
In order to lock some row of records, we use the "select . . . for
update . . . " Java statement:

Hmm... Simple select through primary key
1. SELECT REFERENCE FROM CCTL.DOCSTSREG WHERE DOCID=?
2. SELECT REFERENCE FROM CCTL.DOCSTSREG WHERE DOCID=(PREVVAL FOR
CCTL.sq_docidstsreg)

Please let me know how are logging done in DB2 Stored Procedures.
I have been trying this way.
1) Declaring a cursor with host variables selected from the dummy table
   declare c5 cursor with return for

Norbert Munkel wrote last october:

sntable;

I am trying to create a referential constraint using the alter table
statement and get the following message
DB21034E  The command was processed as an SQL statement because it was
not a

I'm running DB2 V 7.1 and I wish to write a SELECT query that queries
tables in multiple tables in different databases on the same instance.
Is this possible and if so, what should the FROM clause look like?
Thanks for your help...

UDB 8.2.8 Win
We have a procedure which execute dynamically prepared SELECT. We need call
this procedure in another procedure.
CREATE PROCEDURE P_CCC(IN PSQLTXT CLOB(2M))