Editor Options (3 of 8) panel

You use the Editor Options (3 of 8) panel to set your default editor options.

Note: See the description for the Editor Options (1 of 8) panel (Editor Options (1 of 8) panel) about how long any changes you make to these options last.

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)              Editor Options (3 of 8)             Global Settings

 Table Display Format:                 Prefix Area:
    Enter "/" to select option            Prefix length . . . A  (A,6,7,8,9)
    /  Show data type
    /  Show scale line                    Enter "/" to select option
    /  Show column number                 /  Display prefix area
                                             Show prefix area on the right
 Single Display Format:                      Show SQLCODE
    Enter "/" to select option
       Show data type                  Shadow Lines:
    /  Show keys, indexes                 Enter "/" to select option
       Show column number                 /  Show excluded shadow lines
       Left justify numerics              
       Show char position range




 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=PrvPage  F11=NxtPage  F12=Cancel
Table Display Format Options
Use this section of the Editor Options panel to specify the information you want displayed in table display format (TABL):
Show data type
Indicates if you want FM/Db2 to display data type information. The default is selected.
∕
Show the data type for each column displayed in table display format.

FM/Db2 displays an additional line (immediately below the line containing the column reference numbers, if displayed) showing the data type for each column.

(blank)
Do not show data type information.
Show scale line
Indicates if you want FM/Db2 to display scale line information. The default is selected.
⁄
Show a scale line for each column displayed in table display format.

The scale shows the left and right boundary of the data for the column and, for non-numeric data types, positioning information.

FM/Db2 displays the scale line immediately above the first line of data. The scale line also displays information about primary and foreign keys, and unique indexes.

(blank)
Do not show scale line information.
Show column number
Indicates if you want FM/Db2 to display column number information. The default is selected.
⁄
Show the column number (as defined in the Db2® catalog) for each column displayed in table display format.

FM/Db2 displays the column numbers immediately below the line containing the column names.

(blank)
Do not show column number information.
Prefix Area
These options controls the prefix area in a File Manager/Db2 editor session.
Prefix length
Controls the width of the prefix area in a File Manager/Db2 editor session.

The FM/Db2 editor can display a prefix area on either the left, or the right of the screen. The width of the prefix area can be 6, 7, 8 or 9 characters. The default is 6, specified by typing A in the field. You can type a different value to set the width of the prefix area to your preference. Note that the prefix area does not appear in a File Manager/Db2 browse session, and only appears in a File Manager/Db2 view or edit session when the Display prefix area option is selected. You can alter the prefix length from within an editor session using the PREFIX editor primary command.

Display prefix area
Controls whether the prefix area is displayed in a File Manager/Db2 edit or view session. The default is selected.
The FM/Db2 editor can optionally display a prefix area, where prefix commands may be entered.
⁄
Display the prefix area.
(blank)
Do not display the prefix area.

You can turn the prefix area on or off from within a File Manager/Db2 editor session (edit and view only) by issuing the PREFIX editor primary command.

Show prefix area on the right
Controls the location of the FM/Db2 editor's prefix area. The default is not selected.
The FM/Db2 editor can display the prefix area on either the left, or the right of the screen.
⁄
Display the prefix area on the right of the screen.
(blank)
Display the prefix area on the left of the screen.
Note:
  1. The prefix area does not appear in a File Manager/Db2 browse session.
  2. This option has no effect unless the Display prefix area option is selected.
  3. You can move the prefix area, from within the FM/Db2 editor, by issuing the PREFIX LEFT or PREFIX RIGHT editor primary commands.
Show SQLCODE
Controls whether the FM/Db2 editor shows the SQLCODE in the prefix area, when an insert, update, or delete operation for a row fails. The default is not selected.
FM/Db2 processes changes to data in the edit session one row at a time. If Db2® returns an error when the change is presented to Db2®, FM/Db2 shows either =ERR or an SQLCODE in the prefix area for the row.
⁄
FM/Db2 editor shows the SQLCODE in the prefix area.
(blank)
FM/Db2 editor shows the =ERR in the prefix area.
Single display Format Options
Use this section of the Editor Options panel to specify the information you want displayed in single display format (SNGL).
Show data type
Indicates if you want FM/Db2 to display data type information. The default is not selected.
⁄
Show the data type for each column displayed in single display format.

FM/Db2 displays an additional column (immediately to the right of the column containing the name of the column) showing the data type for each column.

Note: When you are displaying data in single display mode, you can toggle the display of data type information by using the TYPE primary command.
(blank)
Do not show data type information.
Show keys, indexes
Indicates if you want FM/Db2 to display information showing if a column is a part of a key or index. The default is selected.
⁄
Show an additional column, 4 characters wide, indicating if the column is part of a key or index.
Note: When you are displaying data in single display mode, you can toggle the display of index information by using the INDEXINF primary command.
(blank)
Do not show key or index information.
Show column number
Indicates if you want FM/Db2 to display column number information. The default is not selected.
⁄
Show the column number (as defined in the Db2® catalog) for each column displayed in single display format.

FM/Db2 displays an additional column (the leftmost on the panel) containing the column numbers.

Note:
  1. When you are displaying data in single display mode, you can toggle the display of column numbers by using the REFS primary command.
  2. In single display mode, when FM/Db2 displays the column number, it also displays the column heading Rdf (as the second column heading from the left). The Rdf column is unused by FM/Db2 and can be ignored.
(blank)
Do not show column number information.
Left justify numerics
Indicates if you want FM/Db2 to display numeric data left-justified, in single display format. The default is not selected.
⁄
Data for numeric columns is displayed left-justified. That is, the first characters of any numbers are shown at the extreme left of the column.
(blank)
Data for numeric columns is displayed right-justified. That is, the data is displayed so that the last character of each number is shown at the extreme right of the column.
Show char position range
Indicates that you want FM/Db2 to show the start and end character positions for long character columns, in SNGL display mode. The default is not selected.
/
When the data for a character column requires two or more rows on the SNGL display, the second and subsequent rows include a character position range, for example, ssss-nnnn. ssss is the character position of the first character shown in the row. nnnn is the character position of the last character shown in the row.
(blank)
The character position range is not shown.

You can toggle the character position on and off from within the editor using the CHARPOS editor primary command.

Show excluded shadow lines
Controls whether a shadow line, which indicates one or more excluded rows, is displayed. The default is selected.
The FM/Db2 editor allows rows to be excluded from display, using the EXCLUDE editor primary command, or the X (and its variations) editor prefix commands. Like the ISPF editor, excluded rows are shown using a shadow line. Each shadow line marks the location of one or more contiguous excluded rows. However, unlike the ISPF editor, the excluded shadow lines can be hidden from display by de-selecting this option.
⁄
Display excluded shadow lines.
(blank)
Do not display excluded shadow lines.

You can change the display status of excluded rows, from within the FM/Db2 editor, by issuing the SHADOW X OFF or SHADOW X ON commands.

Parent panels

You can go to the Editor Options (1 of 8) panel from the parent panels shown below. To go to the Editor Options (3 of 8) panel, you then press the NxtPage function key (F11) twice.

You can only display the Editor Options (3 of 8) panel if the Table/Single format, prefix area and shadow options option on the Editor Options (1 of 8) panel is selected.

Child panels

To display this panel… Use/do this
Editor Options (2 of 8) panel Press the PrvPage function key (F10)
Editor Options (4 of 8) panel Press the NxtPage function key (F11)

Related concepts

Related tasks