mfhco and cobmfhco ddl commands

Syntax

Tip: Use the UNIX version of this tool to process SQL DDL statements on a UNIX server that is accessed remotely via a Windows client.

Windows:

mfhco ddl db=databasename file=file [log=logfile]
    [max=colno] [mod=modify] [saveddl=savefile]

UNIX:

cobmfhco ddl db=databasename file=file [log=logfile]
    [max=colno] [mod=modify] 
       [id=logon pass=password saveddl=savefile]

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.

ddl	Specifies use of the DDL Processor. This parameter is positional.
`databasename`	Name of the database that you want to process DDL statements against.
`file`	The name of the file that contains DDL statements.
`logfile`	The name of log file to write processing details 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). If you specify this parameter but specify no value for it (blank), this turns logging off.
`colno`	Column number to process DDL statements to. Must be a number less than or equal to 80.
`modify`	Set this parameter to "Y" if you want DDL statements converted to DB2 LUW format. Set this parameter to "N" if you want to process DDL statements unchanged. If you select this option, you must set the DDL delimiter value in the configuration file.
`logon`	The logon ID for the database server. (UNIX only)
`pass`	The password for the database server. (UNIX only)
saveddl	Save the converted DDL to a file instead of writing it to the database.
`savefile`	The name of a file in which to save the converted DDL. In this case, the database is not updated.

Windows:

mfhco ddl db=db2demo file=hcosetup.sql log=ddlproc.log

UNIX:

cobmfhco ddl db=db2demo file=hcosetup.sql log=ddlproc.log