IBM® Informix® 12.10

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.

See Override the onpload database values.


Setting the Run Mode

               .-l--+---+-.          
               |    '-c-' |          
|-- -f--+---+--+----------+--+---+------------------------------|
        +-d-+  '-u--------'  +-n-+   
        +-p-+                +-q-+   
        '-a-'                +-v-+   
                             +-M-+   
                             '-N-'

Element	Purpose	Key considerations
M	Displays the program module or line number in messages.	This flag is available only from the command line. This flag is used for debugging.
N	Allows deluxe mode load without replication	This flag works only if the -j `job` argument, which specifies a session table job to run, is left blank.
a	Treats data source as a device-array.	The definition of the device array is extracted from the onpload database. To use ipload, see Device arrays.
c	Sets mode to deluxe mode.	If this flag is not set, onpload uses express mode. To use ipload, see HPL modes.
d	Treats data source as a device (tape or file).	To set this option by using ipload, see Device arrays.
l	Loads data into database.	This is the default flag, as opposed to u, which unloads data from the database. To use ipload, see Components of the load job.
n	Specifies that onpload does not need to perform data conversion.	The target table for the load must have the same schema as the table from which the data is extracted. If onpload generated the input data file as an IBM® Informix® format data file, you do not need to perform data conversion when you reload data. To use ipload, see Using the No Conversion Job option.
p	Treats data source as a program to run and reads interface to the program by way of a pipe (on UNIX only).	To use ipload, see Device arrays.
q	Tells onpload not to generate status messages while a job is running.	None.
u	Unloads data from database.	If this flag is not set, onpload loads data into the database. To use ipload, see Components of the unload job.
v	Tells onpload not to generate violations records.	This flag is available only from the command line, and is not supported with deluxe mode load.

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.

Release date: March 2013