oracle decimal issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

oracle decimal issue

Post by chvenkat.v »

I am reading data from oracle table, one column having number(9) , but I am importing from oracle table definition thru plug-in it is reading like decimal 9 with 0 scale . job is running fine. But I log file I got three issues.

R_CDR: Column IN_CALLS_CNT floating point decimal is not fully supported; adjusting the scale.
R_CDR: When checking operator: When binding output interface field "IN_CALLS_CNT" to field "IN_CALLS_CNT": Implicit conversion from source type "decimal[38,10]" to result type "int32": Possible range/precision limitation.
S_PRS_DAY: When checking operator: When validating export schema: At field "IN_CALLS_CNT": "null_field" length (0) must match field's fixed width (14)

Please help in those cases. If it is already post please give me the thread.

:(
Top
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

You have a data type issue so just do a search on decimal to integer conversion. Also do a search on null fields.
Top
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

Post by chvenkat.v »

sorry can you pls give thread location

i am unable top search in the form


thnks

venkat
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I got 22 matches doing an Exact search for "Possible range/precision limitation", how are you "unable" to do the same? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”