numeric datatype ( problem retrieveing data )

abhay10 · Post by **abhay10** » Thu Jan 24, 2008 2:43 am

hi All

i am comming across a strange problem where where i am not able to retrieve the data properly

like the data type of the field is numeric(15)
and the value coming In is 2474756317

the data is getting retrieved properly for server jobs but in the parallel jobs there is inconsistency in the data

for parallel its retrieving 2147483647
plz do help me whats the problem behind this

ray.wurlod · Post by **ray.wurlod** » Thu Jan 24, 2008 7:29 am

The first problem is we have no idea what stage type you are using in each job, nor what the property settings of that stage type might be.

abhay10 · Post by **abhay10** » Thu Jan 24, 2008 10:05 pm

i am using the ODBC stage and trying to retrieve the data that is srored in DB2
The datatye of the column is numeric(15) in datastage
the server job is also using the same stage and same datatype but retrieveing the data properly but the parallel job is not able to retrieve the data
which has the data greater than 31bits
can u tell me y i am not able to retrieve the data greater than 31bits in parallel job with numeric datatype

Teej · Post by **Teej** » Thu Jan 24, 2008 10:23 pm

Can you paste the error message you say you are getting here?

Or if you are getting the actual values without warning, what is the output value you are getting instead of what you are expecting?

abhay10 · Post by **abhay10** » Thu Jan 24, 2008 11:22 pm

actual value is
2474756317

when view data is performed
the value retrieved is
2147483647

and no warning is issued

Teej · Post by **Teej** » Thu Jan 24, 2008 11:42 pm

That is very unusual.

What version of DataStage are you using, exactly?

abhay10 · Post by **abhay10** » Fri Jan 25, 2008 12:05 am

i am using the version 7.5.1

abhay10 · Post by **abhay10** » Mon Jan 28, 2008 1:10 am

My Parallel job is able to read data from DB2 in (windows2000) and giving correct results , but the only problem is reading from DB2 in (AS400).
Is there any environment related to parallel job that has to be set, so that the job can read data more than 32 bit.

I even tried changing the data type of the field to varchar in Datastage. but still the same problem.