16.10 - Syntax Changes - 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 syntax changes affect Teradata PT. Use the following table to understand what syntax was added, removed, and modified since Teradata WB 4.1. Deprecated syntax is still supported in the code to ensure backwards compatibility; however, it will not be documented beyond a certain release.

Syntax Changes for This Release
Syntax Type of Statement Status as of This Release
( ) OPERATOR No longer required for OPERATOR statements, but if used, still functions as in Teradata WB 4.1.

For more information, see the documentation for that release.

ALLOW LATENCY CHECK OPERATOR Obsolete syntax; do not use in OPERATOR statements.
ALLOW PARALLEL MAX INSTANCES OPERATOR Obsolete syntax; do not use in OPERATOR statements.
AmpCheck TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
AppendErrorTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
APPLY OPERATOR New, required keyword that replaces previous LOAD syntax in OPERATOR statements.

For more information, see Object Definitions and the APPLY Statement.

ArraySupport TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ATTRIBUTE | ATTR (attributeDefinition List) JOB No longer required for OPERATOR statements, but if used, still functions as in Teradata WB 4.1.

For more information, see the documentation for that release.

BlockSize TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
Buffer TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
CONSUMER   Do not use. See “Type Definitions” in the Teradata Parallel Transporter User Guide (B035-2445).
Column Definition List OPERATOR

TABLE

TABLE SET

Obsolete syntax; do not use in OPERATOR, TABLE, or TABLE SET statements.
DEFINE DBMS OPERATOR Obsolete syntax; do not use.
DEFINE FILE 'pathName' JOB Obsolete syntax; do not use in JOB statements.
DEFINE LIBRARY PATH 'pathName' JOB Obsolete syntax; do not use in JOB statements.
DEFINE LOGGER LOGGER Obsolete syntax; do not use. Instead, use tlogview.
DEFINE LOG VIEW LOG VIEW Obsolete syntax; do not use. Instead, use tlogview.
DEFINE SCHEMA schema name

'DBS table name'

SCHEMA Obsolete syntax; do not use.
DEFINE SCHEMA schema nameDELIMITED ' DBS table name' SCHEMA Obsolete syntax; do not use.
DEFINE SYSTEM PATH 'path name' JOB Obsolete syntax; do not use in JOB statements.
DeleteTask TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
DISALLOW LATENCY CHECK OPERATOR Obsolete syntax; do not use in OPERATOR statements.
DropErrorTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
DropLogTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
DropWorkTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ErrorTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ErrorTable1 TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ErrorTable2 TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ExportPrivateLogName TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
EXTERNAL NAME 'operatorFileName' OPERATOR No longer required when using predefined operators (for example, TYPE LOAD, TYPE EXPORT, TYPE STREAM).

Required only when using TYPE CONSUMER, TYPE PRODUCER, TYPE FILTER, and TYPE STANDALONE syntax.

FILE 'fileName' TABLE

TABLE SET

Obsolete syntax; do not use in TABLE or TABLE SET statements.
FILTER   Do not use. See “Type Definitions” in the Teradata Parallel Transporter User Guide (B035-2445).
GENERIC DBMS Obsolete syntax; do not use in DBMS statements.
IgnoreMaxDecimalDigits TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
INPUT/OUTPUT SCHEMA OPERATOR The “INPUT” and “OUTPUT” portion of this syntax is ignored by the compiler unless a filter operator contains both INPUT SCHEMA and OUTPUT SCHEMA. In this case, use “INPUT” and “OUTPUT” before “SCHEMA” to differentiate between the two schemas.
INSERT OPERATOR 'operatorName' DBMS

TABLE SET

Obsolete syntax; do not use in DBMS or TABLE SET statements.

If present in an existing script, this syntax is treated as the APPLY OPERATOR ‘operatorName’ syntax.

Instead, use APPLY OPERATOR ‘operatorName’. For more information, see Object Definitions and the APPLY Statement.

INTERFACE PXOPER VERSION ' versionIdentifier' OPERATOR Obsolete syntax; do not use in OPERATOR statements.
LANGUAGE C | C++ OPERATOR Obsolete syntax; do not use in OPERATOR statements.
LIBRARY PATH 'pathName' OPERATOR Obsolete syntax; do not use in OPERATOR statements.
LOAD JOB Obsolete syntax; do not use in JOB statements. Use of this keyword now results in a compiler error.

Instead, use the APPLY statement. For more information, see Object Definitions and the APPLY Statement.

LogTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
LONGVARCHAR   Keyword specifying a fixed-length character string data type of up to 64,000 bytes.

Using this keyword in Teradata PT creates a conflict between the line size limits of the designated input character length and what is output because Teradata PT recognizes double-byte characters while the Teradata Database does not.

Because of this conflict, avoid using this keyword, and use VARCHAR(64000) or VARCHAR(32000) instead.

LONGVARCHARGRAPHIC   Keyword specifying a fixed-length character string data type of up to 32,000 bytes.

Using this keyword in Teradata PT creates a conflict between the line size limits of the designated input character length and what is output because Teradata PT recognizes double-byte characters while the Teradata Database does not.

Because of this conflict, avoid using this keyword, and use VARCHAR(64000) or VARCHAR(32000) instead.

MacroDatabase TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
MaxDecimalDigits TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
MSGCATALOG 'catalogName' OPERATOR Obsolete syntax; do not use in OPERATOR statements when specifying a new predefined operator syntax (for example, TYPE LOAD, TYPE EXPORT, TYPE STREAM).

Use only when specifying a generic operator type (such as TYPE CONSUMER) if the name of the default message catalog changed.

When used, still functions as in Teradata WB 4.1. For more information, see the documentation for that release.

MULITPHASE OPERATOR Obsolete syntax; do not use in OPERATOR statements.
N'…' All character string literals Obsolete syntax; do not use the initial “N” to specify an extended character inside a character string literal.
N"…" All character identifiers Obsolete syntax; do not use the initial “N” to specify an extended character inside a character string literal.
PATH ‘pathName DBMS

TABLE SET

No longer required for DBMS or TABLE SET statements, but if used, still functions as in Teradata WB 4.1.

For more information, see the documentation for that release.

OpenMode TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
Pack TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
PackMaximum TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
PauseAcq TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
Periodicity TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
PRODUCER   Do not use. See “Type Definitions” in the Teradata Parallel Transporter User Guide (B035-2445).
QueueErrorTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
Rate TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
ReplicationOverride TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
Robust TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
RESTART/NOT RESTARTABLE OPERATOR No longer required for OPERATOR statements, but if used, still functions as in Teradata WB 4.1.

For more information, see the documentation for that release.

RowErrFileName Attribute RecordErrorFilename is the new attribute name. For this release, both attribute names are mentioned; however, in future releases, only RecordErrorFilename will be mentioned in the documentation.
SelectStmt TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
SET CHECKPOINT INTERVAL JOB Use the -z option with the tbuild command. See the Teradata Manager User Guide (B035-2445).
SET LATENCY INTERVAL JOB Use the -l option with the tbuild command. See the Teradata Manager User Guide (B035-2445).
STANDALONE   Do not use. See “Type Definitions” in the Teradata Parallel Transporter User Guide (B035-2445).
TenacityHours TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
TenacitySleep TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.
WorkTable TDLOAD LONG_OPTION Obsolete. tdload now follows a standard syntax based on current job variable templates.