RC/Query : Navigate quickly between panels when displaying a table list.
search cancel

RC/Query : Navigate quickly between panels when displaying a table list.

book

Article ID: 9514

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

Trying to navigate quickly between panels in RC/Query. When displaying a table list (DB2 Object T, Option L), how to display the tablespace or database associated with the table?



Environment

Release: R20
Component: RCQ

Resolution

Upward and downward navigation is available within the DB2 hierarchy. The navigating method to do this is with the line commands.

 

To move DOWN the hierarchy the commands are one or two characters. This is because the line commands are modifying the original T/L(Table/List) command.

RQTL   20.0   --------------- RC/Q Table List --------------- yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

 DB2 Object ===> T                       Option  ===> L    Where => N
Table Name ===> TBEMP                 > Creator ===> authid                >
  Qualifier ===> *                     > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: ssid ----------authid -          LINE 1 OF 1    >
CMD      TABLE NAME         CREATOR  DATABASE TBLSPACE COL_CNT  NUMBER OF ROWS
C_______ TBEMP             authid  DBCORP   TSEMP          7             N/A

Press enter after entering "C" in the CMD column...

RQTC   20.0   ---------- RC/Q Table Column Inquiry ---------- yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

 DB2 Object ===> T                       Option  ===> C    Where => N
Table Name ===> TBEMP                 > Creator ===> authid                >
  Qualifier ===> *                     > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: ssid LVL: 01 -authid -          LINE 1 OF 8    >
CMD      TABLE NAME         CREATOR  COLUMN NAME  COLTYPE   LENGTH N   COLNO
________ TBEMP             authid
________                             EMPNO        CHAR           6 N       1
________                             FIRST_NAME   CHAR          50 N       2
________                             MIDDLE_NAME  CHAR          50 N       3
________                             LAST_NAME    CHAR          50 N       4
________                             WORK_GROUP   CHAR           6 Y       5
________                             PHONE_NO     CHAR          10 Y       6
________                             SEX          CHAR           1 N       7

When a C (column) is entered next to a table name on the CMD line, its changing the original command from T/L to T/C and it uses the table name from the line on which the command was issued to display the list of columns.

PF3 back to the table list...

When navigation back UP the hierarchy is required, enter a complete command; the DB2 object plus the Option. For example, to display the tablespace list, enter TS, a space, and then the option L next to the table on the CMD line. RC/Query then completes the process by using the tablespace name associated with the table on the CMD line entry.

RQTL   20.0   --------------- RC/Q Table List --------------- yyyy/mm/dd hh:mm
 COMMAND ===>                                                  SCROLL ===> CSR

  DB2 Object ===> T                       Option  ===> L    Where => N
Table Name ===> TBEMP                 > Creator ===> authid                >
   Qualifier ===> *                     > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: ssid ----------authid -          LINE 1 OF 1    >
 CMD      TABLE NAME         CREATOR  DATABASE TBLSPACE COL_CNT  NUMBER OF ROWS
TS L____ TBEMP             authid  DBCORP   TSEMP          7             N/A

Enter...

RQTSL  20.0   ------------ RC/Q Table Space List ------------ yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

 DB2 Object ===> TS                      Option  ===> L    Where => N
Table Space ===> TSEMP                 > Creator ===> *                      >
  Data Base ===> DBCORP                > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: ssid  LVL: 01 -authid -          LINE 1 OF 1    >
CMD      NAME     CREATOR  DATABASE  PART BPOOL     DBID  OBID  PSID
________ TSEMP   authid  DBCORP       4 BP0       4922     5     6
******************************* BOTTOM OF DATA ********************************

Entering a ? on the CMD line will display the options that are available for upward and downward navigation.

 

Another way to navigate up the levels is with the PATH command. 

Assume that the screen is the TABLE/COLUMN display from above. The navigation went from TABLE/LIST to TABLE/COLUMN.

The PATH command entered in the COMMAND LINE thus : COMMAND ===> PATH

PTLINE2 --------------- Stored Report Selection -------------- yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

  S LVL:           OBJECT  OPTION   ITEM NAME          CREATOR   WHERE
_ 01           - T       C        TBEMP              authid   N
_ 00           - T       L        TBEMP              authid   N

An "S" entered on the T/L line in the 'S' column or level 00 goes back to that report:

PTLINE2 --------------- Stored Report Selection -------------- yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

  S LVL:           OBJECT  OPTION   ITEM NAME          CREATOR   WHERE
_ 01           - T       C        TBEMP              authid   N
S 00           - T       L        TBEMP              authid   N

Enter...

RQTL   20.0   --------------- RC/Q Table List --------------- yyyy/mm/dd hh:mm
 COMMAND ===>                                                  SCROLL ===> CSR

  DB2 Object ===> T                       Option  ===> L    Where => N
Table Name ===> TBEMP                 > Creator ===> authid                >
   Qualifier ===> *                     > N/A     ===> *                      >
Loc: LOCAL ---------- SSID: ssid ----------authid -          LINE 1 OF 1    >
 CMD      TABLE NAME         CREATOR  DATABASE TBLSPACE COL_CNT  NUMBER OF ROWS
________ TBEMP            authid  DBCORP   TSEMP          7             N/A

If the hierarchy was begun at the Database level and stopped at the index level the PATH command would display something like this:

PTLINE2 --------------- Stored Report Selection -------------- yyyy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

  S LVL:           OBJECT  OPTION   ITEM NAME          CREATOR   WHERE
_ 03           - T       I        TBEMP             authid   N
_ 02           - TS      T        TSEMP             authid N
_ 01           - DB      TS       DBCORP             authid N
_ 00           - DB      L        DBCORP             authid N


 

 

 

 

Additional Information

Line Commands

Line Command Processing Considerations

The help text for the PATH command:

COMMAND     : PATH

DESCRIPTION : The "PATH" command displays the path from the current report back
              to the original report. This allows you to quickly select a
              report from a listing and re-review it, determine which reports
              will display when you backtrack through the reports, and re-
              display a report without re-generating it.

SYNTAX      : PATH