Appendix B Deprecated Syntax - Parallel Transporter

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 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.

APPLY

OPERATOR

New, required keyword that replaces previous LOAD syntax in OPERATOR statements.

For more information Chapter 2: “Object Definitions and the APPLY Statement.”

ATTRIBUTE | ATTR (attributeDefinition List)

JOB

No longer required for JOB statements, but if used, still functions as in Teradata WB 4.1.

For more information the documentation for that release.

CONSUMER

Do not use. See “Type Definitions” in Teradata Parallel Transporter User Guide.

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 name DELIMITED 'DBS table name'

SCHEMA

Obsolete syntax; do not use.

DEFINE SYSTEM PATH ‘pathName’

JOB

Obsolete syntax; do not use in JOB statements.

DEFINE TABLE

OPERATOR

Obsolete syntax; do not use.

DEFINE TABLE SET

OPERATOR

Obsolete syntax; do not use.

DEFINE WORKING DIRECTORY ‘pathName’

JOB

Obsolete syntax; do not use in JOB statements.

DISALLOW LATENCY CHECK

OPERATOR

Obsolete syntax; do not use in OPERATOR statements.

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 Teradata Parallel Transporter User Guide.

GENERIC

DBMS

Obsolete syntax; do not use in DBMS statements.

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 Chapter 2: “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 Chapter 2: “Object Definitions and the APPLY Statement.”

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.

LONGVARGRAPHIC

Keyword specifying a fixed-length graphic data type of up to 32 000 graphic characters.

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.

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 the documentation for that release.

MULTIPHASE

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 the documentation for that release.

PRODUCER

Do not use. See “Type Definitions” in Teradata Parallel Transporter User Guide.

RESTARTABLE/NOT RESTARTABLE

OPERATOR

No longer required for OPERATOR statements, but if used, still functions as in Teradata WB 4.1.

For more information the documentation for that release.

SET CHECKPOINT INTERVAL

JOB

Use the -z option with the tbuild command. See the Teradata Manager User Guide.

SET LATENCY INTERVAL

JOB

Use the -l option with the tbuild command. See the Teradata Manager User Guide.

STANDALONE

Do not use. See “Type Definitions” in Teradata Parallel Transporter User Guide.