Results 1 to 4 of 4

Thread: inserting clobs

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Unanswered: inserting clobs

    I was tring to insert a clob object into DB2 v 7.2 from my web site by executing a INSERT statement and running into a problem when I execute.

    It appears that the my SQL statment is getting Truncated, or is reaching some size limit...

    How could I check this? or is there a better way of insterting CLOB into a remote db?

    Thanks Inadvance

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    There's a limit of 32K bytes on the length of string literals - may be this is your problem. You can try to work around this limitation by concatenating together several literal strings, each of them being shorter than 32K. However, you'll hit the 64K limit on the length of a SQL statement.

    A proper way to work with LOBs depends on the programming language you use. In java, you would use PreparedStatement.setCharacterStream()

  3. #3
    Join Date
    Jul 2004
    Posts
    2
    I am current using Microsofts ADO object. Would anybody have some sample code that does this java evquivalent?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

Posting Permissions

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