APT_CombinedOperatorController,0: Fatal Error: 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
dodda
Premium Member
Premium Member
Posts: 244
Joined: Tue May 29, 2007 11:31 am

Post by dodda »

Any helpon my issue
Top
BillB
Premium Member
Premium Member
Posts: 48
Joined: Tue Nov 13, 2007 6:44 pm

Post by BillB »

I'm surprised that no-one has recommended Search to you yet :)

Try - if Trim(NullToEmpty(Out_IRI_UPC.PC_ID))='' then "N/A" else Out_IRI_UPC.PC_ID
Top
dodda
Premium Member
Premium Member
Posts: 244
Joined: Tue May 29, 2007 11:31 am

Post by dodda »

Hi All,

I used the below code in the transformer. It is working fine.

If trim(nulltovalue(Out_IRI_UPC.PC_ID, ' '))='' then "N/A" else Out_IRI_UPC.PC_ID
Top
Post Reply

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