In addition to bypassing SQL Parser and SQL interpretation, solidDB® SA also allows limited execution of SQL statements directly using function SaSQLExecDirect.
The SaSQLExecDirect function is designed to execute simple SQL statements, such as CREATE TABLE. If you need to retrieve SQL result sets, you must use another programming interface such as ODBC.
Example
/* Create test table and index. */ SaSQLExecDirect(scon, "CREATE TABLE SAEXAMPLE(INTC INTEGER, CHARC VARCHAR)"); SaSQLExecDirect(scon, "CREATE INDEX SAEXAMPLE_I1 ON SAEXAMPLE (CHARC)");