16.20 - CSVLD - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

Purpose

CSVLD (Comma-Separated Value Data Loading) takes in a comma-separated string produced through the CSV table function, parses the string, and returns VARCHAR columns.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
data_string_value
A string argument.
delim_string_value
A character expression.
A comma (,) is the default delimiter character.
quote_string_value
A character expression.
The quotation mark character, for example “”, is used to indicate that the delimiter character is a part of the value, and not a field separator.
The value inside the quote_string_value is returned as output exclusive of the quote_string_value given.