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