Editor Basics

Display Format

There are two basic display formats: columnar and sidelabels. Columnar format is the default. In columnar format, headings and data are displayed in vertical columns. The columnar format allows you to look at multiple rows in a table and join to related tables. The following figure shows data from the ORDERS table displayed in columnar format.

-------------------------------- Optim: Edit ----------------------------------
COMMAND ===>                                                  SCROLL ===> PAGE 

Cmd F == Table: FOPDEMO.ORDERS(T1) ========================= 1 OF 79 === MORE>>
       ORDER_ID CUST_ID ORDER_DATE ORDER_TIME FREIGHT_CHARGES ORDER_SALESMAN 
       -------- ------- ---------- ---------- --------------- -------------- 
 *** *********************************** TOP **********************************
 ___        10   00049  1998-01-26  14.22.31        9.22          WE005 
 ___        23   00068  1998-01-26  08.16.09       14.80          WE005 
 ___       130   00049  1998-01-26  10.12.39        7.02          WE005 
 ___       143   00069  1998-01-26  14.22.31       17.60          WE012 
 ___       160   00067  1998-01-26  10.22.31       13.82          WE012 
 ___       176   00069  1998-01-26  11.28.30       11.88          WE012 
 ___       207   00067  1997-02-24  12.12.51       48.52          WE012 
 ___       222   00068  1998-01-26  14.22.31       19.05          WE005 
 ___       278   00068  1998-01-26  11.51.47       21.97          WE005 
 ___       373   00049  1998-01-26  12.08.13       27.97          WE005 
 ___       404   00049  1998-01-26  12.18.58       23.37          WE005 
 ___       658   00069  1998-01-26  10.00.28       13.33          WE012 
 ___       686   00067  1998-01-26  12.08.13       21.97          WE012 
 ___       752   00069  1998-01-26  09.11.47       33.99          WE012 
 ___       817   00069  1998-01-26  16.00.00        7.85          WE012 

Screen Elements

The screen elements in the columnar and sidelabels display formats are the same; only the positioning is different. For more information about sidelabels format, see Wide Data Displays. The elements are:

Command

Prompt for primary commands. See Available Commands for a summary of available primary commands.

Line Cmd

Area for line commands. The label is Cmd in columnar format and LineCmd in sidelabels format.

See Available Commands for a summary of available line commands.

Status Flag

Identifies the status of the row. The possible values are:

D

Deleted row.

E

Row contains an error.

I

Inserted row.

U

Updated row.

A blank indicates that the displayed data is unchanged from its original fetched state.

In columnar format, the label is F. In sidelabels format, the label is Row Status.

Table Name

Fully-qualified name of the table or view. The value is truncated if the Creator ID and Table Name are more than 22 characters. This value is inserted by ACCESS and cannot be edited.

Short Name

An identifier showing the level for each table (Tn) or view (Vn). In a multi-table display, T1 identifies the first level, T2, the second, etc. Several tables may be joined at any level except T1. Tables joined at the same level (i.e., stacked tables) have the same level identifier. (See Special Considerations for Multi-way Joins for additional information about multi-way joins and stacked tables.) The level identifier can be substituted for the table name as a command operand.

x OF y

The position of the first data row on the screen (x) in relation to the total number of displayed rows (y) from the table.

Horizontal Scroll Indicator

Indicator, in the form MORE or <<MORE, that additional data can be displayed by scrolling LEFT or RIGHT. (See Scroll for additional information about scrolling.)

Column Headings

By default, Access uses the DB2^® column names as headings for the rows from each table. Alternatively, you can use the DB2 column labels as headings, as described in the Common Elements Manual, section for managing the data display.

Column Count

(Displayed in sidelabels format only.) Indicates the current position of the first column within the set of columns.