Programming embedded SQL applications

Programming embedded SQL applications involves the same steps required to assemble an application in your host programming language.

Once you determine that embedded SQL is the appropriate API to meet your programming needs, and after you design your embedded SQL application, you will be ready to program an embedded SQL application.

Prerequisites:

Choose whether to use static or dynamic SQL statements
Design of an embedded SQL application

Programming embedded SQL applications consists of the following sub-tasks:

Including the required header files
Choosing a supported embedded SQL programming language
Declaring host variables for representing values to be included in SQL statements
Connecting to a data source
Executing SQL statements
Handling SQL errors and warnings related to SQL statement execution
Disconnecting from the data source

Once you have a complete embedded SQL application you'll be ready to compile and run your application: Building embedded SQL applications.