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;