WebDocs Home | Show Navigation Hide Navigation

Creating SQL Connection Programs

With SQL Connection, Synergy DBL programs can run 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