Re: Stored Procedures/Triggers Standards?

In article <C6sx0r.sA@cbfsb.cb.att.com> nh@cbnewsg.cb.att.com (nicholas.hounsome) writes: > 2. How similar are different vendors implemenations given that (as far as > I know) they have not been put into the ANSI standard? What I realy want to > know here is whether we could keep most of our code the same if we wanted > to use either of Informix or Oracle using embedded SQL. It may be tempting to use triggers in some situations. However, I would advice you to avoid them if you can. Since very few vendors comply with the X/Open SQL standards (which are relatively "simple"), you can expect that it will take quite long before a significant number of vendors comply with standards for triggers and SP. We also advice people to be careful to use stored procedures. But since it is easier to "get out of" stored procedures, they don't make you as dependent on one vendor as triggers do. ================================================================ Nils Hagner, marketing manager MIMER Software AB, P.O. Box 1713, S-751 47 Uppsala, SWEDEN Phone: +46 18 18 50 00, Fax: +46 18 18 51 00 Email: nisse@mimer.se