Creating SQL Connection Programs

With SQL Connection, Synergy DBL programs can access data in third-party databases via simple queries, multirow queries, simple atomic updates, bulk updates, inserts, and stored procedures. Programs that use SQL Connection must allocate data areas, initialize SQL Connection, make database connections, process SQL statements, and perform other operations documented in the following sections.

Writing an SQL Connection program

Function call flows

Building connect strings

Using cursors with SQL Connection

Using variables to map data

Data conversion when binding and defining

Understanding updates and locking

Understanding transactions and autocommit

Running stored procedures from SQL Connection

Optimizing your SQL code