Null handling

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
DSDEV229
Participant
Posts: 1
Joined: Thu Sep 28, 2017 1:12 am

Null handling

Post by DSDEV229 »

Hi,

I am facing a issue in Ds 11.3 server.
A column coming from source has null value. I am populating with spaces in the transformer using str(' ',len) function.
But when I run the query for checking null it is showing that the column has null values instead of being an empty string.
Any help will be appreciated

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

Post by chulett »

Welcome.

We will probably need more specifics to be able to help but let's start with this... what is your target? A database, Oracle perhaps?
-craig

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