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

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..