MFObjectList command

Syntax:

MFObjectList S=schemaExtractFile;
             [SLocal={TRUE | FALSE};] 
             OUT=objectListOutputFile; 
             [OUTLocal={TRUE | FALSE};] 
             [M=["]dataMappingFile["];] 
             [SYSIBM={TRUE | FALSE};] 
             [TYPE={TABLE | VIEW | ALL};] 
             [SCHEMA=DB2Schema1[, DB2Schema2 ...];] 
             [NAME=objectName;] 
             [TYPELOG={CONSOLE | FILE | BOTH};]

Parameters:

S

The name of a schema extract file generated using the HCOSS Schema Extract tool. Do not specify a file extension.

SLocal

Determines the location of the schema extract file specified by the S parameter. 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.

OUT

The name of the generated object list file. Do not specify a file extension. The default file extension is .hcolst.

OUTLocal

Determines the location of the generated object list file. Object list files are stored in the \TargetLists 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.

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.

SYSIBM

Specifies whether or not to include the SYSIBM schema. Default is FALSE.

TYPE

Limits objects to tables only or views only. Default is ALL.

SCHEMA

The name of one or more valid DB2 schemas to include on the object list. Separate schema names with a comma (,). You may also use the % wild card character in schema names. Defaults to all schemas specified in the schema extract file.

NAME

Filters the object list 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.

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.