CODEWITHSUNDEEP
db2
user197122
user197122

Reputation: 87

Error while executing sql statement

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

Upvotes: 4

Views: 339

Answers (1)

Shivam Dhabhai
Shivam Dhabhai

Reputation: 331

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

eg :

'12'=12

Upvotes: 3

Related Questions