XMLQCD - Analytics Database - Teradata Vantage

Function of XMLQCD

Captures the XML QCD output from an INSERT EXPLAIN or BEGIN QUERY CAPTURE request submitted with the IN XML option.

XMLQCD Table Definition

The following CREATE TABLE request defines the XMLQCD table:

CREATE MULTISET TABLE qcd.XMLQCD, NO FALLBACK, NO BEFORE JOURNAL,
NO AFTER JOURNAL, CHECKSUM = DEFAULT (
 ID               INTEGER NOT NULL,
 Kind             CHARACTER(1) NOT NULL CHARACTER SET LATIN
                  NOT CASESPECIFIC,
 Seq              INTEGER NOT NULL,
 Length           INTEGER NOT NULL,
 Text             VARCHAR(31000) NOT NULL CHARACTER SET UNICODE
                  NOT CASESPECIFIC,
 UDB_Name         VARCHAR(128) CHARACTER SET UNICODE
                  NOT CASESPECIFIC NOT NULL,
 CaptureTimeStamp TIMESTAMP(0) NOT NULL,
 SessionID        INTEGER FORMAT ‘--,---,---,--9’ NOT NULL,
 WorkloadName     VARCHAR(128) CHARACTER SET UNICODE UPPERCASE
                  NOT CASESPECIFIC NOT NULL,
 XMLDocType       INTEGER FORMAT ‘--,---,---,--9’)
UNIQUE PRIMARY INDEX (ID, Kind, Seq);

Attribute Definitions for XMLQCD

The following table defines the XMLQCD table attributes.