My requirement is that, i have to get the max value of a column from a table using the Oracle Enterprise stage.
That query is :
SELECT NVL(max(SEQ_NBR),1) MaxNo FROM PAYMENT
When i executed the job it is working fine. But giving the warning like the following.
Oracle_Enterprise_68: When checking operator: When binding output interface field "MaxNo" to field "MaxNo": Implicit conversion from source type "decimal[38,10]" to result type "int64": Possible range/precision limitation.
Actually in database SEQ_NBR column datatype is NUMBER(15)
In datastage i am using Bigint(15)
Can any one advice why this error is coming.
Thanks in advance.
Thanks,
kriss
Oracle Enterprise Stage problem
Moderators: chulett, rschirm, roy
Re: Oracle Enterprise Stage problem
Hi
just double check the datatype again in table wheteher its decimal(38.0)
else change in datastage job the dataatype to decimal(38,0)
you can avoid that error
thx
donny
just double check the datatype again in table wheteher its decimal(38.0)
else change in datastage job the dataatype to decimal(38,0)
you can avoid that error
thx
donny
Whenever you perform any sort of function (like NVL or MAX) in a SELECT statement, Oracle does not seem to preserve the datatype of the underlying column. Or, at least it doesn't seem to correctly communicate it back to DataStage as part of the metadata sent with the query results.
As mentioned, just set the datatype on the result column in DataStage to decimal(38.10) then convert to the desired datatype downstream in your job.
As mentioned, just set the datatype on the result column in DataStage to decimal(38.10) then convert to the desired datatype downstream in your job.
fmcmullan wrote:Whenever you perform any sort of function (like NVL or MAX) in a SELECT statement, Oracle does not seem to preserve the datatype of the underlying column. Or, at least it doesn't seem to correctly communicate it back to DataStage as part of the metadata sent with the query results.
As mentioned, just set the datatype on the result column in DataStage to decimal(38.10) then convert to the desired datatype downstream in your job.
Thanks its worked.....
Kriss
kriss
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: