Splits VARCHAR or CLOB with a CSV format or DATASET STORAGE FORMAT CSV value into a table of DATASET objects. The objects are in CSV storage format with one record per object.
By specifying a DATASET STORAGE FORMAT CSV value as the input parameter, you can convert CSV values containing multiple records into CSV values containing a single record.
Syntax
CSVSplit ( ON ( SELECT csv_text select_stmt_options ) [ RETURNS ( 'data' DATASET STORAGE FORMAT CSV [ CHARACTER SET [ UNICODE | LATIN ] ] ) ] [ USING SCHEMA ( schema ) ] )