There are three methods of using SQL to access a HiRDB database:

• By coding SQL statements in a UAP and executing the executable-format file of the UAP (a UAP in which SQL statements are directly coded is called an embedded SQL UAP)
• By using the HiRDB SQL Executer to execute SQL statements interactively
• By using the database definition utility (pddef) to execute SQL statements

You can create a UAP to reference table data when complex operations or computational processing are required, or you can execute SQL statements interactively in order to perform simple data operations.

The following lists the high-level languages that can be used to code embedded UAPs:

• C
• C++
• COBOL
• OOCOBOL