Re: OT: Was Computed columns possible in informix?

Posted in 2004

Jesus Antonio Santos Giraldo — Mon, 04 Oct 2004 14:02:46 -0500 — source: Usenet: comp.databases.informix

A trigger? Although I like the view idea more. Chucho! Captain Pedantic wrote: > "Michael Krzepkowski" <mkrzepkowski@hotmail.com> wrote in message > news:Pfg8d.199356$%S.181424@pd7tw2no... > >>sumGirl wrote: >> >>>Let's say I have two columns: AmountOne and AmountTwo. I'd like to >>>create a column that is dynamically populated called AmountCalc that >>>would subtract AmountOne from AmountTwo. Since either of the two >>>columns can change, AmountRemaining will always be correct. Is this >>>doable in IDS? I am using IDS 9.40 if that makes a difference. >>> >>>I believe in MSSQL Server there is a way to define a column to do this >>>so that you don't have to remember to manually change the >>>AmountRemaining column if one of the other two values gets changed. We >>>are trying to reproduce the same functionality in Informix. >> >>Use a view. > > > Or get the old man to do it for you, love. > > > sending to informix-list