HP 3000 Manuals HP 3000 Manuals
Chapter 8 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. 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.