16.10 - Syntax for Attribute Declarations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

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

CHAR

Keyword specifying either a fixed- or variable-length character data type.
INTEGER

INT

Keyword specifying a four-byte integer numeric data type.
length Length specification for non-numeric data types. The length specification is:
  • Required for column definition of variable-length data types.
  • Optional for attribute declaration of variable-length data types.
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:
  • Character string
  • Integer
  • Job variable reference, for example @job_attr_name.
VARCHAR

VARYING

Keyword specifying a variable-length character string data type.