Unable to see the data from DB2 Enterprise Stage ..

[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 ..

[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).

[chulett]

Sounds like you may have a metadata mismatch at work here.

[ray.wurlod]

I'm tending more towards unsupported data type. What is the data type of DIM_ACC_PRICE_PLAN_WLESS_3 ?