Nullable Value transforms to 0 while writing to OracleDB

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
mpunktmayer
Participant
Posts: 10
Joined: Wed Apr 29, 2015 12:48 am

Nullable Value transforms to 0 while writing to OracleDB

Post by mpunktmayer »

There is a job

ALotOfTransformation -> finale_Transfomer -> Oracle DB

In the final_Transformer there is a Field defined as Decimal 25,2 nullable. The row with the problem has the value NULL. When I write the field to the database, the NULL value suddenly becomes 0.

The field in the Database is configured as NUMBER(25,2) nullable.

I tested it with the following Job setup:
ALotOfTransformation -> finale_Transfomer -> PEEK
... and the Peek shows me the NULL Value.

Any Ideas why the Oracle Stage Changes NULL to 0 ?!
thompsonp
Premium Member
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

Post by thompsonp »

How are you checking the value in the Database?

What happens if you insert a null value into that table / column from outside DataStage?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Any chance this is a bulk load?
-craig

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