17.10 - ExtractValue Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - DATASET Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1198-171K
Language
English (United States)
DATASET_expression.ExtractValue ('$dot_notation')

Syntax Elements

DATASET_expression
Any expression that evaluates to a DATASET data type.
dot_notation
All dot notation elements are supported, including the following new elements:
  • Recursive descent operator ( .. )
  • Wildcards ( * ) - both in reference to named and indexed items
  • Name/index lists ( [a,b,c] or [0,3,5] )
  • Name/index slices ([c] or [5])