PreviousDirectives and Dialects Dialog System V2.5Next

Chapter 7: Embedded SQL Applications

This chapter lists differences in OpenESQL compared to earlier Embedded SQL systems.

7.1 COBSQL

COBSQL can be used with Embedded SQL preprocessors supplied by Oracle, Sybase and Informix in the same way as it is in other MERANT products. In addition, MERANT also provides OpenESQL, which provides Embedded SQL support using ODBC. Depending on application requirements, there may be benefits in migrating to OpenESQL

This section lists differences between OpenESQL and other Embedded SQL implementations.

7.1.1 Summary of Changes

The PIC x VARYING syntax supported in Oracle's ESQL is not supported in OpenESQL.

7.2 Embedded SQL Toolkit

Embedded SQL Toolkit for Microsoft SQL Server cannot be used with Net Express. Instead you should use OpenESQL, the ODBC-based Embedded SQL support in Net Express.

This section lists differences in OpenESQL compared to Embedded SQL Toolkit for Microsoft SQL Server.

7.2.1 Summary of Changes

Compiler directives for SQL must use a new format. There is one directive SQL, which takes options equivalent to the separate directives in the Embedded SQL Toolkit. For example:

SQL(MSSQL) NOSQLDB NOSQLPASS NOSQLACCESS

becomes:

SQL(DBMAN=ODBC,TARGETDB=MSSQLSERVER,NOACCESS) 

(NODB and NOPASS are assumed by default.)

For example:

SQL(MSSQL) SQLDB(server.database)
    SQLPASS(user.pwd) SQLINIT

becomes:

SQL(DBMAN=ODBC,TARGETDB=MSSQLSERVR, DB=datasourcename.db,PASS=user.pwd,INIT=PROT)

For example:

SQL(MSSQL)SQLPROT

becomes:

SQL(DBMAN=ODBC,TARGETDB=MSSQLSERVER, INIT=PROT)

Other differences are:


Copyright © 2000 MERANT International Limited. All rights reserved.
This document and the proprietary marks and names used herein are protected by international law.

PreviousDirectives and Dialects Dialog System V2.5Next