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 the remarks were saved or generated.
|
| 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.