I am newer to db2 and have to use alot of queries that were already  in
place.  In the following example I have added the subselect statement
because I needed to know the max date of the result set for a report
and it had to come back from the query as the report will only allow

I have a table which has claims data..On any  particular day I will
have to extract all the record from the previous month.(considering
leap years and months like Feb 28/29 days)
can you please help me...

[DB2/SUN 8.1.6]
I've been asked to time about forty PROCEDUREs in the database, and
keep a history of them for comaprison. So, i figured i'd quickly try it
in the database itself, so anyone could execute it easily. Here's the

DB2 ESE 8.2.3 (FP10) for Linux
We are experiencing a connection hang of 10 - 15 minutes in the following
HADR and automatic client reroute scenario:
01 server is primary database

IMHO, statements like this is mistake typically.
May be more better made this construction - I said about empty WHERE -
invalid? A lot of data will saved... :-)
Andy

I am trying to install onDemand content manager for Linux
I am looking at these instructions
http://publib.boulder.ibm.com/infocenter/cmod/v8r3m0//topic/com.ibm.ondemand.mp.
doc/ars1i07135.htm
How do I create an instance with SYSADM1 groupname?

In the past I have been dealing mainly with sql server, and recently
been given the task of supporting software that uses db2 on as400.
Simple tasks such as executing a stored procedure from a query window
have proven more troublesome than I expected.

I am using the DB2 Type 4 JDBC Driver to connect to my DB2 8.2 for
Windows server.  Everything works perfectly unless I have a password
with the pipe character ( "|" ) in it.  The server password has a "|"
character in it.  If I do this, I get an exception stating that the

Does anyone have a definition for this.  I do not see it in any of the
references including the DB2 Info Center website.  I am getting this
after a declare cursor.  I am not sure what the problem is unless I
know what the error means.

Creating a table with an identity column works fine
create table test(a integer, id integer  generated always as identity )
When I attempt to add an identity column it fails.
create table test2(a integer)

Environment is: DB2 V8 FP10 Linux Kernel 2.6
My db2diag.log is full of the following lines:
2006-02-01-15.56.26.557312-120 E405226240G308     LEVEL: Error (OS)
PID     : 31005                TID  : 4143875776  PROC : db2pclnr

I am making webservice that updates data of a table of DB2 to one in
SQL and these in first go off to certain time of the night but in case
that new data are added to the table that this in DB2 is necessary to
shoot to trigger call to the Web service that is made in .Net, have

I have a table t1(id, other stuff) with 4 dependent (unrelated) tables
ta(id, date, other stuff a), tb(id, date, other stuff b), tc(id, date,
other stuff c), td(id, date, other stuff d). Any or all of the dependent
tables may have rows associated with a given id from t1. What I ...

It seems FP11 is available from ftp.software.ibm.com/ps/products/db2/fixes2
...
Could you put online the APARLIST, because I need to check some of my issues
?

Here is an example of what I want to do (syntax might not be entirely
correct as this is just an example):
CREATE TABLE ParentA
(