When you define a producer operator in a Teradata PT script, required specifications include:
- In the operator definition
- A name for the operator (maximum of 255 characters, with no spaces).
- The operator type.
- The name of the input schema. A deferred schema, specified as SCHEMA *, is not supported for producer operators.
- Declarations for all required attributes.
- In the APPLY statement
- A SELECT . . . FROM clause that names the producer operator