15.10 - SingleRowRelation - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

Captures the row returned by a single row relation in the form of an INSERT statement. This statement is executed by TSET at a later time.

CREATE SET TABLE SingleRowRelation (
  QueryID                 INTEGER NOT NULL,
  DatabaseName            VARCHAR(128) CHARACTER SET UNICODE 
                          NOT CASESPECIFIC NOT NULL,
  TableName VARCHAR(128)  CHARACTER SET UNICODE 
                          NOT CASESPECIFIC NOT NULL,
  InsertStatement VARCHAR(10000)   CHARACTER SET UNICODE 
                          NOT CASESPECIFIC)
PRIMARY INDEX ( QueryID );

The following table defines the SingleRowRelation table attributes.

 

Attribute

Description

QueryID

  • Unique identifier for the query to which the recommendation applies.
  • Partial NUPI for the table.
  • DatabaseName

    Name of the containing database for TableName.

    TableName

    Name of the table in which to insert the statement.

    InsertStatement

    Statement to insert into the specified table.