If Condition...
Posted: Fri Aug 01, 2003 12:02 am
How to do in DataStage the following Condition
If (DSLink1.EmpJob < 'VS_PRES') Then
DSLink3.EmpJob = "CEO" *Passing Value to Target column
V_One = "T" *Setting the variable
Else
DSLink3.EmpJob
End
Here V_One is Stage variable or parameter. That we will use in another Target Stage. And the default value of V_One = "F". In the Other Target Stage the condition is
If (V_One = "T") Then
DS_JobName
Else
V_One = "F"
End
Please note that in the else part we dont want to pass "true" value to the target column and only we want to re-set the variable.
Can any1 give suggestions how to do this? or How to process?
Thanx and Regards,
Ravi
If (DSLink1.EmpJob < 'VS_PRES') Then
DSLink3.EmpJob = "CEO" *Passing Value to Target column
V_One = "T" *Setting the variable
Else
DSLink3.EmpJob
End
Here V_One is Stage variable or parameter. That we will use in another Target Stage. And the default value of V_One = "F". In the Other Target Stage the condition is
If (V_One = "T") Then
DS_JobName
Else
V_One = "F"
End
Please note that in the else part we dont want to pass "true" value to the target column and only we want to re-set the variable.
Can any1 give suggestions how to do this? or How to process?
Thanx and Regards,
Ravi