Great feedback Susan. Perhaps you should make some suggests to IBM U2 team for a few "tweaks" to UV triggers?
I guess this highlights too different schools of thought. The "quick and dirty" world of PICK/U2 and the "by-the-book" of relational databases. Each has pros and cons. Where the two meet, we have a somewhat unhappy union - at times...such as it. You can have half-baked index-based triggers (I-types indexed and when "updated" call BASIC subroutines - all well documented by others in the past) or "true" triggers like UV offers. Originally, UV triggers were only available with SQL-ized UV tables only. Lots of power, but so much over-head too and some annoying constraints (in some respects). UniVerse BASIC has the ICHECK() function, but this is for pre-write data+key validation against SQL integrity constraints only. Perhaps IBM can make a enhancement to allow validation against the trigger as well (perhaps it does now days, I can't check at the moment). Regards, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Wednesday, 3 December 2008 12:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe triggers (still more) Thanks to the folks who gave me info on Unidata triggers. I've had those implemented for years and they do work very simply and well. Universe has been a whole different ballgame. <SNIPPED> Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Complete software development life-cycle management for U2. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/