Changes to This Book
The following changes were made to this book in support of the current release. Changes since the last publication are marked with change bars. For a complete list of changes to the product Teradata Tools and Utilities Release Definition associated with this release.
Some new functions and features for this release of Teradata PT might not be documented in this manual. New features and functions are also documented in the other manuals listed in “Additional Information” on page 8.
|
Date and Release |
Description |
|
March 2014 |
Teradata PT is supported on OS X. The DataConnector operator supports the AppendDelimiter attribute. Limitations on a VSAM file between checkpoints (DataConnector operator). Limitations on KSDS/ESDS alternate indexes (DataConnector operator). Defined syntax for specifying the z/OS data set directly (DataConnector operator). Clarified how to use the MultiLoad INMOD Adapter operator as a filter operator. In order that missing update rows are not inserted into the error table, use the IGNORE MISSING UPDATE ROWS DML option when you use the INSERT FOR ROWS or INSERT FOR MISSING UPDATE option. The Update operator supports LOB loading using the Extended MultiLoad Protocol. Revised lists of restricted words (appendix C). LANGORT has been removed from the list. SET CHECKPOINT INTERVAL and SET LATENCY INTERVAL are deprecated. LogTable is an optional VARCHAR attribute for the Load, Stream, and Update operators. DataConnector operator supports the MaxColumnCountErrs attribute. Minor errors corrected. Teradata PT ODBC operator does not support TD Wallet. Teradata PT supports network-attached and mainframe-attached character sets. See “Teradata PT-Supported Character Sets” on page 397. An XML column cannot be used in any predicate evaluation specified in the WHERE clause or in either type of CASE expression of an SQL request NUMBER is a Teradata PT restricted word. The ODBC Operator does not support TD Wallet. Deprecated SET CHECKPOINT INTERVAL and SET LATENCY INTERVAL syntax. Documented list of restrictions for special protocols. TPT Infrastructure support for JSON integration. Documented TPT Inserter and Selector support for JSON integration. Changed “CASE statement” to “CASE expression.” Added Temporal table to list of restrictions for MultiLoad protocol. |
|
|
Documented new utility command, twbertbl. Documented User-Defined Functions and External Stored Procedures. Documented support of parallel read of a single file with instance synchronization. Removed restrictions on delimited data processing. Removed reference to MLOADX. Implement Hadoop Support in TPT. Improve documentation on Zip/Gzip feature. Update all TPT 15.0 GCA externally visible copyright years to "2014" TPT Data Connector support for SCHINESE936_6R0 character set. Document a listing of restrictions for the OS Command Operator. Add documentation about NUMBER datatype limitations when used in predicate evaluation expressions. Certify Simba ODBC driver for oracle against TPT ODBC operator. Change all occurrences of "load task" and "loader task" to "load slot". |