MVSFORUMS.com

sharada

Hi All,

I got a situation where I need to update the month and year part of a column which is defined as DATE, leaving the days part alone.
Is this possible???

kolusu · Posted: Mon May 08, 2006 11:07 am Post subject:

sharada,

Assuming that your table has a column named Date_col which needs to be updated. It stores the date in the format CCYY-MM-DD, the following sql will update the date to 2005-01-dd for all the rows of the table.

Cogito-Ergo-Sum · Posted: Mon May 08, 2006 11:34 am Post subject:

Kolusu,
I did not test...but, do we really need the CHAR function...?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

kolusu · Posted: Mon May 08, 2006 11:48 am Post subject:

Cogito-Ergo-Sum · Posted: Mon May 08, 2006 11:24 pm Post subject:

Constants.

When I ran

kolusu · Posted: Tue May 09, 2006 8:23 am Post subject:

Cogito-Ergo-Sum,

A Column defined as Date actually stores the data in Character format. And as you have noticed a constant supplied within Quotes is treated as a Varchar data and Db2 add 2 extra bytes for the length. So it is necessary to use the CHAR function so that we don't have the extra 2 bytes.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

srini_igsi · Posted: Fri May 12, 2006 4:58 am Post subject:

Hi Colusu,

Here what is 'CONCAT' and whats its role? Is this a DB2 Keyword?
_________________
Thanks,
-Srini

kolusu · Posted: Fri May 12, 2006 7:32 am Post subject:

srini_igsi,

Srini,

Concat function combines two string arguments. It is a function in almost all the relation databases.

Check this link for a detailed explanation of the function concat

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.14?SHELF=&DT=20010718164132&CASE=

Hope this helps...

Cheers

Kolusu

Ps: I would really appreciate if you can spell my name correctly
_________________
Kolusu
www.linkedin.com/in/kolusu