   =========================================================================
                             M I C R O   F O C U S

                           S E R V E R  E X P R E S S 
   =========================================================================

                                 PROJECT HCODEMO
                                 ===============

   TABLE OF CONTENTS
   =================
       INTRODUCTION
       SOURCE FILES
       REQUIREMENTS
       OPERATION


   INTRODUCTION
   ============

   HCODEMO consists of several scripts and COBOL programs that demonstrate
   the functionality of the Host Compatibility Option. The functionality 
   represented includes:

   o Database creation
   o DDL processing
   o Import
   o Export
   o DCLGEN
   o Using Static SQL statements
   o Using Dynamic SQL statements



   SOURCE FILES
   ============

   HCOBATCH.cbl
   HCODYN1.cbl
   HCODYN2.cbl
   HCOSETUP.sql
   PRODUCT.cpy
   PRODUCT.dsn
   mfhcocds.sql

   REQUIREMENTS
   ============

   To use the Host Compatibility Option, you must have IBM's
   DB2 Universal Database version 5 or later installed.

   OPERATION
   =========

   Execute all commands from a DB2 command prompt:

   1. Drop the DB2DEMO database:

      db2 drop db DB2DEMO

   2. Create a database using the default EBCDIC collating sequence:

      cobmfhco cre db=db2demo coll=mfd log=createdb.log

   3. Populate the database using the DDL processor:

      cobmfhco ddl db=db2demo file=hcosetup.sql log=ddlproc.log

   4. Import data into the PRODUCT table:

      cobmfhco import db=db2demo fmt=dsn tbl=demo.product 
        file=product.dsn chardel=' log=import.log

   5. Export data from the PRODUCT table:

      cobmfhco export db=db2demo fmt=ixf file=product.ixf 
        tbl=demo.product log=export.log

   6. Create a COBOL copybook containing appropriate host variable
      definitions from the ITEMS table:

      cobmfhco dclgen db=db2demo lang=cbl tbl=demo.items file=item.cpy

   Use HCOBATCH to demonstrate the use of Static SQL.

   Use HCODYN1 and HCODYN2 to demonstrate the use of Dynamic SQL.


   ========================================================================
   IBM and DB2 are registered trademarks of International Business Machines
   Corporation.
   Micro Focus and Net Express are registered trademarks of Micro Focus
   International Limited
   ========================================================================
   Copyright (C) 2007  Micro Focus (IP) Limited
