Chapter 5: Setting INI Options

5.1 Overview

All of the Host Compatibilty Option tools save commonly used configuration options in file mfhco.ini located in the User Settings directory. This file is created the first time you use Host Compatibility Option and is set to default values. You should over time update the configuration file to your commonly used values. This will save you considerable time in using the Host Compatibility Option tools.

5.2 Set Defaults Window

mfhco.ini is an ANSI text file that can be edited using any ANSI text editor. You should probably not set any values in this file until you are familiar with what the valid values are for each configuration parameter.

Figure 5-1: Set Defaults window

You can display the Host Compatibility Option default values from the IDE by selecting Configuration from Tools, HCO menu (see Figure 5-1).

The following elements make up the Set Defaults window:

List box for Settings. This corresponds to first part of text in INI file.
Value group box. Controls will vary in group box depending on the type of setting.
Short description of what setting does.
Save push button. This control saves all changes made.
Defaults push button. Selecting this control will reset ALL settings to default values.
Cancel push button. Selecting this control will cause you to exit window. If changes have been made, a window is displayed asking if you want to save changes.
Help push button. Display on-line User's guide for this window.

5.3 Updating Defaults

To update default configuration values, select parameter to set from Setting list box.

The Value and Description group boxes are updated with the current setting and description of the setting. Drop-down list boxes in Value group box will only include valid options that you can select. Entry fields are free format with little editing. If entry is a drive/folder, you should make sure drive/folder exists as Host Compatibility Option does not create them.

Set new value that you want parameter to use in Value group box
Click Save once all values have been set

A message box is displayed after values have been saved. Changes do not go into effect until the next time you invoke a Host Compatibility Option tool.

5.4 Resetting Defaults

If you make a mistake, or you want to find out what the default value is for a parameter, you can just click Defaults. This will reset all parameters to their default value. You need to click Save to save these changes.

5.5 Configuration Parameters

The following is a list of configuration parameters that can be set:

Parameter	Description
`[MFHCO]`	Following parameters apply to all Host Compatibility Option tools.
`Toolbar`	Display toolbar for each tool. The toolbar contains bitmaps that you can select for commonly used functions. Default value is yes.
`Hinting`	Display "hints" as to what object on tool is used for in status line. Default is yes.
`Prompt on Exit`	Display confirmation prompt anytime you try to exit Host Compatibility Option tool. Default is no.
`DB2 Version`	Displays the version of DB2 Universal Database software that Host Compatibility Option found installed on this PC. Parameter is for information purposes only.
`Auto Connect to Database`	Automatically connect to database on tools that need to connect to database. Default is yes.
`Database Name`	Name of database to automatically connect to if "Auto Connect" parameter is set to yes. If blank, use the database specified in the Mainframe Express project.
`Schema`	Schema to restrict table list with when connecting to database. Default is all schemas (%).
`Table Name`	Table name to restrict table list with when connecting to database. Default is all tables (%).
`Extension of Logs`	Extension to use when creating log file names. Default is log.
`[DCLGEN]`	Following parameters apply to the Generate Copybook tool.
`Display Copybook`	Display the copybook after it is generated. Default is yes.
`Copybook Type`	Syntax to use when generating copybook. Options are CBL for COBOL, PLI for PL/1 and C for C. Default is CBL.
`Extension Copybook`	Extension to use when generating copybooks. Default is cpy.
`Structure Name`	Structure name to use when generating copybooks. Default is to generate name using DCL + table name by leaving field blank.
`Type Prefix`	Prefix to generate when creating host variable names. Options are use table name (TABLENAME), user supplied prefix (USERVALUE), or no prefix (NO-PREFIX). Default is TABLENAME.
`User Prefix`	Prefix to use when generating host variables when "Type Prefix" set to USER-VALUE. This field can be set to 8 character maximum.
`Field Name`	Name to generate host variables with. Either column name (COLUMN-NAME) or column number (NUMBERED). Default is COLUMNNAME.
`Long Varchar Size`	Size of field to generate in copybook when long varchar columns found. Options are 4K and 32K. Default is 32K.
`Enclose Name`	Enclose table and column names in double quotes. Default is no.
`Null Indicator Suffix`	Suffix to append to host variable names to create indicator variable names when column is nullable. Default is "NULL".
`Include Schema in DECLARE TABLE`	Include the schema name with table name in DECLARE TABLE. Default is yes.
`[DDL]`	Following parameters apply to the DDL Processor tool.
`DDL File Extension`	Extension to use when either looking for or creating DDL files.
`Log File Name`	Name to create log file with. Name is created from combining the drive\folder specified by the Mainframe Express project, this field, and "Log Extension", 8 character maximum. Default is "DDLPROC".
`Display Log`	Display DDL log file after statements have been processed. Default is yes.
`Max Column`	Maximum column to process DDL statements to. Default is 80.
`Modify DDL`	Modify DDL statements to DB2 Universal Database compatible syntax. Default is yes.
`Statement Delimiter`	Statement delimiter to indicate end of statement when "Modify DDL" parameter is set to no. Default is a semi-colon ( ";").
`[CATNODE]`	Following parameters apply to the Catalog Server tool.
`Protocol`	Communications protocol to catalog servers with. Choices are NETBIOS, TCPIP, APPC, and SPX/IPX. Default is NETBIOS.
`[CRDB]`	Following parameters apply to the Create Database tool.
`Codepage for Database`	EBCDIC collating sequence code page to create database with. See the chapter Create Database for more details on valid values. Default is "MFD".
`Create Database Location`	Location to create database. Choices are local or remote. Default is "LOCAL".
`Drive`	Drive to create database on. Choices are "DEFAULT" or a valid drive letter for your PC. See the chapter Create Database for more details. Default is "DEFAULT".
`Log File Name`	Name to create log file with. Name is created from combining the drive\directory specified in the Mainframe Express project, this field, and "Log Extension", 8 character maximum. Default is "CREATEDB".
`Display Log`	Display Create Database log file after statements have been processed. Default is yes.
`[EXPORT]`	The following parameters apply to the Export Data tool.
`Display Export Log`	Display Export log file after export command completes. Default is yes.
`Log File Name`	Name to create log file with. Name is created from combining the drive\directory specified in the Mainframe Express project, this field, and "Log Extension", 8 character maximum. Default is "EXPORT".
`Format of Data Exported`	Format to export data in. Options are DBMAUI, DSNTIAUL, IXF, and DEL. Default is "IXF".
`Export File Extension`	Extension to use when creating default export file name. If you use value of "DEFAULT", extension is based on format where DSN is used for DSNTIAUL, DBM is used for DBMAUI, IXF is used for IXF, and DEL is used for DEL format files. Default is "DEFAULT".
`[IMPORT]`	The following parameters apply to the Import Data Tool.
`Display Import Log`	Display Import log file after import command completes. Default is yes.
`Log File Name`	Name to create log file with. Name is created from combining the drive\directory specified in the Mainframe Express project, this field, and "Log Extension", 8 character maximum. Default is "IMPORT".
`Format of Data Imported`	Format to import data in. Options are DBMAUI, DSNTIAUL, IXF, and DEL. Default is "IXF".
`Import File Extension`	Extension to use when creating default import file name. If you use value of "DEFAULT", extension is based on format where DSN is used for DSNTIAUL, DBM is used for DBMAUI, IXF is used for IXF, and DEL is used for DEL format files Default is "DEFAULT".
`[GALIAS]`	The following parameters apply to the Generate Alias tool.
`Display DDL Generated`	Display the DDL file after statements have been generated.
`DDL File Name`	Name to create DDL file with. Name is created from combining drive/directory specified in the Mainframe Express project, this field, and "DDL Extension", 8 character maximum. Default is "GENALIAS".

5.6 Exiting Set Defaults

To exit this option you must press the Escape key or click on the Cancel push button.

Running Host Compatibility Option Tools

Create Database