Error while executing sql statement

db2

Solution

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

eg :

`'12'=12`

Problem

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==,`

Original source