Character substitution using MODIFY stage.
Posted: Tue Aug 13, 2019 1:10 pm
We are using RCP to extract data from table and write to a sequential file. Double-quote is present in some of the data column, which needs to be escaped (i.e. replaced with two double-quotes).
If transformer stage is used (with RCP) for replacing double-quotes, then column position in output file is rearranged! Is it possible to implement ereplace in Modify stage?
On a related note, about a decade ago
Ray had shared examples of Modify stage constructs at http://home.iprimus.com.au/raywurlod/Da ... ctions.pdf. Unfortunately, this link is stale now. Can someone please share copy of this document.
If transformer stage is used (with RCP) for replacing double-quotes, then column position in output file is rearranged! Is it possible to implement ereplace in Modify stage?
On a related note, about a decade ago
Ray had shared examples of Modify stage constructs at http://home.iprimus.com.au/raywurlod/Da ... ctions.pdf. Unfortunately, this link is stale now. Can someone please share copy of this document.