Varying-length columns

You can use FM/Db2 options to specify two string delimiter characters:

String delimiters: Input

For use when editing a varying-length column

String delimiters: Display

Indicates the end of a varying-length column when it is displayed

The following examples show the effect of the Remove trailing spaces option, and the use of the string delimiter character (“#” in this case), if you specify a string (for a varying-length column) in a File Manager/Db2 editor session. In the examples, > and < indicate the start and end of the data you type.

• If the Remove trailing spaces option is selected, trailing spaces are removed:

  Example string #<

  Stored as “Example string”.

• If the Remove trailing spaces option is not selected, trailing spaces are not removed:

  Example string #<

  Stored as “Example string ”.