Syntax of the onunload command

The onunload command unloads data from a database and writes a database or table into a file on tape or disk.

Read syntax diagramSkip visual syntax diagram
>>-onunload--+-------------------------+------------------------>
             |                     (1) |   
             '-|  -FILE option   |-----'   

>--+--------------------------------+--database----------------->
   |                            (2) |             
   '-| Destination Parameters |-----'             

>--+------------------------+--+-----------+-------------------><
   '-:--+----------+--table-'  +- -V-------+   
        '-owner--.-'           '- -version-'   

Notes:
  1. See The -FILE option.
  2. See onunload destination parameters
Element Purpose Key Considerations
database Specifies the name of a database Additional Information: The database name cannot be qualified by a database server name (database@dbservername).

References: Syntax must conform to the Identifier segment; see Identifier.

owner. Specifies the owner of the table Additional Information: The owner name must not include invalid characters.

References: For path name syntax, see your operating-system documentation.

table Specifies the name of the table Requirement: The table must exist.

References: Syntax must conform to the Identifier segment; see Identifier.

If you do not specify any destination parameter options, onunload uses the device that TAPEDEV specifies. The block size and tape size are the values specified as TAPEBLK and TAPESIZE, respectively. (For information about TAPEDEV, TAPEBLK, and TAPESIZE, see your IBM® Informix® Administrator's Reference.)

The -V option displays the software version number and the serial number. The -version option extends the -V option to display additional information about the build operating system, build number, and build date.


Copyright© 2018 HCL Technologies Limited