CSVLD

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.