Error while executing sql statement

Question

I am using IBM RAD. I am executing following query.

Conn.prepareStatement("update UPLOAD set STATUS='Decrypted' WHERE PATH ='"+path+"'");

the datatype of PATH in DB2 is VARCHAR.

i am getting following error

SQLCODE=-401,SQLSTATE=42818,SQLERRMC==,

someone has edited your ques, I want to know if WHERE PATH ='"+path+"'" is what you entered, before edit it seemed something like : WHERE PATH =""+path+"" — Deepanshu Goyal
– Deepanshu Goyal, Commented Apr 11, 2013 at 9:02

glenatron · Accepted Answer · 2014-01-07 12:48:24Z

3

The error message means that you are comparing different data type.

eg :

'12'=12

glenatron

11.4k14 gold badges68 silver badges122 bronze badges

answered Apr 11, 2013 at 9:05

Shivam Dhabhai

3313 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

i am comparing string with varchar in db2.

Are you sure its a VARCHAR or a "LONG VARCHAR",The error can occur due "LONG VARCHAR".