Executes the HCOSS Generate DDL tool from the command line.
Syntax
MFDDLConverter S=schemaExtractFile;
[SLocal={TRUE | FALSE};]
O=["]DDLOutputFile["];
DROP={DR | CNE};
SYSIBM={TRUE | FALSE};
[M=["]dataMappingFile["];]
[TYPE={TABLE | VIEW | ALL};]
[SCHEMA=DB2Schema1[, DB2Schema2 ...];]
[NAME=objectName;]
[ROWSIZE={TRUE | FALSE};]
[INCDEP={TRUE | FALSE};]
[STITCH={TRUE | FALSE};]
[TYPELOG={CONSOLE | FILE | BOTH};]
[FOOTER={TRUE | FALSE};]
Parameters:
- S
- The name of a schema extract file generated using the HCOSS Schema Extract tool. Do not specify a file extension.
- SLocal
- Specifies the location of the generated schema extract file. Schema extract files are stored in the
\Schemas subdirectory of either of the following, depending on the value specified:
TRUE
|
Directory specified by the
Local HCOSS Directory HCOSS option. Default.
|
FALSE
|
Directory specified by the
Shared HCOSS Directory HCOSS option.
|
- O
- The full path to and filename of the generated DDL command file (usually given a
.sql file extension). If this specification contains spaces, enclose it in double quotes (").
- DROP
- Determines how objects are handled in the generated DDL.
DR
|
Drop and recreate all objects
|
CNE
|
Create a new database object for each object in the object list that does not already exist in the database
|
- SYSIBM
- Specifies whether or not to include the SYSIBM schema in the generated DDL. Both the SYSIBM schema and its dependent objects are included when set to
TRUE; however, the SYSIBM schema and its dependent objects must be present in the schema extract file to be included in the generated DDL.
- M
- Full path to and filename of the HCOSS data mapping file. If this specification contains spaces, enclose it in double quotes ("). Defaults to
%PROGRAMDATA%\Micro Focus\NetExpress\6.0\DataMappings.hcomap.
- TYPE
- Limits objects to tables only or views only. Default is ALL.
- SCHEMA
- The name of one or more valid DB2 schemas to include in the generated DDL. Separate schema names with a comma (,). You may also use the
% wild card character in schema names. Defaults to all schemas in the object list file.
- NAME
- Filters the generated DDL to include only the specified DB2 table or view name. You may use the
% wild card character in table and view names. Defaults to all table and view names.
- ROWSIZE
- Specifies whether or not to check table column widths to determine if they exceed the SQL Server row width limit of 8060 and write the information to the log file.
TRUE
|
Check table column widths.
|
FALSE
|
Do not check table column widths. Default.
|
- INCDEP
- Specifies whether or not to include table and view dependencies when processing objects.
TRUE
|
Include table and view dependencies.
|
FALSE
|
Do not include table and view dependencies. Default.
|
- STITCH
- Specifies whether or not to include a DDL header in the generated DDL:
TRUE
|
Include DDL header.
|
FALSE
|
Exclude DDL header. Default.
|
- TYPELOG
- Sets the type of logging to perform. Defaults to the equivalent of the value specified for the
Type of logging to do HCOSS option.
- FOOTER
- Specifies whether or not to include a DDL footer in the generated DDL:
TRUE
|
Include DDL footer. Default.
|
FALSE
|
Exclude DDL footer.
|
Example:
MFDDLConverter S=MySchemaExtract; O=c:\ProgramData\MyDDL.sql; DROP=DR; SYSIBM=TRUE