Handle_Null Generating Fatal Error

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
Ronetlds
Participant
Posts: 28
Joined: Thu Mar 30, 2006 12:48 pm

Post by Ronetlds »

CV Totals In (SUM_CASH_VAL nullable is "Y") ->

Modify (handle nulls here) -> (SUM_CASH_VAL nullable is "N") ->

out rec
gagan8877
Premium Member
Premium Member
Posts: 77
Joined: Mon Jun 19, 2006 1:30 pm

Pls explain

Post by gagan8877 »

Yes, Thats how its setup. I am not sure what u r trying to say, pls explain.
Gary
"A journey of a thousand miles, begins with one step"
Ronetlds
Participant
Posts: 28
Joined: Thu Mar 30, 2006 12:48 pm

Post by Ronetlds »

Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.
gagan8877
Premium Member
Premium Member
Posts: 77
Joined: Mon Jun 19, 2006 1:30 pm

Handle_Null Syntax

Post by gagan8877 »

Ronetlds wrote:Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.
Thanks a lot Dude. That resolved it.
Gary
"A journey of a thousand miles, begins with one step"
Post Reply