Results 1 to 2 of 2

Thread: CLOB help

  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Angry Unanswered: CLOB help

    Hi
    I tried making a table
    create table test (number int, mytext clob)

    and tried inserting a tuple into it
    insert into test(number, mytext) values( 4, 'lalala')

    my problem is that it seems mytext is padded cause when I do a
    select * from test where number = 4
    I get a LOT of blank lines before it tells me there was 1 record selected.

    Can anyone help me out with this padding issue
    I dont want to use varchar because i dont know exactly how much space i'm going to need - trying to make a message board. CLOB is the closest thing i can get to a text datatype (from MySQL)

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You can use RTRIM function ...

    But, remember to increase dbm cfg UDF_MEM_SZ

    db2 update dbm cfg using UDF_MEM_SZ 1024

    1024 is just an example
    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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