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

                               .----------------------------.   
                               V                            |   
>-- -D--database -- -t--table----+------------------------+-+--><
                                 +- -S -servername--------+     
                                 +- -T -targetservername--+     
                                 +-| Setting the format |-+     
                                 '- -f--+---+-------------'     
                                        +-l-+                   
                                        '-u-'

Element	Purpose	Key considerations
-D database	Name of the target database that contains the information to be loaded or unloaded	No default value
-f	Flags to specify the type of job	The default is load job.
l	Specifies a load job	None
u	Specifies an unload job	None
mapname	Sets the map	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 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.