Editor Options (8 of 8) panel

Panel and field definitions

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

 LOB and XML Columns:                                                           
    Enter "/" to select option                                                  
       Show part/all data              Max characters  . . 0                       
                                                                                
 LOB Display Format:                   LOB Piece Size:                          
    Initial display format                Split LOBs into pieces using          
    3  1. Previous                        2  1. Table display size              
       2. Table                              2. Single display size             
       3. Single                             3. Manual ... 100                  

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

Show part/all data

When the Db2® object contains LOB (BLOB, CLOB or DBCLOB), or XML columns, you can display some, or possibly all of the data within those columns. The default action is not selected, in which case no data is displayed. The LOB and XML column appears in the editor as a column heading only, with no data displayed.

To display some, or possibly all, of the data in a LOB or XML column, select the option. You must also specify a maximum number of characters to displayed using the Max characters option.

Note that you can display all of the data in a LOB or XML column using the LOBBRWS, LOBVIEW, LOBEDIT, XMLBRWS, XMLVIEW and XMLEDIT editor primary commands.

Max characters

This option works in conjunction with the Show part/all data option. You can specify a value in the range 0-1000. The default is 0. When the Show part/all data option is selected, and a non-zero value is specified for the Max characters option, FM/Db2 retrieves and displays that many characters of the LOB or XML data in the editor session.

Initial Display Format

Use this section of the Editor Options panel to specify how editor panels appear at the start of a File Manager/Db2 LOB editor session. This option works with the Split LOBs into pieces using option. The default is 3 (Single). Set this option to one of the following:

1. Previous

The display format field (Format) on the LOB editor panel is pre-filled with the value specified in the previous FM/Db2 LOB editor session.

2. Table

The LOB Editor panel is displayed in TABLE display format. When this option is selected it is suggested that the Split LOBs into pieces using option be set to Table display size.

3. Single

The LOB Editor panel is displayed in SNGL display format. This is the default setting. When this option is selected it is suggested that the Split LOBs into pieces using option be set to Single display size.

Split LOBs into pieces using

This option determines the size of the pieces, when FM/Db2 displays a LOB column in the LOB editor. LOB data can be very large, and a 3270 display is not well suited to displaying large columns directly, so the LOB editor breaks the LOB column into pieces, and displays those pieces as though the LOB column was actually a table with a single varying column.

The length of the varying column is the maximum length of any piece. The default is 2 (Single display size). This option works in conjunction with the Initial Display Format option (for LOBs) as follows:

1. Table Display size

The size of each piece is approximately the same as the number of characters displayed on a single line in TABL display format. The actual number of characters displayed depends on the terminal characteristics. This may not be the best choice when processing large objects because of the large number of pieces required.

2. Single Display size

The size of each piece is approximately the same as the number of characters displayed on the terminal in SNGL display format. The actual number of characters displayed depends on the terminal characteristics. On a 24x80 terminal the value is approximately 850; on a 48x132 terminal the value is approximately 4250.

This allows large amounts of data to be displayed at one time – when compared with the Table Display size option.

Usage tip 1: Turn on the character position range indicator by issuing the CHARPOS command. This shows the starting and ending character position for each row of data on the display.

Usage tip 2: You can use the NEXT (PF11 by default) and PREVIOUS (PF10 by default) PFKeys to scroll through the LOB data. The character position range indicator values show the absolute position from the start of the LOB, rather than the relative position within each piece of the LOB.

3. Manual

You can specify your preference for the piece size by specifying '3'.

Enter your preference for piece size in the Manual input field. A value in the range 60-32760 is required. The default is 100.