Installing on Windows

To install Micro Focus XDBC Local or Micro Focus XDBC Server on a Windows machine, download and run the xdbc.exe installer.

Note: For Windows Vista, Windows 7, or Windows Server R2, you must be logged in as an Administrator.

Note: If you have more than one Micro Focus COBOL runtime system installed on your machine (e.g. Net Express and Studio Enterprise Edition), the installer brings up a dialog that shows all your installed COBOL systems. You must choose which COBOL system to use with Micro Focus XDBC. This is because Micro Focus XDBC relies on certain files provided with your COBOL system and the locations of these files differ between COBOL runtime systems.

The installation process sets an environment variable named GENESIS_HOME with the location of the installation directory. Your configuration files will need to be placed in this directory. Though you can have several configuration files and refer to different ones in your data source names (DSNs) or command-line tools, they must always reside in GENESIS_HOME (the installation directory).

Note: If you create a Micro Focus XDBC database using non-default directories, be sure to modify the DICTSOURCE and FILE_PREFIX variables in the Local configuration file. (For information on these variables, see the section Local Configuration in the chapter Configuration.)

Tip: The mfxset file, located in %GENESIS_HOME%\bin, contains defaults used for many of the tools. You may want to duplicate in this file any changes that you made to defaults, to reflect the new defaults used by system utilities.

Open a command prompt.

Change to the bin subdirectory of your install location:

cd %GENESIS_HOME%\bin

Note: The GENESIS_HOME environment variable should be set to your installation directory; this is initially set by the installer to your installation directory.

Create the Micro Focus XDBC configuration file by typing:

mfgenconf

Note: Running mfgenconf requires Administrator privileges.

The following output is displayed:

Creating file "c:\Program Files\Micro Focus\XDBC 2.0\mfdbc.cfg"

mfgenconf can be customized. For information about mfgenconf.bat, see Local Configuration in the chapter Configuration.

Initialize the system catalog and generate the demo database by entering:

mfdemo.bat

The following output is displayed:

Building demo with the following settings

Data Directory = "c:\Program Files\Micro Focus\XDBC 2.0\mf_data"
System Catalog = "c:\Program Files\Micro Focus\XDBC 2.0\mfsyscat"
Sample Data    = "c:\Program Files\Micro Focus\XDBC 2.0\sample\mfdbc"\mf_data
Sample XFD     = "c:\Program Files\Micro Focus\XDBC 2.0\sample\mfdbc"\xfd

Creating System Catalog in "c:\Program Files\Micro Focus\XDBC 2.0\mfsyscat"
Started at 2011-01-27 14:51:52

Creating Information Schema Views
Load Sample file descriptions
Started at 2011-01-27 14:51:55
Information: Begin XFD Conversion
Information: Begin XFD file accounts
Information: Begin Table ACCOUNTS
Information: Begin XFD file animals
Information: Begin Table ANIMALS
Information: Begin XFD file clients
Information: Begin Table CLIENTS
Information: Begin XFD file codes
Information: Begin Table CODES
Information: Begin XFD file pets
Information: Begin Table PETS
Information: End Repository Conversion

Note: For more information about mfdemo.bat, see Using the Demo Program from Windows in the chapter Using Micro Focus XDBC.

Open the query tool:

mfsql

Note: For more information about, mfsql.bat, see Running SQL Scripts in chapter Using the Command-line Query Tool and Granting Database Privileges in chapter Using Micro Focus XDBC.

From the SQL (/? for help) ==> prompt, run a sample query by entering:

SELECT * FROM PETS;

A list of records from the PETS table is returned.