i'm using Db2 Version 8.2.
in a stored procedure i'm assiging a the result of sql query ( with
"WITH UR" ) to a variable as shown below.
SET v_temp =  ( SELECT 1 FROM

I have problem with  DB2 EXPRESS 9.5 C.
I am using it 6 month.
But today i wasn't able to start it. The icon is poping up an it is hanging
about 1 min and the

I have a previous post on the subject that connect takes a long time.
I uninstalled db2 completely.
Installed V9.5
Installed fixpack 1

I have a column with datatype as decimal(31,2) . The data is like
123456.67  , 7634578.99
Is it a way to convert the entire number into character . like
'1232456.67'     .

I am working on a piece of code which analyzes the execution plan of
DB2 SQL statements.
In order to test it, I need a set of statements (and the definitions
of the objects to which the statements refer)which cover as many

I have the following column:
1.4.1    
1.10.1    
1.10.1.2.2

I want to pass a 2-3GB file as a parameter (XML type) to a Stored
procedure. Is that possible? What is the max limit of parameter size
for XML datatype?
Thanks.

I am trying to run the following SQL through the DB2 command line for
version 9.1.0:
alter table SCHEMA.TABLE1
 drop column A;

I need to get the first day of the previous month in a query.
I thought CURRENT DATE and DAYOFMONTH would allow me to da it but it
is noe
WHERE DTXL >= 1st day of previous month

At what point in the range of db2 v8 fixpaks do they start referring
to it generally as db2 v8.2 (vs 8.1)?
Thank you

Am facing a tough situation & the scenario goes like this:
I have scheduled online backup on a db. The online backup is scheduled
to run daily at 12 in the night. Now am to restore the same db in
another server . I have with me the backup image & 50 logs which I

DB2 LUW v8 FP15
Is there any performance overhead if a table is created on data and
index tablespaces with different page sizes ?
What kind of penalty is expected ?

Need help with Knut's function for  summing values in rows
here is my example:
WITH T1 (C1) AS
(VALUES ('1'),

Is there any way by which I can extract the log file form a backup
image.
This backup image was stored with INCLUDE LOGS options
The reason I am hitting this issue is :

One column table:
ALL_SUM
--------------------------------------------------------------------
73237155+73240240+73243230+73249335