LOBEDIT primary command

The LOBEDIT primary command starts a new FM/Db2 LOB editor session, in edit mode, for a LOB (CLOB or DBCLOB) column. Edit of a BLOB is not supported. The Db2® object being processed must contain a LOB column.

The command is cursor sensitive. Type the command, move the cursor to the LOB column of interest and press Enter. A File Manager/Db2 LOB editor session, in edit mode, for the LOB column at the cursor position is displayed.

Note: Do not use the SAVE command in a LOBEDIT session because the LOB data will not be updated in the Db2 table.

The command can also be issued without cursor positioning, in which case parameters may be required:

Syntax

Figure 1. In SNGL display format

1  LOBEDIT?  #n
Figure 2. In TABL display format

1  LOBEDIT
1  #n row
1  row #n
#n
A valid reference. The data type for #n must be a CLOB or DBCLOB. #n can be omitted when the Db2® object contains only one LOB column. If #n is omitted when the Db2® object contains multiple LOB columns, FM/Db2 searches for the first selected LOB column, starting at #1.
row
A number that identifies a row in the editor session. A row number should not be specified when the command is issued in SNGL mode, the command applies to the currently displayed row.

Availability