Changes and Additions - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
Date Description
March 2019

JSON Auto Composition and Shredding

Updated SELECT syntax to add AS JSON option. Added AS JSON, Rules for Using SELECT AS JSON, and Examples: SELECT AS JSON.

Updated INSERT/INSERT … SELECT syntax to add JSON option. Added JSON and Rules for Using the JSON Option.

Function Mapping Variable Substitution

Updated Table Operator.

Function Mapping for Native Functions

Updated Table Operator.

April 2018 Function Mapping

Updated SELECT Table Operator syntax to add the function mapping option.

Updated ON Clause to add ON mapping_name.

Added Output Table Clause.

Added Executing a Function Mapping, Function Mapping and the ON Clause, and Function Mapping and the USING Clause.

Added Examples: Table Operator Function Mapping and Example: SELECT and the Function Mapping Definition.

DBQL Counts DML Rows in Requests

Added Logging Row Counts for DML Statements.

November 2017 CSV Format for DATASET Data Type

Example: Retrieving Data from a DATASET Column in CSV Format