Create conversion jobs by using a quick command
When you create a conversion job by using a quick command, the onpladm utility creates all 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.
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.
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. |