Page 1 of 1

How to add two coloumns of table inm DB2

Posted: Fri Aug 01, 2008 2:16 pm
by paheli
Hi

Can any one help me how to add 2 coloumns in the table having two differnt data types and giving the result to third field

for ex: 01 Date_field pic X(10)
01 Col_A Smallint

find the blow commend

COALESCE(CAST(PROG_END_DT+GRACE_PRD_CT AS CHAR(10)),'N/A')
AS GRACE_PRD_CT

with this you can add/substract fields having same datatypes.

Is any other way to do this?

regards,
paheli