Introduction

In Teradata Database Release 14.10 object names have been lengthened from 30 bytes of a Latin or KANJISJIS character set to 128 Unicode characters. This capability supports a richer set of characters to compose object names. While using a session character set that may contain limitations due to the supported set of characters, Unicode delimited identifiers are supported in all SQL text statements. Please see the SQL Data Types and Literals manual for information on Unicode delimited identifiers.

Support for a new dynamically allocated parameter type (TD_ANYTYPE) is available in Teradata Database 14.0. This Teradata enhancement supports input and result parameter types that may be defined dynamically at execution time. The use of the TD_ANYTYPE data type definition in functions and external stored procedures will be discussed.

Some of the benefits of TD_ANYTYPE parameters include: