Function string size limits for oreplace and otranslate
I'm working on extracting the 31,000 character sql_text from the log data. To extract the data, I need to remove the newline characters (x'0A') before so that each row in the log table is one line in a flat file.
We've previously run into issues with the replace and translate function on the size of the strings these functions can handle. I have seen NUMEROUS other posts online where Teradata users run into errors trying to use these functions on large strings.
Does anybody know - what is the max string size these functions can handle?
(Please don't tell me to use unix scripts, or perl or something - I need to use TD to manipulate these strings)