Is their any Function to convert datatype like in Sql Server there is function called CAST in which we can convert datatypes. Like for e.g

E.g
select distinct cast(year(sta_dt) as varchar(05))+'-'+ cast(year(end_dt) as varchar(05)) as yr_expn from co_mast which returns year 2005-2006.

Which command we Need to ISSUE in DB2.

Hi,
there is also CAST function in DB2. Sintax: CAST (column_name AS data_type).
Hope this helps,
Grofaty

Yes, DB2 has the CAST function. Read the SQL Reference manual on its proper usage.

Andy

Thanks for prompt reply again..

But unfortunately it's not working. For e.g

if i have quries for "select cast(year(sta_dt) as varchar(20)) from co_mast"
it gives me error. How should i use this command in DB2???

Regards,
Tushar

What is the datatype of sta_dt?

Andy

Thanks andy for reply.

Data type is Date

Regards,
Tushar

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.

Andy

THanks andy.

It worked ..but now problem is that suppose i want to create string. for e.g.

select cast(year(sta_dt) as char(20))+'-'+cast(year(end_dt) as char(20)) from co_mast it gives me error!! what is synatax to combine to string like in above example..

Regards,
Tushar

Use || instead of + to concat.

Andy

Thanks Andy It Worked. Thanks a lot.

Hi
Suppose i have query like this

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.

Regards,
Tushar

Tushar,
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.

Andy