Create conversion jobs by using a quick command
When you create a conversion job by using a quick command, the onpladm utility creates all High-Performance Loader (HPL) objects associated with the job. The HPL objects that it creates have the same name as the job.
The following diagram illustrates the syntax to create a conversion job from the command line.
| Element | Purpose | Key considerations |
|---|---|---|
| -B blocksize | Sets the tape I/O block size (bytes) | No default value |
| -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 |
| -M devicesize | Tape device size in kilobytes | The device size must be greater than zero. |
| -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
| Element | Purpose | Key considerations |
|---|---|---|
| a | Treats data source as a device-array | The definition of the device array is extracted from the onpload database. |
| c | Sets mode to deluxe mode | If this flag is not set, onpladm uses express mode. |
| d | Treats data source as a tape device | None |
| l | Loads data into database | This is the default flag, as opposed to u, which unloads data from the database. |
| n | Specifies that onpladm 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 onpladm generated the input data file as a data file in HCL Informix® format, you do not need to perform data conversion when you reload data. |
| N | Allows deluxe mode load without replication | This flag works only if the job argument, which specifies a session table job to run, is left blank. |
| p | Treats data source as a program to run and reads interface to the program by way of a pipe (on UNIX™ only) | None |
| u | Unloads data from database | If this flag is not set, onpladm loads data into the database. |
The following diagram illustrates the syntax to set the format type with the -z option.
Setting the Format
| Element | Purpose | Key considerations |
|---|---|---|
| D | Sets the format to delimited | This is the default value. See Delimited records. |
| FI | Sets the format to fixed internal | See Fixed-length records. |
| FA | Sets the format to fixed ASCII | See Fixed-length records. |
| FB | Sets the format to fixed binary format. | See Fixed-length records. |
| C | Sets the format to COBOL | See COBOL records. |
| CB | Sets the format to COBOL (byte) | See COBOL records. |