DataStage: Handle quotes in a parameter
http://www.dsxchange.com/viewtopic.php?p=280909&sid=7f01f681cfdf54b57c1dc7c1b9b8670b
My job was being called from a sequence. In the parameter value expression I used the following:
“\'”:Ereplace (pParam, “,”, “\’,\'”):”\'”
It looks a bit confusing because of the mixture of double and single quotes, but essentially it is replacing each , <comma> with ‘,’ <single quote><comma><single quote> and prefixing/suffixing with ‘ <single quote>
Reference in called job as per: column in (#pParam#)