I get an error message
IMPROPER USE OF LONG STRING COLUMN OR AN EXPRESSION THAT RESOLVES TO A LONG STRING KIT_STR. SQLCODE=-134, SQLSTATE=42907

when i try to the following query:

SELECT * FROM Some_table WHERE value_str = v_temp_str;

Here:
value_str is VARCHAR(1500)

Any suggestions or ideas, corrections are welcome

http://www-1.ibm.com/support/docview...id=swg1IY11811


This link describes your problem..

He basically says its a program error and such a long varchar cannot be used in joins..Any ideas from other forum members??

What DB2 version and OS are you using?

Andy

db2 os/390 7.1.2

That is what I thought. You need to post this the first time. I cannot help you as I only know DB2 for LUW.

Andy

v_temp_str ? Is this a column of the table ?

it is a string variable. Or you can assume 'abc'

Could you post us the complete scenario?

i have a table called say courselist
eachtime i assign a courseid i query my courselist table to get the courselist column information and assign the id to it which is done as follows:

SELECT count(*) into V_TEMP FROM COURSELIST WHERE COURSELIST_STR = V_COURSELIST;

using 'like' will help fix this problem

Can't you just provide us with some more information that we can actually understand what you try to do? Apparently, you have a sequence of SQL statements. Those may be inside a stored procedure or not - we don't know.

I think for DB2/zOS v7, the string comparison can only handle 255 bytes or shorter.