smallint not passing null value

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
times29
Premium Member
Premium Member
Posts: 202
Joined: Mon Sep 22, 2008 3:47 pm

smallint not passing null value

Post by times29 »

Hi,
For datatype smallint i am doing '' in transformer but it is giving me 0 as output how can i pass null instead of 0

Thanks
Top
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: smallint not passing null value

Post by SURA »

INT Data type will treat it as 0.
Top
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:
Contact jwiles

Post by jwiles »

Have you tried the setNull() function? :?
- james wiles


All generalizations are false, including this one - Mark Twain.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

'' != null
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

The output column must be marked as Nullable, otherwise a default value will be substituted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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