HP 3000 Manuals HP 3000 Manuals
Understanding the Types of Dynamic Operations
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 pas10a (Figures 10-7, 10-8, 10-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.