Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: how to read values in field clob.

    Hi colleagues,
    Somebody can say me how to read a values in a table with data type clob?
    Thank you for advanced.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    select myclob from mytable

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    excuse me before i do not explain me fine, i have the followind table.
    create table xxxxx
    ( aaa int,
    bbb char(20),
    ccc varchar(200),
    ddd clob(5000))

    I need read the values in field ddd. How to do this operation?

    Thank you for you help.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    select ddd from xxxxx

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Let me ask a different question: why do you believe that a CLOB is different from a VARCHAR? From an application's point of view, both are strings of characters and you deal with them in the same way.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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