MFDDLConverter command

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};]
               [CCSID={KEEP | IGNORE};]

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 %ALLUSERSPROFILE%\Micro Focus\Enterprise Developer\hcoss\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.

CSSID

Specifies whether or not to preserve the mainframe sort order for text columns:

KEEP	Preserves the mainframe sort order by adding a CCSID clause to the table definition.
IGNORE	Returns text columns in the order specified by the SQL Server target database or table collation identifier. Default.

Example:

MFDDLConverter S=MySchemaExtract; O=c:\ProgramData\MyDDL.sql; DROP=DR; SYSIBM=TRUE