If you want to know the names and descriptions of all the columns in a particular table, you view the DIRECTORY OF TABLES, point the cursor to a table name, and press the PF key called DISPLAY COLUMNS to see a panel as shown following:
Sample COLUMN DISPLAY (DQB20)
=> Place the cursor on the desired name and press the appropriate PFkey. --------------------------------------------------------------------------DQB20 DATAQUERY: COLUMN DISPLAY DICTIONARY DATABASE ID: 189 ------------------------------------------------------------------------------- TABLE NAME: CA-ACCTS-TBL DB NAME: ACT DB ID: 010 ------------------------------------------------------------------------------- COLUMN NAME | DESCRIPTION ------------------------------------------------------------------------------- CUST-ID | CUSTOMER ID NUMBER BILL-DT | BILLING DATE BILL-YR | BILLING YEAR BILL-MO | BILLING MONTH BILL-DAY | BILLING DAY OF WEEK ORD-AMT | ORDER AMOUNT FRT-AMT | FREIGHT AMOUNT DISC-AMT | DISCOUNT AMOUNT CUST-NO | CUSTOMER NUMBER | | | - LAST PAGE ------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> NOT USED <PF4> NOT USED <PF5> EXTENDED DEFN <PF6> TEXT <PF7> BACKWARD <PF8> FORWARD
|
Copyright © 2014 CA.
All rights reserved.
|
|