Looping in DataStage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

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

Post by chulett »

That or "correct" the file you're creating to not include the quote characters.
-craig

"You can never have too many knives" -- Logan Nine Fingers
srai
Participant
Posts: 101
Joined: Wed Feb 09, 2005 10:50 pm

Post by srai »

priyadarshikunal wrote:yes it won't work because you are comparing
"true"=true

here quotes are making the difference

Use one of the codes below

Code: Select all

Trim(Convert('"','',Convert(@FM,'',Execute_Command_3.$CommandOutput)))="true"


Trim(Convert(@FM,'',Execute_Command_3.$CommandOutput),'"',"A"))="true"

Convert(@FM,'',Execute_Command_3.$CommandOutput)='"true"'
And let us know if it works.
Hi Kunal,

The follwoing code is working now-
Convert(@FM,'',Execute_Command_3.$CommandOutput)='"true"'

Thanks a lot for helping me on this.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Then it's time to mark this as Resolved using the button at the top of the page.
-craig

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