Syntax for Attribute Declarations | Teradata Parallel Transporter - Syntax for Attribute Declarations - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

The following figure shows the syntax for operator attribute declarations.

For operator-specific syntax, see the topics on that operator in this document.



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.