Get CSV Count (CSV_COUNT) UDF

Index

Schema IQUERY

CSV_COUNT( csv_data );

The CSV Count (CSV_COUNT) User Defined Function parses the csv_data passed to it and returns a count of the number of columns detected.

This Function is primarily used with the iQuery CSV() UDTF to parse the CSV content.

Returned Value

INTEGER (in RPG IV INT(10) )

This UDF returns the column count as an integer.

Parameters

CSV_DATA

Expected value: DATA

The column DATA is returned from the iQuery CSV() UDTF. The parameter should be the column named "data" as retured by the CSV() UDTF. Any other value indicates customization of the interface and may produce undesireable results. .