Re: Triggers versus UDF's

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Rob,

You're probably right, and I guess my only real problem with your example is
that the calculation of ONHAND is so simple that couldn't you could simply

create view rob/iimx as
  select iprod, (iopb + irct + iadj + iiss) as ONHAND
  from iim

with the same ability to simply change the view if the calculation changed?
Given that you can even use the CASE function to incorporate some logic in
the calculation, it would have to be a pretty complex calculation before I'd
want to replace the CREATE VIEW with creating a module, creating a service
program, creating a function, and then creating a view.

OTOH, thanks for showing the steps. I haven't run into a situation where I
could use a function yet, and when I do I'll be search the archives for your
example <grin>!

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: <rob@dekko.com>
Sent: Wednesday, February 13, 2002 8:50 AM
Subject: Re: Triggers versus UDF's


>
> So, ok, you change the logical file that calls that procedure.  Would
> probably retain record format level id.  Still no changes to any programs
> or Queries.



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com