Restrictions and Limitations
This section describes the restrictions and limitations when using the DDL operator.
Other Notes
The DDL operator is neither a producer nor a consumer operator.
The DDL operator is a standalone operator. The DDL operator cannot retrieve data records
from the Teradata PT data stream and send them to Teradata. The DDL operator cannot
export rows from Teradata.
The DDL operator uses one session; it does not support multiple sessions.
The DDL operator uses one instance; it does not support multiple instances.
By default, if the DDL operator encounters a Teradata Database error, the DDL operator
treats the error as a fatal error and terminates the job. You can override this behavior
by using the DDL operator's ErrorList attribute.
The DDL operator supports every Teradata SQL statement, except statements that return
data to the operator, such as the SELECT, HELP, and SHOW statements. There are two
exceptions:
The CREATE REPLICATION GROUP statement is supported. The user needs the group id and/or
the token after a replication group is created.
The INSERT...SELECT statement is supported; it returns the total number of rows being
inserted in the table.
A USING clause cannot be specified with any Teradata SQL statements that end data
to the Teradata Database.
All data values used by the SQL statements must be hard-coded into the SQL statements.
The DDL operator restarts at the beginning of the group of SQL statements whose execution
is interrupted by an abnormal termination.
The DDL operator can send SQL statements up to 1MB to Teradata Database.
The DDL operator does not require a Teradata Database load slot.