Features and supported databases
SQL Connection features include
- record-oriented or column-oriented bulk data access.
- built-in statement caching and SQL prefetch caching.
- automatic data type conversion and binding of Synergy DBL variables with data.
- independence from Synergy DBL file I/O operations.
- support for up to seven concurrent database connections per program on UNIX and OpenVMS, and up to 100 concurrent connections per program on Windows (for multi-threading). You can open multiple databases simultaneously, and you can open the same database more than once in an application (under the same username or under a different username).
SQL Connection conforms to ANSI-standard database communication methods SQLCA and SQLDA (ANSI 89) and supports the following databases:
MySQL (version 5.1 and higher) on supported Windows, Linux, and AIX platforms
Oracle® (version 10 and higher) on all supported Windows, UNIX, and OpenVMS platforms. Use version 10.2.0.4 or higher for OCI-related fixes
- SQL Server versions that Microsoft ODBC Driver 13.1 supports—i.e., SQL Server 2008 R2 (with Service Pack 3) or higher. Microsoft ODBC Driver 13.1 (with the latest update) is the only SQL Server driver that SQL Connection supports. See SQL Server notes and examples for more information.
Synergy DBMS (version 10.3.1 and higher) on all supported Windows, UNIX, and OpenVMS platforms
(For information on supported Windows, UNIX, and OpenVMS platforms, see Requirements and Considerations.)
SQL Connection has limited support for the following database systems. Support for these databases may require assistance from Synergex Professional Services and additional support fees. Contact your Synergy/DE account manager for details.
- IBM DB2®
- Informix® on UNIX systems
- ODBC-compliant databases on Windows systems
- Oracle Rdb on OpenVMS systems
- PostgreSQL on Windows
- Sybase® on Windows and UNIX systems