Re: Historical data; how?

No problem. You save the old value in the history.

Alan Gutierrez wrote:

> Anton Versteeg wrote:
>
> > Perhaps the following: Create a history table that contains all the columns
> > of the table you want keep a history of. Make the columns nullable. Then
> > create a trigger that is invoked after an update and that inserts the old
> > values into the history table. If a column didn't change then a NULL is
> > inserted.
>
> What if the column is changed to NULL?
>
> Alan Gutierrez - ajglist_at_izzy.net

--
Anton Versteeg
DB2 Specialist
IBM Netherlands