mfhco export command

Syntax

UNIX:

cobmfhco export db=databasename tbl=table file=filename
    [fmt=format] [log=logfile] [chardel=chardelimiter] [coldel=coldelimiter]
       [date=dateformat] [plus=sign]

Windows:

mfhco export db=databasename tbl=table file=filename
    [fmt=format] [log=logfile] [chardel=chardelimiter] [coldel=coldelimiter]
       [date=dateformat] [plus=sign]

Syntax Rules

At least one space must occur before each parameter in the command.
There must be an equal sign (=) between parameters and their values.
If you omit parameters that have a default value, Host Compatibility Option uses the default value.

Parameters

export	Parameter to invoke Export Data command line processor. Parameter is positional.
`databasename`	Name of the database to connect to.
`table`	Name of table to be exported. Can include both schema and table name.
filename	Filename to export data to.
`format`	Format in which to export data. Valid values are IXF, DEL, and DSNTIAUL. You can use DSN for DSNTIAUL.
`logfile`	File to write processing messages to. If this parameter is not specified, a logfile is created in the current directory (UNIX) or with a default logfile name using the project name (Windows).
`chardelimiter`	Delimiter used to enclose character data when export format DEL specified. Default is double quotes (").
`coldelimiter`	Delimiter used to indicate the end of column data when export format DEL is specified. Default is comma (,).
`dateformat`	Format to export date fields in if exporting data in DSNTIAUL or DEL format. Default is format for your country. Valid values for DSNTIAUL are ISO, USA, EUR and JIS. ISO is the only valid option for DEL format.
`sign`	Generate positive numeric data with plus signs when exporting data in DEL format. Valid values are "Y" for yes to generate plus signs or "N" to not generate plus signs. Default is "Y".

Comments

You can also run the Export Data tool as a batch function.

Example

UNIX:

cobmfhco export db=db2demo fmt=ixf file=product.ixf tbl=demo.product log=export.log

Windows:

mfhco export db=db2demo fmt=ixf file=product.ixf tbl=demo.product log=export.log