15.145 SEM_APIS.SEM_SQL_COMPILE
Format
SEM_APIS.SEM_SQL_COMPILE;
Description
Compiles SQL inserted into RDF$S2S_SQL$
table to be used by
SEM_SQL SQL Macro.
Parameters
Usage Notes
Examples
The following example compiles SQL inserted into RDF$S2S_SQL$
table.
INSERT INTO RDF$S2S_SQL$ SELECT s2s_sql FROM sql_tab WHERE id=1;
EXECUTE SEM_APIS.SEM_SQL_COMPILE;
SELECT count(s), count(o) FROM SEM_SQL();
Parent topic: SEM_APIS Package Subprograms