CSVSplit ( ON
( SELECT csv_text select_stmt_options )
[ RETURNS (
'data' DATASET STORAGE FORMAT CSV
[ CHARACTER SET [ UNICODE | LATIN ] ]
)
]
[ USING SCHEMA ( schema ) ]
)
Syntax Elements
- csv_text
- Any text that evaluates to character data in the CSV format.
- select_stmt_options
- The allowable or necessary options in Vantage for a SQL SELECT statement.
- RETURNS
- Specifies the output data type or length. The default is to return a maximum length CSV, so omit RETURNS for this output.
- DATASET STORAGE FORMAT CSV
- Returns data that uses the CSV storage format. The default returns a CSV of maximum length, so the RETURNS clause may be omitted if this is the desired output.
- CHARACTER SET
- The character set specified by DATASET STORAGE FORMAT CSV. The options include UNICODE or LATIN.
- SCHEMA
- Specify SCHEMA to explicitly define the published data structure. Use the clause with a character string representing an ad-hoc schema specification; any other value results in an error. If an ad hoc schema is specified, the structure must conform to the CSV format rules. If the clause is not specified, the input CSV data is assumed to conform to the defaults.