Access Relational Databases

SQL Connection is a direct Structured Query Language (SQL) API that enables you to write database-independent, SQL-based applications that access data in a variety of Relational Database Management Systems (RDBMSs).

---

SQL Connection Features

• Ability to access relational databases, such as Oracle and SQL Server, from Synergy applications.
• Ability to combine, compare, calculate, store, transact, commit, rollback, and perform all other standard SQL functions.
• Conformance with ANSI-standard database communication methods: SQLCA and SQLDA (ANSI 89).
• Example programs that demonstrate how to use the SQL Connection functions.
• Extensive error reporting and operation logging.
• Optimized data access with features such as the ability to reuse cursors, built-in statement caching, stored procedures, and SQL prefetching.
• Database independence—the same Synergy code can access multiple databases.
• Automatic data-type conversion.
• Binding of Synergy DBL variables with database variables.
• Ability to open up to seven concurrent database channels, multiple databases simultaneously, and the same database more than once in an application.
• Ability to configure network communication with username and password encryption, settings to adjust network traffic, read and write timeouts, and communication port number setting.
• Access to local or remote data on Windows, Linux/Unix, and OpenVMS systems.

SQL Connection fully supports access to the following database systems:

• Synergy DBMS
• Oracle®
• Microsoft® SQL Server
• MySQL

Support for the following databases may require assistance from Synergex Professional Services:

• Oracle Rdb
• Sybase®
• Informix®
• ODBC-compliant databases