HP 3000 Manuals HP 3000 Manuals
Chapter 10 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 Command Operations.