How to Valid an equal Operator

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
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

How to Valid an equal Operator

Post by Hope »

A column has operators as values such as >,<=. In the stage variable I am comparing the values of the column.
Here is the Syntax
If link.InputColumn= "=" Then lnk2_xfm_cfp_dw_in.EFFECTIVE_DATE = jp_EIS_IOO_CASH_FLOW_PROJECTION_DW_Control_Date Else If link.InputColumn= "<" Then lnk2_xfm_cfp_dw_in.EFFECTIVE_DATE < jp_EIS_IOO_CASH_FLOW_PROJECTION_DW_Control_Date Else If link.InputColumn= ">" Then lnk2_xfm_cfp_dw_in.EFFECTIVE_DATE > jp_EIS_IOO_CASH_FLOW_PROJECTION_DW_Control_Date Else 1=2

I get the following warning if the Input Column Value is '='. I dont get any warnings if the operator is '>' or '<'.

Invalid argvalue `link.InputColumn==', missing =.

Pleas advice.

Thanks
Post Reply