HP 3000 Manuals

ALLBASE/SQL Pascal Application Programming Guide

Passing Dynamic Commands to ALLBASE/SQL 

A dynamic command is passed to ALLBASE/SQL either as a string literal or
as a host variable containing a string.  It must be terminated with a
semicolon.  The maximum length for such a string is 2048 bytes.

To pass a dynamic command that can be completely defined at programming
time, you can use a delimited string:

     EXEC SQL
      PREPARE MyCommand FROM 'UPDATE STATISTICS FOR TABLE PurchDB.Parts;';

or

     EXEC SQL
      EXECUTE IMMEDIATE 'UPDATE STATISTICS FOR TABLE PurchDB.Parts;';

To pass a dynamic command that cannot be completely defined at
programming time, you use a host variable declared as an array of char:

     DynamicHostVar   : packed array[2048] of char;
     .
     .
     EXECUTE IMMEDIATE :DynamicHostVar;

MPE/iX 5.0 Documentation