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]
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. |
Windows:
mfhco ddl db=db2demo file=hcosetup.sql log=ddlproc.log
UNIX:
cobmfhco ddl db=db2demo file=hcosetup.sql log=ddlproc.log