View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 02:42 PM
Sam Moore
 
Posts: n/a
Default Generated value in a column

I have a table that contains the following columns BIRTH_DATE and AGE.
The table contains other columns too. The AGE column is populated as
zero when the table is loaded. Is there a way DB2 can derive the age
based on the birth date and current date and put the value in the AGE
column whenever someone tries to access the column AGE?
Reply With Quote