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

                     S E R V E R   E X P R E S S  5.0
   =========================================================================
                              PROJECT DB2TEST2
                              ================

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


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

   DB2TEST2 connects to the SAMPLE database supplied with IBM DB2
   Universal Database and illustrates the use of SELECT...INTO and
   cursor based data retrieval (DECLARE, OPEN, FETCH, CLOSE).


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

   DB2TEST2.CBL
   SQLCA.CPY

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

   DB2TEST2 is written to operate with the DB2 SAMPLE database supplied
   with various versions of DB2 Universal Database V5 software products.
   You must have been granted BIND/ADD authority on this database and SELECT
   authority on the STAFF table.

   If you use a copy of the SAMPLE database created by some other
   person, you will need to either create an ALIAS for the STAFF table
   or qualify all references in the example program to specify the
   schema name used to create the SAMPLE database otherwise you will
   get a -204 SQL error compiling the program.



   OPERATION
   =========

   DB2TEST2 connects to the database and then prompts for a staff id
   key value and retrieves and displays a row from the STAFF
   table using a SELECT...INTO statement. It then prompts for a
   Department number (such as 84 or 10), and retrieves and displays rows for
   all employees in that department.


   =========================================================================
   Micro Focus is a registered trademark, and Server Express is a trademark,
   of Micro Focus International Limited. All other trademarks are the
   property of their respective owners.
   =========================================================================
   Copyright (C) 1999 Micro Focus International Limited. 
   All rights reserved.

