Debugging › Using the CA OLQ Menu Facility

Using the CA OLQ Menu Facility

During the debugging phase of program development, you may need to determine if your application accessed the proper record occurrences or that database modifications were actually applied. You can use the CA OLQ menu facility to help you accomplish these tasks.

The CA OLQ menu facility can perform the following functions:

• Check the sequence of records retrieved by your program
• Test database navigation logic
• Confirm database access and modification

Retrieving Database Records

To retrieve database records, perform the following steps after signing on to the CA OLQ menu facility:

1. On the MENU screen, choose the RECORD option.
2. On the SIGNON screen, indicate the appropriate subschema.
3. On the RECORD SELECT screen, indicate which database records or logical record you want to retrieve.
4. On the FIELD SELECT screen, indicate which fields in the previously specified database records or logical record you want to display; optionally, specify selection criteria.
5. Press Enter. CA OLQ automatically generates retrieval paths and performs the database access.
6. Press Enter again. CA OLQ displays the retrieved data.

Note: The sequence listed above is the default sequence for the RECORD option. You need only press Enter after each step to continue to the next screen.

Storing a CA OLQ qfile

If you will be using the CA OLQ menu facility to perform the same database access repeatedly, you might want to store the logic in an qfile. To create an qfile, perform the following steps:

1. Perform steps 1 through 6 listed above.
2. On the MENU screen, select the EXPRESS ROUTINE option.
3. On the EXPRESS ROUTINE screen, specify the create option and a name.

Executing a CA OLQ qfile

To execute an qfile, perform the following steps:

1. On the MENU screen, select the EXPRESS ROUTINE option.
2. On the EXPRESS ROUTINE screen, specify the execute option and an qfile name.

For more information, see CA OLQ User Guide.