Figure 5-5 shows data loading into a table for which indexes are defined.
Figure 5-5 Loading data to a table with indexes defined
The following explains the options specified with pdload:
For the omitted options, the system assumes the following values:
The source statement specifies the input data file named /usr/inputfile.
The index statement specifies the index information file named /usr/idxfile.
This example specifies the input data file in the DAT format.
If the order of columns does not match between the input data file and the table, you can specify a column structure information file to define the correspondence of columns between input data and table.
You can use the column structure information files only when the input data file is in DAT, fixed-size data, or pdrorg-generated binary format (non-FIX).
The following shows an example: