Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Red face Unanswered: how about search Key word for clob field ?

    How about used UCASE or TRANSLATE function for Clob Field (>5M)
    (TRANSLATE (CLOB(MORE_INFO) like '%KEYWORD%') ) --> Error 22001: [IBM][CLI Driver][DB2/NT] SQL0433N Value '{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttb l{\f0\fnil\' is too long"

    can't you help me.
    Last edited by anfan2000; 09-13-06 at 04:18.

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    The TRANSLATE funtion states:
    The arguments may be either strings of data type CHAR or VARCHAR, or graphic strings of data type GRAPHIC or VARGRAPHIC. They may not have data type LONG VARCHAR, LONG VARGRAPHIC, BLOB, CLOB, or DBCLOB.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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