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. It then focuses on
dynamic non-queries and queries. The following topics are considered:
Review of Preprocessing Events.
Differences between Dynamic and Non-Dynamic Preprocessing.
Preprocessing of Dynamic Non-Queries.
Preprocessing of Dynamic Queries.
Preprocessing of Dynamic Commands That May or May Not be Queries.
Programs Using Dynamic Query Operations.