Following is a typical public query directory selected from the DIRECTORY SELECTION panel.
=> Place the cursor on the desired name and press the appropriate PFkey ------------------------------------------------------------------------DQA30 DATAQUERY: DIRECTORY OF QUERIES START WITH: _______________ ---------------------------------------------------------------------------- QUERY NAME | TYPE | USED | DESCRIPTION ---------------------------------------------------------------------------- CREATEAPPLICANT | QUERY | | CREATEORG | QUERY | 09/19/10 | CREATESTAFF | QUERY | 03/13/11 | CREATETABLE | QUERY | 08/15/10 | DEMO | QUERY | 05/01/11 | LIST EMPLOYEES, YEARS SERVICE DEMO_0501 | QUERY | 05/01/11 | LIST EMPLOYEES, YEARS SERVICE DEMO2 | QUERY | 04/28/11 | LIST EMPLOYEES, YEARS SERVICE DROPTABLE2 | QUERY | 10/11/10 | D1 | QUERY | 01/17/11 | LIST EMPLOYEES, YEARS SERVICE INSERTSTAFF | QUERY | | SELECTTABLENAME | QUERY | 07/15/10 | TSI01002 | QUERY | 03/16/10 | SQL - NESTED SELECT MGRS TSI01009 | QUERY | 10/17/10 | SQL - CASES 1-93 ------------------------------------------------------------------------------- <PF1> HELP <PF2> SIGN-OFF <PF3> EXECUTE <PF4> SUBMIT <PF5> NOT USED <PF6> NOT USED <PF7> BACKWARD <PF8> FORWARD <PF9> SUBMIT <PF10> EXTENDED DEF <PF11> LEFT <PF12> RIGHT
When you select a library directory from the DIRECTORY SELECTION panel, CA Dataquery presents the upper-left corner of the directory listing. Additional information appears to the right of the current screen. Move the information into view by pressing <PF12> RIGHT. To scroll back to the left, press <PF11> LEFT. When you scroll left and right, the panel number in the upper-right corner of the panel changes. In long listings, use the START WITH field to enter all or part of an item name to move an item to the top of the display.
See the CA Dataquery Reference Guide for operational instructions for each panel by number. An arrow on either or both sides of the lower division line indicates that you may scroll in the designated direction.
Example
Here is an example of the panel you see when you press <PF12> RIGHT to scroll to the right.
=> Place the cursor on the desired name and press the appropriate PFkey ------------------------------------------------------------------------DQAA0 DATAQUERY: DIRECTORY OF QUERIES START WITH: _______________ ---------------------------------------------------------------------------- QUERY NAME | TYPE | STATUS | AUTHOR ----------------------------------------------------------------------------- CREATEAPPLICANT | QUERY | PUBLIC | HOLUB CREATEORG | QUERY | PUBLIC | HOLUB CREATESTAFF | QUERY | PUBLIC | HOLUB CREATETABLE | QUERY | PUBLIC | WHITMAN DEMO | QUERY | PUBLIC | DEMO DEMO-0501 | QUERY | PUBLIC | NEWMAN DEMO2 | QUERY | PUBLIC | NEWMAN DROPTABLE2 | QUERY | PUBLIC | NEWMAN D1 | QUERY | PUBLIC | KDSQL INSERTSTAFF | QUERY | PUBLIC | HOLUB INSSTAFF | QUERY | PUBLIC | HOLUB SBM-DIALOG1 | DIALOG | PUBLIC | LITA SELECTTABLENAME | QUERY | PUBLIC | WHITMAN <== ---------------------------------------------------------------------- ==> <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> EDIT <PF5> NOT USED <PF6> DELETE <PF7> BACKWARD <PF8> FORWARD <PF9> SUBMIT <PF10> EXTENDED DEF <PF11> LEFT <PF12> RIGHT
Here is an example of what you see when you move the last columns into view.
=> Place the cursor on the desired name and press the appropriate PFkey ------------------------------------------------------------------------DQAB0 DATAQUERY: DIRECTORY OF QUERIES START WITH: _______________ ---------------------------------------------------------------------------- QUERY NAME | TYPE | GROUPS ---------------------------------------------------------------------------- CREATEAPPLICANT | QUERY | SYSPROG CREATEORG | QUERY | SYSPROG CREATESTAFF | QUERY | SYSPROG CREATETABLE | QUERY | SYSPROG DEMO | QUERY | DEMO-0501 | QUERY | DEMO2 | QUERY | DROPTABLE2 | QUERY | ADMIN D1 | QUERY | INSERTSTAFF | QUERY | ADMIN INSSTAFF | QUERY | ADMIN SBM-DIALOG1 | DIALOG | ADMIN SELECTTABLENAME | QUERY | GENERAL <== -------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> EXECUTE <PF4> EDIT <PF5> NOT USED <PF6> DELETE <PF7> BACKWARD <PF8> FORWARD <PF9> SUBMIT <PF10> EXTENDED DEF <PF11> LEFT <PF12> NOT USED
Description The following are panel column names and their contents.
Alphabetical listing of all accessible query and dialog names.
Specifies whether this is a query or dialog.
Date this query or dialog was last accessed.
Description of this query or dialog as entered during creation.
Public or Private status assigned to this query or dialog.
Name of the author of this query or dialog.
Group to which query is assigned, if any. No entry means the query is not restricted to a group.
CA Dataquery uses directory panels to allow you to perform several functions by PF key selection. The PF keys for all directories of queries and dialogs are the same. For detailed instructions on using any directory, see your CA Dataquery Reference Guide.
Operation
|
PF Key |
Cursor |
Result |
|---|---|---|
|
<PF1> HELP |
Any position |
Help panel appears |
|
<PF2> RETURN |
Any position |
Previous panel appears |
|
<PF3> EXECUTE |
Any query name |
CA Dataquery executes this query or dialog |
|
<PF4> EDIT |
Any query name |
Display that query, or dialog for review, copying or changing, if allowed |
|
<PF6> DELETE |
Any private query or dialog name |
CA Dataquery removes that query or dialog |
|
<PF7> BACKWARD |
Any position |
Display previous queries or dialogs, if any |
|
<PF8> FORWARD |
Any position |
Display more queries and dialogs, if any |
|
<PF9> SUBMIT |
Any query or dialog name |
CA Dataquery displays the Batch Execution panel |
|
<PF10> EXTENDED DEF |
Any query or dialog name |
CA Dataquery displays the extended attributes of the selected item |
|
<PF11> LEFT |
Any position |
Scroll left |
|
<PF12> RIGHT |
Any position |
Scroll right |
|
Copyright © 2014 CA.
All rights reserved.
|
|