Removing Padded Spaces from SQL Statements in Log Data
I am trying to export sql statements from the TD log table data on TD 15. The sql_text column is 31,000 characters and it's padded. I want to extract the sql statement data into a simple text file using the TD extract utility - but I don't want the data padded. NOTE: The padding occurs even in the middle of the sql statement, it's not just at the beginning or end.
Has anyone extracted the sql statement from the log table - and done it without the padding?