Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59

    Unanswered: what is the maximum length of IN predicate

    Hi,
    I am accessing the database through java and I have a very long parameter value for the IN clause. ( 256 characters)

    Select A from B where C IN (a,b,c,d,e,f,g,..........256charaters long)
    It always gives me a String data right truncation.

    Is tehre anyway i can increase this maximum length?

    Database : DB2
    Version : 7.2.X

    Any info is greatly appreciated

    Cheers
    brat

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Unhappy

    It's quite common to encounter a 256-character string limit in database products. But before jumping to the conclusion that such a limit exists here I'd take a very, very close look at the actual string which is being presented. A single misplaced quote... etc. Make sure you don't have a '"Doh!" problem.'
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    59

    Thumbs up

    Originally posted by sundialsvcs
    It's quite common to encounter a 256-character string limit in database products. But before jumping to the conclusion that such a limit exists here I'd take a very, very close look at the actual string which is being presented. A single misplaced quote... etc. Make sure you don't have a '"Doh!" problem.'
    Dead on target mate.... there was a problem with the string. Thanks a lot..Appreciate it..

Posting Permissions

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