17.10 - Improving XML 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 XML text rows with the same query ID into one easily readable document, perform a SELECT request on the QryLogXMLDocV view.


sel queryid,xmltextdoc from qrylogxmldocv where queryid=588188772714475132;
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 .