Installing on Windows

  1. 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.
  2. Open a command prompt.
  3. 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.
  4. 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.

  5. 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.
  6. 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.
  7. 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.

In network environments, install the Micro Focus XDBC Client software on each client in the network