Results 1 to 4 of 4

Thread: blob

  1. #1
    Join Date
    Dec 2007
    Posts
    7

    Unanswered: blob

    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!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2007
    Posts
    7
    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

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by ravi30
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •