BLOBDUMP
Go Up to isql Command Reference
Places the contents of a BLOB column in a named file for reading or editing.
BLOBDUMP blob_id filename;
| Argument | Description |
|---|---|
|
<blob_id> |
System-assigned hexadecimal identifier, made up of two hexadecimal numbers separated by a colon (:)
|
|
<filename> |
Name of the file into which to place Blob contents |
Description: BLOBDUMP stores Blob data identified by <blob_id> in the file specified by <filename>. Because binary files cannot be displayed, BLOBDUMP is useful for viewing or editing binary data. BLOBDUMP is also useful for saving blocks of text (Blob data) to a file.
To determine the blob_id to supply in the BLOBDUMP statement, issue any SELECT statement that selects a column of Blob data. When the table’s columns appear, any Blob columns contain hexadecimal Blob IDs. The display of Blob output can be controlled using SET BLOBDISPLAY.
Example: Suppose that Blob ID 58:c59 refers to graphical data in JPEG format. To place this Blob data into a graphics file named picture.jpg, enter:
BLOBDUMP 58:c59 picture.jpg;