How to navigate quickly between panels in RC/Query when I am displaying a table list?.

Document ID:  TEC449128
Last Modified Date:  07/04/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA RC/Query for DB2 for z/OS
  • CA Plan Analyzer for DB2 for z/OS

Components

  • CA RC/Query for DB2 for z/OS:RCQ
Introduction:

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

Instructions:

Upward and downward navigation is available within the DB2 hierarchy. The trick to navigating RC/Query are the line commands. To go DOWN the hierarchy the commands are one or two characters. This is because the line commands are modifying the original T/L command. So when you enter a C (column) next to a table name on the CMD line, you are 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.

When you want to navigate UP the hierarchy, you need to enter a complete command; the DB2 object plus the Option. For example, to display the tablespace details, you would enter TS, a space, and then the option D 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. Entering a ? on the CMD line will display the options that are available for upward and downward navigation.

Reference the RC/Query User Guide, Chapter 4, 'Report Line Commands' for additional information.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing