Create no-conversion jobs by using a quick command
When you create a job by using a quick command, the onpladm utility creates all High-Performance Loader (HPL) objects associated with that job.
The following diagram illustrates the syntax to create a no-conversion job.
Creating a no-conversion job >>-onpladm create job -job--+---------------+-- -n--------------> '- -p--project -' >-- -d--device -- -D--database-- -t--table----------------------> .----------------------------------------------------------------. V | >----+------------------------------------------------------------+-+->< '-+-------------+--+-------------+--| Setting the run mode |-' '- -S--server-' '- -T--target-'
Element | Purpose | Key considerations |
---|---|---|
-d device | Sets the name of device, such as a file, device array, tape, or pipe | No default value. |
-D database | Name of the target database that contains the information to be loaded or unloaded | No default value. |
job | Names a load or unload job from the onpload database | None |
-n | Sets no-conversion express job | None |
-p project | Identifies the project where the format and map are stored | The default is the project created when the onpload database is built. |
-S server | Sets the onpload database server | The default is the value of the INFORMIXSERVER environment variable. |
-t table | Name of the table to be loaded or unloaded | None |
-T target | Name of the target server to which the data will download | The default is the value of the INFORMIXSERVER environment variable. |
The following diagram illustrates the syntax to set the run mode with the -f option.
Setting the run mode .-l-. |-- -f--+---+--+---+--------------------------------------------| +-d-+ '-u-' +-p-+ '-a-'
Element | Purpose | Key considerations |
---|---|---|
a | Treats the data source as a device-array | The definition of the device array is extracted from the onpload database. |
d | Treats the data source as a tape device | None |
l | Loads data into the database | This is the default flag, as opposed to u, which unloads data from the database. |
p | Treats the data source as a program to run, and reads the interface to the program by way of a pipe (UNIX only) | None |
u | Unloads data from the database | If this flag is not set, onpladm loads data into the database. |