Removing Padded Spaces from SQL Statements in Log ...
We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
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?