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
numeric datatype ( problem retrieveing data )
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
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.
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.