Editor Options (5 of 8) panel

Panel and field definitions

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

 Varying Length Columns:
    Enter "/" to select option         String Delimiters:
   /  Disable input delimiter            Input . . . . . . . #
   /  Show end of string                 Display . . . . . . <
   /  Remove trailing spaces

 Columns that allow Null Values:
    Enter "/" to select option         Null Column Indicators:
       Convert spaces to Db2 null         Input . . . . . . . @
                                          Display . . . . . .  

 Zoned Timestamp Columns:   
    Enter "/" to select option          
    /  Auto-size display width 




 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=PrvPage  F12=Cancel

Disable input delimiter

This option is used to disable processing for the Input string delimiter. By default this option is not selected. When a change is made to a varying field, FM/Db2 scans the entire varying field from left to right, looking for the first occurrence of the Input string delimiter character. If an occurrence is found, the field is truncated at the character before the location of the Input string delimiter. The default is not selected.

Consider disabling the Input string delimiter when:

• The Db2® object being processed contains VARCHAR fields that cannot be displayed in full, without scrolling. In this situation a change to the field may trigger silent truncation when the input string delimiter is present in a part of the field that is not currently visible on the display.
• A VARCHAR field is used to store data other than readable text, for example binary data, or data that has an internal format. In this situation the data may contain a character that matches the input string delimiter character, leading to unwanted truncation if the data in that field is changed.

Show end of string

This option only applies to the processing of varying-length (VARCHAR) input fields. The default is selected. Specifies if the end of a varying-length string is to be indicated using the delimiter specified in the String delimiters: Display option.

⁄

Show the end of a varying-length string using the delimiter specified in the String delimiters: Display option. If the string is of maximum length, the delimiter character is not shown.

(blank)

Do not show the end of a varying-length string.

Remove trailing spaces

This option only applies to the processing of varying-length (VARCHAR) input fields. The default is selected. When you enter a value that is less than the maximum length for the column, determines if FM/Db2 removes trailing spaces:

⁄

Remove trailing spaces and store the specified value using the minimum length string.

(blank)

Do not remove trailing spaces.

String Delimiters

These options control the end of string delimiter when entering and displaying data in a varying column.

Input

This option only applies to the processing of varying-length (VARCHAR) input fields.

For input, FM/Db2 sets the end-of-string delimiter character to this value. If you enter data that requires one or more trailing spaces in a varying-length field, you can use this option to provide a character of your choice to indicate the end of the string. The default value is the number sign (#).

Valid values: any character.

Display

This option only applies to the processing of varying-length (VARCHAR) input fields. FM/Db2 sets the end-of-string delimiter character, for display, to a this value. If you have also selected Show end of string, FM/Db2 displays the value in the field, terminated with the delimiter character you have selected. If the column is of maximum length, the delimiter character is not shown. The default value is the less than sign (<).

Valid values: any character.

Convert spaces to Db2® null

When any column that allows null values is changed so that it contains only spaces, the value of the column is set to null.

If the column is defined as NOT NULL, the column remains unchanged. The default is not selected.

Null Column Indicators

These options allow the specification of characters to represent the Db2® null value when entering and displaying data.

Input

A single character which, when entered in the first byte of an input field, causes FM/Db2 to update the value for the column to NULL. The default value is the at symbol (@).

Valid values: any character

If the column allows null values, when you enter this character in the first byte of the input field, FM/Db2 updates the value for the column to NULL. Any non-blank character following the indicator invalidates the action.

If the column is defined as NOT NULL, FM/Db2 treats the character in the same way as any other input character.

Display

A single character indicating that the column contains a null value (as opposed to, for example, blanks). The default value is the underscore character _.

Valid values: any character

Auto-size display width

An option that modifies the default display width for applicable columns in TABL display mode. The option applies to zoned timestamp columns only. The default is selected.

This option is only applicable when a Db2® system that supports zoned timestamp data types is connected. Zoned timestamps were first included with Db2® version 10.

/

Allows FM/Db2 to automatically adjust the display width for zoned timestamp columns to that needed to display the data.

(blank)

FM/Db2 shows zoned timestamp columns with a field width in the range 147 - 160 characters. Most of the data displayed will be blank, because the maximum required display width for a zoned timestamp excluding the use of exits and field procs is 39 characters.