Embedded SQL using Mertech Drivers

Mertech has a comprehensive SQL command set for embedding SQL statements. Starting with v12.1, Mertech also provides a class layer that allows you to use the embedded SQL (ESQL) classes available in the DAW SQL.pkg. The Mertech class layer adds full compatibility for the DAW SQL.pkg classes and provides an ESQL interface that some may find easier to use.

Mertech’s new class layer implements a unified ESQL interface across all of our drivers, allowing for applications to migrate to database servers DAW does not support, such as MySQL and PostgreSQL.

With a few simple code changes, you can use your existing VDF applications with Mertech's new ESQL interface.

1. Add a Use statement to include the Flex2SQL.pkg.
   The Flex2SQL.pkg is automatically copied to your VDF development environment when you install v12.1
   
   
2. Modify your connection method.
   The DAW drivers use an interface that supports connection strings. Mertech's drivers connect in a manner in which connection strings are not needed. Because of this, the connection method in your code may need to be modified.  

DataFlex code example (code changes shown in red):

Use Flex2SQL.pkg // replaces the DAW SQL.pkg
Handle hSQLConnect hStmt
String val
Get SQLConnect of _embsqlghoSQLHandleMngr "SQL_DRV" "(localdb)v11.0" to      hSQLConnect
Set SQLDatabase of hSQLConnect to "MTSample"
Get SQLOpen of hSQLConnect to hStmt
Send SQLSetProcedureName of hStmt "testfunc"
Send SQLSetNextArgument of hStmt 80
Send SQLCall of hStmt
Get SQLReturnValue of hStmt to val
Send FreeHandle of hStmt