Function string size limits for oreplace and otranslate

Database
N/A

Function string size limits for oreplace and otranslate

Hi,

 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)

Churned in Columbus