SQL support

SQL programming
Covers topics about interacting with a database server using SQL.

Database connections
Explains how to manage database connections in a program.

Database transactions
Database transaction concepts and handling.

Static SQL statements
Describes static SQL statements supported in the language.

Dynamic SQL management
Explains how to execute and manage SQL statements at runtime.

Result set processing
Shows how to fetch rows from a database query.

Positioned updates/deletes
Describes row modification based on a FOR UPDATE cursor.

SQL insert cursors
Explains how to insert a log of rows into a table efficiently.

SQL load and unload
Describes the instructions to export/import information from/to a database.

SQL adaptation guides
This section includes the SQL adaptation guides for various supported databases. The adaptation guides provide you with information about installation and configuration requirements, as well as details on what is and is not supported when using database-specific SQL.