Syntax for Attribute Declarations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

    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.