DB2 BLOB

DB2 BLOB Knowledge centre link

From the IBM Knowledge centre guide :

BLOB or BINARY LARGE OBJECT(integer [K | M | G])

For a binary large object string of the specified maximum length in bytes.

The length may be in the range of 1 byte to 2 147 483 647 bytes.

If integer by itself is specified, that is the maximum length.

If integer K (in either upper- or lowercase) is specified, the maximum length is 1 024 times integer. The maximum value for integer is 2 097 152.

If integer M is specified, the maximum length is 1 048 576 times integer. The maximum value for integer is 2 048.

If integer G is specified, the maximum length is 1 073 741 824 times integer. The maximum value for integer is 2.

If a multiple of K, M or G that calculates out to 2 147 483 648 is specified, the actual value used is 2 147 483 647 (or 2 gigabytes minus 1 byte), which is the maximum length for a LOB column.

If the length specification is omitted, a length of 1 048 576 (1 megabyte) is assumed.

Any number of spaces is allowed between the integer and K, M, or G, and a space is not required. For example, all of the following are valid:

   BLOB(50K)    BLOB(50 K)    BLOB (50   K)