HP 3000 Manuals

ALLBASE/SQL Release F.0 Application Programming Bulletin for MPE/iX

Chapter 3  Using Parameter Substitution in Dynamic Statements 

When your application uses dynamic processing, parameter substitution
offers added flexibility and improved performance.  Although you can use
this technique in any dynamic processing application involving prepared
sections, it could be most useful for applications where the same SQL
statement type must be re-executed multiple times using a different set
of parameter values each time.

A statement containing dynamic parameters must be dynamically
preprocessed at run time by using the PREPARE statement.  The dynamic
section created can then be executed as many times as required within a
given transaction with the option of assigning a different set of dynamic
parameter values for each execution and without the overhead of
preprocessing each time input values change.

The following paragraphs define dynamic parameters, discuss
implementation methods, and provide examples.  Topics include:

   *   Understanding Dynamic Parameters.
   *   Where to Use Dynamic Parameters.
   *   Programming with Dynamic Parameters.
   *   Using Default Data Types with Dynamic Parameters.

MPE/iX 5.0 Documentation