DB2 graphic  QMF Version 8

Working with BLOB, CLOB, and DBCLOB data

DB2 QMF Version 8.1 can display BLOB, CLOB, and DBCLOB data and the defined length field with the new edit code 'M'. LOB data types BLOB, CLOB, and DBCLOB can now be displayed in a QMF report or table without having to be casted as VARCHAR or VARGRAPHIC data types. The size of a LOB data row ranges in size from 0 bytes to 2 GB minus one byte.

To view actual LOB data, users can modify FORM.MAIN or FORM.COLUMNS and change the column edit code to 'C' or 'CW' to display character data. The maximum horizontal width of a report is 32 KB. To display LOB data greater than 32 KB, users must specify a column wrapping edit code. If a wrapping edit code is not specified, the LOB data that does not fit within the report will not be displayed; no message will be issued.

For more information on new edit code 'M', see Specifying punctuation for the values in a column


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004