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 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 process dynamic queries. However, a method for calling
a C routine to process the dynamic query is presented. |
|
| |
|
