How to add two coloumns of table inm DB2
Posted: Fri Aug 01, 2008 2:16 pm
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
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