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. |
|
Copyright © 2013 CA.
All rights reserved.
|
|