Null Handling

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

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

Post by chulett »

No such thing as NULL values from a flat file, hence your issue. Rather than use the IsNull() function, check for an empty string instead:

If a.SALARY="" then 999 else a.SALARY
-craig

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

Return to “General”