Hi Group ,
Am new to DB2 .  I am facing some problem with date arithmatics :
The current date as today  is from the below sql :
db2 "select current date from sysibm.sysdummy1"

Inserting number 99999.99 into a FLOAT 17 16 field results in
9.99999900....5E+004 being inserted into the base.
What is confusing me is the digit 5 that appears at the end of the
number. Where does it come from and what does it mean? I have tried to

In our veritas netbackup for DB2 on AIX, the backup could be done
successfully and the backup image would be listed using bplist on the
AIX client.
I have made several backup image, but only one image would be restored

Is it possible to have two connects in the same rexx script to
different DB's?
I have to get data form on DB (with specifics selects and filter out
some values with RExx) and save the results into another DB?

Env: DB2 V8 + FP13
Question: How to select the data which have space end of string one or
more, like 'AB ','AB   '
Case:

i took  db2 fundamentals 730 exam on  Dec-06 in one of the prometric
centers, and succesfully passed also.
but the problem is i didn't got my certificate yet, usually how long
it takes to ship the certificate ?

I'm attempting to use LOAD as an on-the-job training task. It's my
first work with DB2, but I've worked with MySQL, so I didn't expect it
to be too different.
I have found some clues about what's not working, but I'm stuck as to

I am a non-programmer. A programming house is converting my access
database to DB2 to be run on an AS400. The programmers tell me that
DB2 has no way to prevent the user's DB admin from gaining access to
the SQL statements in code. (I find this hard to believe in that I am

I am trying to create a stored procedure using the DB2 Connect
Development Center.  I am able to create the project, connect to the
remote database on the mainframe and create the stored procedure.
However, when I build I get the following message:

All,
I'm new to the concept of  automatic storage...
I'm looking at the database setup by a vendor. I see few tablespaces
showing up with automatic storage - Yes.

SOFTWARE TESTING TRAINING AND OTHER SERVICES FROM IT INDUSTRY PIONEERS
Contact for more details
MURALI  @ 99005 21091
sHARATH @ 99860 73544

Hi Group,
It's really confusing to calculate the size of the DB2 UDB database in
versions lesser than 8.2.
In Version 8.2 if we run the query db2 "call get_dbsize_info(?,?,?,0)"

Using DB2:-
Product identifier           SQL08027
Level identifier             03080106
Level                        DB2 v8.1.14.292

Can somebody explain me what does it mean this error in the
dbdiag.log. It's a DB2 v7. I have this error every 10 minutes.
==============================================================
2007-04-18-20.40.36.972459   Instance:db2inst1   Node:000

Trying to declare a simple handler for SQLEXCEPTION.
Simple stored proc (UDB 8.2)
----
CREATE PROCEDURE TFBUDB.SMACF_SM_DI (IN POL_NBR CHAR(10)