Creating a Database Project

Home | Previous Page | Next Page The onpladm Utility > Defining Database Operations >

Creating 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 filename if it is longer than the maximum filename 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)	Additional Information: No default value.
-d device	Sets the name of device, such as a file, device array, tape, or pipe	Additional Information: No default value.
-D database	Name of the target database that contains the information to be loaded or unloaded	Additional Information: No default value.
-M devicesize	Tape device size in kilobytes	Additional Information: 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	Additional Information: The default is the value of the INFORMIXSERVER environment variable.
-T target	Name of the target server to which the data will download	Additional Information: 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.	Additional Information: 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	Additional Information: This is the default value. See Delimited Records.
FI	Sets the format to fixed internal	Additional Information: See Fixed-Length Records.
FA	Sets the format to fixed ASCII	Additional Information: See Fixed-Length Records.
FB	Sets the format to fixed binary	Additional Information: See Fixed-Length Records.
C	Sets the format to COBOL	Additional Information: See COBOL Records.
CB	Sets the format to COBOL (byte)	Additional Information: See COBOL Records.