Creating Maps

You can create maps by using a quick command or a specification file. For more information on specification-file conventions, see Specification-File Conventions.

Creating a Map by Using a Quick Command

When you create a map by using a quick command, the onpladm utility creates a format object with the same name as the map, plus the suffix -fmt. The generated format name (as for all onpladm objects) has a maximum length of 18 characters.

For example, if the map name is mymap, the format name is mymap-fmt. If the map name is 123456789123456789, the format name is 12345678912345-fmt.

The create map command also creates a query object for the unload map. The following diagram illustrates the syntax to create a map from the command line.

Creating a Map
 
>>-onpladm create map--mapname--+--------------+---------------->
                                '- -p--project-'
 
>-- -D--database-- -t--table------------------------------------>
 
   .-----------------------------------------.
   V                                         |
>----+-------------------------------------+-+-----------------><
     +- -S--servername---------------------+
     +- -T--targetservername---------------+
     +-| Setting the 

 Format |-+
     '- -f--+---+--------------------------'
            +-l-+
            '-u-'
 

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

Creating a Map With a Detailed Specification File

When you create a map, the onpladm utility creates a format object with the same name as the map.

When you create a map with a specification file, you must create all associated HPL objects; the onpladm utility does not create these objects for you.

Use the syntax shown in Specification-File Conventions to create maps with specification files.

Use the following syntax to creating a load map with a specification file:

BEGIN OBJECT LOADMAP mapname 

# Compulsory Attributes 
PROJECT projectname 
FORMAT formatname 
DATABASE targetdatabasename 
TABLE targettablename 

BEGIN SEQUENCE 
COLUMNNAME columnname 
FIELDNAME fieldname 
JUSTIFICATION justification 
CASECONVERT caseconversion 
DEFAULTVALUE defaultvalue 
TRANSFERBYTES byte_transfer 
COLUMNOFFSET column_offset 
FIELDOFFSET field_offset 
FIELDMINIMUM field_minimum 
FIELDMAXIMUM field_maximum 
FILLCHARACTER fillcharacter 
PICTURE picture 
FUNCTION record_function 
STORAGECODING storage_format
BLOBCOLUMN blob_columnname
END SEQUENCE 

END OBJECT  

The following table lists the attributes and their values.

Use the following syntax to create an unload map with a specification file:

BEGIN OBJECT UNLOADMAP mapname 

# Compulsory Attributes 
PROJECT projectname 
FORMAT formatname 
DATABASE targetdatabasename 
QUERY queryname 

BEGIN SEQUENCE 
COLUMNNAME columnname 
FIELDNAME fieldname 
JUSTIFICATION justification 
CASECONVERT caseconversion 
DEFAULTVALUE defaultvalue 
TRANSFERBYTES byte_transfer 
COLUMNOFFSET column_offset 
FIELDOFFSET field_offset 
FIELDMINIMUM field_minimum 
FIELDMAXIMUM field_maximum 
FILLCHARACTER fillcharacter 
PICTURE picture 
FUNCTION record_function 
STORAGECODING storage_format
BLOBCOLUMN blob_columnname
END SEQUENCE 

END OBJECT  

The following table lists the attributes and their values.