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 |
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. |
APPLY |
OPERATOR |
New, required keyword that replaces previous LOAD syntax in OPERATOR statements. For more information, see 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, see the documentation for that release. |
CONSUMER |
|
Do not use. See “Type Definitions” in the 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, see 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, see 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, see 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, see the documentation for that release. |
PRODUCER |
|
Do not use. See “Type Definitions” in the 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, 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. |
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 the Teradata Parallel Transporter User Guide. |