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.


Creating a conversion job

>>-onpladm create job -job--+---------------+-- -d--device ----->
                            '- -p--project -'                 

>-- -D--database-- -t--table--+--------------------------+------>
                              '-| Setting the run mode |-'   

>--+------------------------+--+-------------+------------------>
   +- -n -------------------+  '- -T--target-'   
   '-| Setting the format |-'                    

>--+-------------+--+-----------------+--+----------------+----><
   '- -S--server-'  '- -M--devicesize-'  '- -B--blocksize-'

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

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

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

|-- -z--+----+--------------------------------------------------|
        +-D--+   
        +-FI-+   
        +-FA-+   
        +-FB-+   
        +-C--+   
        '-CB-'

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.