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;
|