I have a column defined as decimal(4,3).
I get the following error when I try to insert "12.50000000000000"
[IBM][CLI Driver] CLI0111E  Numeric value out of range. SQLSTATE=22003
sqlstate = 22003

DB2 now comes with a stored procedure called SYSPROC.DB2LOAD that can
execute a LOAD, but the IMPORT syntax does not work using the SP. This
seems curious to me since a stored procedure is most likely to be used
from an application program and the LOAD command requires sysadm,

      Is there any way to determine the size of a DB2 database without
using list tablespaces? I am working on db2 udb 8.2 fp12 on LUW
Thanks

How can I check if all bytes in a varchar field is all numeric using
SQL ?
-- peter

If I have a 30gb windows database on 8.2.5, what are ones options in
trying to move such to v9 system while at the same time enabling
automatic storage, automatic maintanence and automatic memory ? I need
to test the existing functionality on Express C v9 before upgrading my

System Specs:  DB2 UDB 7 on z/OS 390
The Problem: I want to execute a DDL file in my allocated Data Set. But
the only thing that happens, when I press Enter is, that SPUFI jumps
back to the DB2 Utilities Menu.

My Problem is:
My SQL Statement Structure:
SELECT TABLEA.FIELDA,
             TABLEA.FIELDB,

I'd like our daily quality & policy testing framework to also test if
our databases are activated.  However, I haven't found a good way to do
this yet - every approach has issues:
1.  get snapshot for database on [db] - I can't tell if the database is

I am trying to understand why following simple query is running very
slow (33 hours)
select  ROW_ID
        , a.CREATED

Hello again.  I previously inquired about updating 1000 records at a
time in a script (not using cursors).  Now I have to take it one step
further.  I want to update records from two different records at once.
I have half of the step done but cant seem to fit the seconds part in

Consider
create table t(
.
.

I need help tunning the following query
Table scan on table Fact.sale_Current_2005
1.select key,sale_amt,dt,c4,c5,c6,c7 from Fact.sale_Current_view
  where dt>= (select  (min(Dt)) from Stage.sale_Current)

I am trying to create my first stored procedure using ISeries
Navigator. I receive the following error.
Token SQL was not valid. Valid tokens: C CL COBOL COBOLLE FORTRAN PLI
RPG RPGLE JAVA.

  I can't think of a reason one might need to use the quiesce
tablespace for tables command.  Can anyone come up with a scenario when
it might be beneficial or even mandatory to use the command?
Thanks.

I am working on RHEL. I am using DB2 UDB Enterprise Edition v 8.2. Now
I am having a query. Is there any other method apart from 'db2ckbkp',
'list history backup all for database <dbname>' to check whether the
backup is performed correctly or not.