The onpload utility

This section describes how to use the onpload utility.

Overview of the onpload utility
After you create the onpload database with the ipload interface, the onpload utility allows you to perform loads and unloads directly from the command line. However, you cannot load or unload binary large objects (BLOBs) or character large objects (CLOBs) to or from multiple files.
The onpload file name size limitations on UNIX
On UNIX, you cannot have a file name size greater than 256 characters.
Start the onpload utility
You can start onpload from the command line or from ipload.
Using the onpload utility
The onpload utility syntax
Set the onpload run mode with the -f option
The -f option lets you set the type of source data and the type of mode. Possible modes are express load, deluxe load, deluxe load without replication, or unload. If used along with the -j option, you can override only a few values from the onpload database.
Modify the size of onpload database parameters
The options that are described in this section let you enter size information that overrides existing parameters in the onpload database.
Override the onpload database values
The options that are described in this topic let you enter size information that overrides existing parameters in the onpload database. You can override only these parameters. You cannot override other options, such as run mode.
Load data into collection data type columns

Parent topic: High-Performance Loader User's Guide

Related concepts