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
sdasavi
Premium Member
Premium Member
Posts: 5
Joined: Wed Mar 09, 2011 4:36 am

null handling

Post by sdasavi »

Hi,

I am having a strange problem with nulls. I assigned my field Daily_Date (Char 10) in transformer to CurrentDate(). It is populating with current date in my output.

I deployed it on to client environment, client is complaining that problem is Daily_Date field is showing some null values in some rows.

I don't understand why it is taking null values when we gave CurrentDate() function. Can any body please fix this issue.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not much information to go on... perhaps an update is clearing the field after the fact? Anything special about the 'some rows' that have this issue? :?
-craig

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