Create a database project

When you create a database project with a single command, the onpladm utility:

Creates all load or unload jobs for every table in a database
Creates all the associated project HPL objects required for the jobs
Groups the load or unload jobs and associated project HPL jobs into a single project that has the same name as the database

When you create a database project, you must specify the data-files source directory name or the tape-device path.

If you specify the data-files source directory, the files that the onpladm utility creates have the following format:

PREFIX_DATABASE_TABLE.unl

PREFIX is an option that you specify on the command line, DATABASE is the name of the target database, and TABLE is the name of the target-table name.

If you do not specify a prefix, the onpladm utility creates files of the following format:

DATABASE_TABLE.unl

The onpladm utility truncates the format file name if it is longer than the maximum file name length of 18 characters.

The following diagram illustrates the syntax to create a project for all the tables in a database.


Creating a database project

>>-onpladm create project--projectname-- -d--device ------------>

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

>--+------------------------+--+--------------+----------------->
   +- -n--------------------+  '- -P--prefix -'   
   '-| Setting the format |-'                     

>--+--------------+--+--------------+--+------------------+----->
   '- -T--target -'  '- -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.
-M devicesize	Tape device size in kilobytes	The device size must be greater than zero.
-n	Sets no-conversion express job	None
-P prefix	Filename prefix for the files to be used as devices	None
projectname	Identifies the project where the format and map are stored	None
-S server	Sets the onpload database server	The default is the value of the INFORMIXSERVER environment variable.
-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

|-- -f--+---+--+---+--+---+-------------------------------------|
        '-d-'  '-c-'  '-N-'

Element	Purpose	Key considerations
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
N	Allows deluxe mode load without replication	None

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	See Fixed-length records.
C	Sets the format to COBOL	See COBOL records.
CB	Sets the format to COBOL (byte)	See COBOL records.