Dynamic SQL Execution

MySQL style support for executing Dynamic SQL Statements using PREPARE, EXECUTE and DEALLOCATE PREPARE statements.
Following are few samples on Dynamic SQL execution capabilities.
SQL Statement as a String Literal:

SQL Statement as a User Variable:

Create SQL statement at Run-Time:

Download latest development release from http://www.effiproz.com/downloads/EffiProz_db_1_0_dev.zip