17.10 - UserRemarks - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

Stores user comments about captured plans written using the Teradata System Emulation Tool utility.

UserRemarks Table Definition

The following CREATE TABLE request defines the UserRemarks table:

   CREATE TABLE UserRemarks(
     QueryID     INTEGER,
     StepID      INTEGER,
     WorkloadID  INTEGER,
     RowType     CHARACTER(1) CHARACTER SET LATIN NOT CASESPECIFIC
                 NOT NULL,
     SeqNumber   INTEGER NOT NULL,
     UpdTime     TIMESTAMP(6) NOT NULL,
     UserName    VARCHAR128 CHARACTER SET UNICODE
                 NOT CASESPECIFIC NOT NULL,
     Remarks     VARCHAR31000 CHARACTER SET UNICODE
                 NOT CASESPECIFIC NOT NULL)
   PRIMARY INDEX (QueryID, UserName);

Attribute Definitions for UserRemarks

The following table defines the UserRemarks table attributes:

Attribute Definition
QueryID The ID of the query about which remarks are being saved.

Partial NUPI for the table.

StepID The ID of the step about which remarks are being saved.
WorkloadID The ID of the workload to which the query belongs.
RowType Specifies the utility that collected the remarks and whether they were saved or generated.
  • If T, the comments were generated automatically by the Teradata System Emulation Tool utility during import.
SeqNumber A system-generated number (1 for the first row, 2 for second, and so on) to indicate the sequential order of remarks.
UpdTime The timestamp when the remark was last updated.
UserName The system user name of the user who last updated the row.

Partial NUPI for the table.

Remarks The remarks of the step or query.

Related Information

For more information about the Teradata System Emulation Tool utility, see Teradata® System Emulation Tool User Guide, B035-2492.