LOBLEN primary command

The LOBLEN primary command displays the length for a LOB (BLOB, CLOB or DBCLOB) column. 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. The length for the LOB column at the cursor position is displayed.

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

Syntax

Figure 1. In SNGL display format

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

1  LOBLEN
1  #n row
1  row #n
#n
A valid reference. The data type for #n must be BLOB, 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