SET BLOBDISPLAY

Go Up to isql Command Reference

Specifies subtype of Blob data to display.

SET BLOBDISPLAY [n | ALL | OFF];

Argument	Description
<n>	Integer specifying the Blob subtype to display Use 0 for Blob data of an unknown subtype Use 1 for Blob data of a text subtype [default] Use other integer values for other subtypes
ALL	Displays Blob data of all subtypes
OFF	Turns off display of Blob data of all subtypes

Description: SET BLOBDISPLAY has the following uses:

• To display Blob data of a particular subtype, use SET BLOBDISPLAY <n>. By default, isql displays Blob data of text subtype (<n> = 1).
• To display Blob data of all subtypes, use SET BLOBDISPLAY ALL.
• To avoid displaying Blob data, use SET BLOBDISPLAY OFF. Omitting the OFF keyword has the same effect. Turn Blob display off to make output easier to read.

In any column containing Blob data, the actual data does not appear in the column. Instead, the column displays a Blob ID that represents the data. If SET BLOBDISPLAY is on, data associated with a Blob ID appears under the row containing the Blob ID. If SET BLOBDISPLAY is off, the Blob ID still appears even though its associated data does not.

SET BLOBDISPLAY has a shorthand equivalent, SET BLOB.

To determine the subtype of a BLOB column, use SHOW TABLE.

Examples: The following examples show output from the same SELECT statement. Each example uses a different SET BLOB command to affect how output appears. The first example turns off Blob display.

SET BLOB OFF;
SELECT PROJ_NAME, PROJ_DESC FROM PROJECT;

With BLOBDISPLAY OFF, the output shows only the Blob ID:

PROJ_NAME PROJ_DESC
==================== =================
Video Database 24:6
DigiPizza 24:8
AutoMap 24:a
MapBrowser port 24:c
Translator upgrade 24:3b
Marketing project 3 24:3d

The next example restores the default by setting BLOBDISPLAY to subtype 1 (text).

SET BLOB 1;
SELECT PROJ_NAME, PROJ_DESC FROM PROJECT;

Now the contents of the Blob appear below each Blob ID:

PROJ_NAME PROJ_DESC
==================== =================
Video Database 24:6
==============================================================
PROJ_DESC:
Design a video data base management system for
controlling on-demand video distribution.
PROJ_NAME PROJ_DESC
==================== =================
DigiPizza 24:8
==============================================================
PROJ_DESC:
Develop second generation digital pizza maker
with flash-bake heating element and
digital ingredient measuring system.
. . .

See Also

• BLOBDUMP