Dynamic operations in ALLBASE/SQL are of two major types:
Dynamic Non-Queries: dynamic operations that do not retrieve rows from
the database. Note that dynamic non-queries either do or do not require
the use of sections at execution time. For example, a CONNECT does not
require a section, but a DELETE does.
Dynamic Queries: dynamic operations that do retrieve rows. Note
that dynamic queries may have a query result whose format is
known to you at programming time, or they may have a query result whose
format is unknown. Dynamic queries always use sections at
execution time.
It is sometimes necessary to define dynamic data structures that can
accomodate either non-queries or queries at run time. An example
is shown later in this chapter in program cex10a (Figures 8-7, 8-8,
8-9).
The following paragraphs examine each type of dynamic operation
and present information on how to determine whether or not a dynamic
command is a query.