The following figure shows the syntax for operator attribute declarations.
For operator-specific syntax the chapter on that operator in this book.
where:
Syntax Element |
Description |
ARRAY |
Keyword specifying a multivalued, or array, attribute. The ARRAY keyword is optional when character strings are assigned to the array attribute of the operator to be defined or in the APPLY statement. |
CHARS |
Keyword specifying either a fixed- or variable-length character data type. |
INTEGER |
Keyword specifying a four-byte integer numeric data type. |
length |
Length specification for non-numeric data types. The length specification is: |
NULL |
Keyword in the initial values list for an array attribute indicating, that no initial value is being specified for that array element. |
value |
Optional value in an attribute declaration list. The value can be a: |
VARCHAR |
Keyword specifying a variable-length character string data type. |
Purpose
The DEFINE JOB statement defines a Teradata PT job.
All Teradata PT objects must first be defined before they can be referenced in a job definition.