The following specifications are required to define the SQL Selector operator in a Teradata PT job script.
| Specification | Description |
|---|---|
| TYPE | Operator type. Always SELECTOR for the SQL Selector operator. |
| UserName | Operator attribute providing the name of the user under which the Teradata SQL SELECT statement is submitted. |
| UserPassword | Operator attribute providing the password associated with the user name. |
| SelectStmt | Operator attribute providing the Teradata SQL SELECT statement. The SQL Selector operator supports one or more SELECT statements. |