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.

Figure 1: Creating a database project

1  onpladm create project projectname  -d device   -D database ?  %Setting the run mode
1  -n
1 %Setting the format
2?  -P prefix 
2?  -T target 
2?  -S server 
2?  -M devicesize 
2?  -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

1  -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

1  -z
1  D
1  FI
1  FA
1  FB
1  C
1  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.