stage variable help

[sush26283]

Hi am pretty new with datastage and working on parallel extender 7x..
am having problem with setting up the stage variable and beeded some help with the code.

i need to select the first position of abc_def= C from the incoming link and i used the following function Left("C",1)link.abc_def but it says SYNTAX ERROR

also i need to set the stage variable for count of records where abc_def = I and xyz_mno = EM

can anyone please help me with it..

[anbu]

Use this to check whether first character is C

Code: Select all

link.abc_def[1,1] = 'C'

Use aggregator to count on abc_def and xyz_mno

If you can give sample input and expected output, we can help you better

[sush26283]

Thanks Anbu

[chulett]

If you want to see the correct syntax for your previous effort:

Code: Select all

Left(link.abc_def,1) = 'C'

That could be done as part of an if-then-else construct or left as-is to set a boolean value in a stage variable or constraint.