8.9.12 array statement (specification of row data output format for repetition columns)

To unload a table with repetition columns, the array statement specifies the row data output format for the repetition columns.

Criterion
When unloading a table with repetition columns, you can specify the array statement if the -W option is specified to output data to a DAT-format or extended DAT-format file.
Rules
  1. This control statement is ignored if specified for a file that is not in DAT or extended DAT format.
  2. If this control statement is omitted when a table with repetition columns is to be unloaded, the utility assumes ff as the row data output format.
Organization of this subsection
(1) Format

(1) Format

array [elmtype=row-data-output-format]

(a) [elmtype=row-data-output-format]

[Figure]<<ff>>

Specify either ff or vv.

ff
The utility outputs as many data items separated by separator characters as there are maximum number of elements specified for the corresponding column during table definition. For an element that has no data or a null value, the utility outputs only a separator character. If a column value is the null value, the utility outputs separator characters equal to the maximum number of elements.
To use the output data as the database load utility's (pdload's) input file, specify an appropriate null value option to handle the null value.
For details about the data output format when ff is specified, see Section 8.3.3 Format of database load utility input files.
vv
The utility outputs as many data items separated by separator characters as there are elements containing actual data, and the number of output elements at the top of the array data.
If a column value is the null value, the utility outputs 0 as the number of elements.
For details about the data output format when vv is specified, see Section 8.3.3 Format of database load utility input files.