Specifying Result Tables

You can use the SELECT statement to construct queries which specify the result table you want.

The various clauses of the SELECT statement allow you to limit the data you retrieve to only that data which is significant for your purpose.

Note: In the following examples, the SELECT statement is embedded inside a DECLARE CURSOR statement, as it would be in a COBOL program.