Previous Topic: System management commandsNext Topic: Report formatting commands


Data Retrieval Commands

You can retrieve data from the database with these data retrieval commands. The commands available for data retrieval are presented in the table below. For the syntax and syntax rules of these commands, see the alphabetical listing of commands in num=6.Commands and Syntax.

Use ...

To ...

DEFINE PATH

Place CA OLQ in database path definition mode.

END PATH

Terminate path definition mode.

EXECUTE PATH

Execute the retrieval commands specified in the database path definition and build a report file of retrieved records.

FIND/GET logical record

Retrieve records by using DBA-defined paths through the database.

FIND/GET MOST RECENT

Retrieve the current of record type for the specified record name.

FIND/GET OWNER WITHIN SET

Retrieve the owner of a database set occurrence.

FIND/GET PHYSICAL SEQUENTIAL

Retrieve records based on their physical position in a database area.

FIND/GET using STORAGE KEY

Retrieve records based on their CALC-key or database-key value.

FIND/GET WITHIN DBKEYLIST

Retrieve records based on the results of previous retrieval commands.

FIND/GET WITHIN index SET

Retrieve records by using the name of an index set and the index-sort-key fields specified in the WHERE clause.

FIND/GET WITHIN SET

Retrieve records based on their membership in a database set.

FIND/GET WITHIN SET using SORTKEY

Retrieve member records in sorted database sets based on a specified sort key.

REPEAT for each of the above FIND/GET commands

Duplicate an immediately preceding FIND/GET command.

SELECT

Retrieve information using the SELECT command.

SHOW PATH

Display the current path.

For more information:

Commands and Syntax