We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, February 11, 2014

DataStage Error : Loop final value not numeric - cannot execute it


Generally, you will face this Error when you are getting values from a file or Unix commands and using that value in Loop ( either transformer loop or sequencer loop ).


Solution : 

 

The result of the command includes a newline character which causes this issue. Before using this please remove the newline '\n' character from the value. 

You can do it by using 'tr' command, i.e.-

echo $a | tr -d "\n"


No comments :

Post a Comment