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] 
       [id=logon pass=password] [saveddl=savefile]

UNIX:

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

Syntax Rules

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

Parameters

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.
pass The password for the database server.
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.

Examples

Windows:

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

UNIX:

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