CREATE DISTINCT TYPE IMAGE AS BLOB (10M)

CREATE DISTINCT TYPE AUDIO AS BLOB (1G)

CREATE TABLE PERSON
(SSN INTEGER NOT NULL,
NAME CHAR (30),
VOICE AUDIO,
PHOTO IMAGE)

In this code can u explain what the blob is about and also what 10m and 1g are!

A BLOB is a binary large object that is typically used to store files that contain images, audio files, etc. The 10m (10 megabytes) and 1g (1 gigabyte) are the maximum length that has been defined for those columns. A BLOB can be defined up to 2 GB, but only a 1 GB (or smaller) BLOB can be logged (via the DB2 transaction recovery log).

A CLOB is a character large object that might hold character data such as XML or a text file.

thnx marcus that was very helpful!
by the way regarding clob if we declare as clob(x). then should x be expressed in bytes or the number of characters

Should be expressed in bytes.