This study assumes that you have the QSQL library in your system, and a basic working knowledge of this product as well.
The QSQL library is not mandatory once the programs using SQL queries are put into production.
See the following IBM manuals for more details on the SQL software product (SC21-9608-0 for the reference manual, SC21-9609-0 for the programmer's guide).
The use of SQL in Adelia consists in using Adelia SQL instructions or integrating SQL instructions (with the SQL syntax), in interactive and batch models.
Therefore, any of the data-handling SQL instructions can be used.