SingleRowRelation - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Function of SingleRowRelation

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

SingleRowRelation Table Definition

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 );

Attribute Definitions for SingleRowRelation

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.