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