I'm not sure in what version it was implemented, but you *can* have triggers on non-SQL files in Universe (and have been able to for some time now). Cataloging the subroutine so that it can be called as a trigger is somewhat weird, and not well documented, but if you search the list archives, you should be able to find what you need to know. We have been using this in production for a couple of years.
Actually installing the trigger uses the same syntax as for an SQL table. I believe that this works on all hashed file types (i.e. anything but type 1 or 19 files). Geoff [EMAIL PROTECTED] wrote: >Hi Marcos, > >Universe seems hellbent on invoking the entire SQL system in order to put a simple trigger on a file. UniData is MUCH more forgiving in that regard. > >With Universe, I have had a certain amount of success making what I call 'indexed subroutines' where by an index on a file calls a virtual Dictionary subroutine which does, in fact, operate as a rudimentary trigger. You CANNOT affect data going to the actual file record update as you might with an actual trigger, but you can write information to a tracking database and then I have a background phantom in operation which manages email distribution from the triggered events and what not. I *could* even write back to the originating file record that initiated the trigger -- I've closed off the mortal embrace between phantom and virtual subroutine -- but that will always have a lag time between the actual record update event and the final conclusion of the trigger, so I would not consider it a particularly clean solution for true database triggering. It does work well as a tracking and reporting system, though. > >Trey > > > -------------- Original message ---------------------- >From: Marcos Fogaga <[EMAIL PROTECTED]> > > >>Hi, >> >> >> >>It is possible create a trigger (subroutine) for a pick file (non SQL >>table)? >> >>On D3 we have CALLX, is there a feature like this in Universe? >> >> >> >>Thanks in advance. >> >> >> >>Best Regards, >> >> >> >>Marcos Fogaca >> >>Integral Sistemas >> >>Sao Paulo / Brazil >>------- >>u2-users mailing list >>[email protected] >>To unsubscribe please visit http://listserver.u2ug.org/ >> >> >------- >u2-users mailing list >[email protected] >To unsubscribe please visit http://listserver.u2ug.org/ > > > > -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
