How to create a column who value is derived from two other columns ??

ranjir75 · #1 (**permalink**) 04-05-04, 09:36

If there are two columns in table, named column A and column B, Can we add one more column C to the table which would always have sum of A and B. If value of A or B is changed, the value of A + B should automaticaly get reflected in varlable C.

Please, let me know what are the ways in which this can be accomplished in DB2.

J Petruk · #2 (**permalink**) 04-05-04, 09:43

Quote:

Originally posted by ranjir75
If there are two columns in table, named column A and column B, Can we add one more column C to the table which would always have sum of A and B. If value of A or B is changed, the value of A + B should automaticaly get reflected in varlable C.

Please, let me know what are the ways in which this can be accomplished in DB2.

Triggers.

ARWinner · #3 (**permalink**) 04-05-04, 10:49

You can also use:

ALTER TABLE TableA add column COL_C INTEGER generated always as (COL_A + COL_B).

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech