Previous Topic: KEY DISPLAYNext Topic: Introducing CA Dataquery Query Creation


EXTENDED KEY DISPLAY

If you want to see the extended definition for keys (in DQL Mode), you can display a panel as shown following:

Sample EXTENDED KEY DISPLAY (DQB60)

 =>  PLACE THE CURSOR ON THE DESIRED NAME AND PRESS THE APPROPRIATE PFKEY.  --------------------------------------------------------------------------DQB60  DATAQUERY:  EXTENDED KEY DISPLAY      TABLE:PERSONNEL  -------------------------------------------------------------------------------    KEY NAME                             |        COLUMN NAMES                     | TYPE  LEN    DEC  SIGN   OCC  CLASS  -------------------------------------  |---------------------------------------    NUMBER                               |  EMPLOYEE NUMBER KEY        NUMBER                           |  N       5         N        1   S    STATE-ZIP                            |  EMPLOYEE STATE ZIP KEY        STATE-ADDRESS                    |  C       2         N        1   S        ZIP-CODE-LOC                     |  C       5         N        1   S                                         |                                         |                                         |                                         |                                         |                                         |                                         |                                         |  - LAST PAGE -------------------------------------------------------------------  <PF1>  HELP          <PF2>  RETURN     <PF3> DISPLAY COLUMNS <PF4> NOT USED  <PF5>  NOT USED      <PF6>  TEXT       <PF7> BACKWARD        <PF8> FORWARD

Note that you can press additional PF keys to see a TEXT display or a column display for any key or column.