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
Using cursors with SQL Connection
Data conversion when binding and defining
Understanding updates and locking
Understanding transactions and autocommit