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