Get CSV Column Value as an Integer (CSV_INT) UDF

Index

Schema IQUERY

CSV_INT( csv_data, header => 'column header' );

or

CSV_INT( csv_data, ID => relative-column ID );

The CSV Value (CSV_VAL) User Defined Function parses the csv_data passed to it and returns the data for the column identified by the 2nd parameter. The 2nd parameter may be the relative column number or the column heading.

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 content as a numeric value in the form of an integer. It can be CAST to the specific length needed for the application. For example if the Customer number is a 7-position packed field with 0 decimals,  then casting the column might look like the following:

 CAST( iQuery.csv_int(data, 'customer number') as dec(7,0) )

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 returned by the CSV() UDTF. Any other value indicates customization of the interface and may produce undesirable results.

HEADER

When the HEADER version of this UDF is used, the column heading (enclosed in single quotes) is specified to identify the column whose data is to be returned.

ID

When the Relative Column ID version of this UDF is used, ID identifies the relative column number whose data is returned.