HP 3000 Manuals

ALLBASE/SQL COBOL Application Programming Guide

Chapter 10  Using Dynamic Operations 

Dynamic operations are used to execute SQL commands that are not
preprocessed until run time.  Such commands, known as dynamic SQL 
commands, are submitted to ALLBASE/SQL through several special SQL
statements:  PREPARE, DESCRIBE, EXECUTE, and EXECUTE IMMEDIATE.

This chapter contrasts dynamic with non-dynamic operations and introduces
the techniques used to handle dynamic operations from a program.  In
COBOL programs, you cannot dynamically preprocess a query (SELECT
command).  However, you can call a Pascal or C subprogram which can
dynamically preprocess a query.  The following topics are considered:

   *   Review of Preprocessing Events.
   *   Differences between Dynamic and Non-Dynamic Preprocessing.
   *   Preprocessing of Dynamic Queries (See note below.)
   *   Preprocessing of Dynamic Non-Queries.
   *   Programs Using Dynamic Operations.


NOTE  COBOL, by itself, cannot use dynamic queries.  However, a method
      for calling a C or Pascal routine to process the dynamic query is
      presented.

MPE/iX 5.0 Documentation