Oracle Enterprise Stage problem

[kriss]

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

[donny]

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

[fmcmullan]

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.

[kriss]

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

[ray.wurlod]

Please mark the thread as Resolved.