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?
Release: R20
Component: RCQ
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
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