Page 1 of 1

Unable to see the data from DB2 Enterprise Stage ..

Posted: Sat Aug 30, 2008 2:46 am
by Sourav
Hi ,

I have found below mentioned error while i was trying to connect to the database through DB2 Enterprise stage in the parallel jobs .


Error Details are given below :
===================

##E TNDB 000000 13:56:06(012) <DIM_ACC_PRICE_PLAN_WLESS_3> Error Idx = 1;
DB2 Driver Embedded SQL message: SQL0304N A value cannot be assigned to a host variable because the value is
not within the range of the host variable's data type. SQLSTATE=22003
;
sqlcode = -304;
sqlstate = 22003
##E TNDB 000000 13:56:06(013) <DIM_ACC_PRICE_PLAN_WLESS_3> Failed to connect to database.

Pls help me ..

Posted: Sat Aug 30, 2008 4:27 am
by ray.wurlod
I think you need to involve your DBA on this one, to enable tracing to find out which parameter might be causing such a warning to be thrown. There may be some assistance in the errors manual for DB2, if you lookup SQL0304N (or error code -304, which is the same thing).

Posted: Sat Aug 30, 2008 7:55 am
by chulett
:? Sounds like you may have a metadata mismatch at work here.

Posted: Sat Aug 30, 2008 4:16 pm
by ray.wurlod
I'm tending more towards unsupported data type. What is the data type of DIM_ACC_PRICE_PLAN_WLESS_3 ?