The problem is that the YEAR function returns an INT and INT is not allowed to be cast as VARCHAR (I do not know why). Anyway, you can cast it to a CHAR first, then a VARCHAR, or just CHAR if that is OK.
select * from "user" where "user"=''. wher user is the keyword in this case when i am issuing this command from command editor of DB2..its working fine but suppose i want to issue this command from front end i.e from any front end parser..its gives me error.. Can u plz help me..
Because we have used "used" keyword many times in our project.
Actually we are converting our project into DB2 from Sql serever.
So plz kindly help and oblige.
First of all, if you have a different question, you should start a new thread. You will get more help that way. I sort of understand what you want, but I want to be 100% sure, so could you post the DDL of the table/view you are querying and the exact query you want with a description of what the query is supposed to do? This will clarify thing for me.