15.10 - QryLogSQLDocV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Query

DBC

 

View Column

Data Type

Format

Source Table.Column

ProcID

DECIMAL(5,0)

NOT NULL

-(5)9 (explicit)

DBQLSqlTbl.ProcID (Composite NUPI)

CollectTimestamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

DBQLSqlTbl.CollectTimeStamp (Composite NUPI)

QueryID

DECIMAL(18,0)

NOT NULL

--Z(17)9

DBQLSqlTbl.QueryID

SqlTextDoc

CLOB

X(64000)

DBQLSqlTbl.SqlTextInfo

Note: SQLTextDoc is a result of combining multiple DBQLSQLTbl.SQLTextInfo rows with the same QueryID.

QryLogSQLDocV provides a view into DBQLSqlTbl that combines multiple rows of SqlTextInfo with the same QueryID into a single SQL text document.

The following SELECT statement retrieves the SQL text information of a query.

.export file=sqldoc.txt;
sel sqltextdoc from QryLogSQLDocV where queryid=307199040105796016;
.export reset;

Result: The following shows a partial result of the query.

SqlTextDoc
-------------------------------------------------------------------------------------
SELECT  *   /* This is a test of query with large query text On the Insert tab, the galleries include items that are designed to coordinate with the overall look of  your document. You can use these galleries to insert  tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts,  or diagrams, they also coordinate with your current document  look. You can easily change the formatting of selected text in  the document text by choosing a look for the selected text  from the Quick Styles gallery on the Home tab. You can also  format text directly by using the other controls on the Home  tab. Most controls offer a choice of using the look from the  current theme or using a format that you specify directly. To  change the overall look of your document, choose new Theme  elements on the Page Layout tab. To change the looks available  in the Quick Style gallery, use the Change Current Quick Style  Set command. Both the Themes gallery and the Quick Styles gallery  provide reset commands so that you can always restore the look of  your document to the original contained in your current template.  On the Insert tab, the galleries include items that are designed  to coordinate with the overall look of your document. You can use  these galleries to insert tables, headers, footers, lists, cover  pages, and other document building blocks. When you create pictures,  charts, or diagrams, they also coordinate with your current document  look. You can easily change the formatting of selected text in the  document text by choosing a look for the selected text from the Quick  Styles gallery on the Home tab. You can also format text directly by  using the other controls on the Home tab. Most controls offer a choice  of using the look from the current theme or using a format that you  specify directly. To change the overall look of your document, choose  new Theme elements on the Page Layout tab. To change the looks available  in the Quick Style gallery, use the Change Current Quick Style Set command.
                       .
                       .
                       .