17.10 - Improving SQL Text Readability - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

To combine multiple SQLTextDoc rows with the same query ID into one easily readable document, perform a SELECT request on the QryLogSQLDocV view.


sel queryid,sqltextdoc from qrylogsqldocv where queryid=977188741514475132;
Export the result set to a file. On the monitor, some of the lines may truncate.

The memory allocated for the input is 32 MB. To see the memory setting, use the following:

cufconfig -o | grep MallocLimit

To add more memory, adjust the MallocLimit setting using cufconfig. For more information, see Teradata Vantage™ - Database Utilities , B035-1102 .