Creating a command file for dbload

About this task

To load the audit information into the table that you created:

Procedure

First create an ASCII command file for the dbload utility.

This command file must specify the number of columns and the field delimiter that are used in the data file that onshowaudit created. For a description of command files and their use with dbload, see the HCL OneDB™ Migration Guide.

Include the following information when you create the command file for dbload:

Delimiter: |
Number of columns: 17
Table name: Table you created to receive the data
Data file name: Output file you create (to serve as input for dbload)

The following example uses the FILE statement to create a command file for dbload. The example includes the records_pat data file created in Creating a data file for dbload and the frag_logs table created in Creating a table for audit data.

FILE records_pat DELIMITER '|' 17;
INSERT INTO frag_logs;

What to do next

You now have the tools necessary to load a data file into the table that you created.