How to add two coloumns of table inm DB2

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
paheli
Member
Posts: 6
Joined: Tue Jul 01, 2008 10:10 pm

How to add two coloumns of table inm DB2

Post by paheli » 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

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others