APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle W

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
saidvs
Participant
Posts: 12
Joined: Thu Jul 28, 2005 10:41 am

APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle W

Post by saidvs »

Hi All,

I am using ODBC stage to load into oracle table. The datatype of one field is defined number and the datastage is reading it as decimal (38,10).
when I run the job am getting following error.

APT_CombinedOperatorController,1: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 3.

Any ideas how to overcome it. I am new to datastage so may be a simple question. I tried couple of option n didnt work for me.

Thanks,
Venkat
gsym
Charter Member
Charter Member
Posts: 118
Joined: Thu Feb 02, 2006 3:05 pm

Post by gsym »

first thing is disable operator Combinability to see the full log. is the column in Oracle is represented as just number or of type number(2,4) ?
Post Reply