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 |
|
| 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. |