Re: Triggers -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Steve

Look in the redbook for triggers, etc. There is some discussion there about save/restore of triggers, I believe - you might not need to actually create them, they might just get there. But there are some things to know about that process - I've worked with procedures and UDFs, not triggers.

Vern

-------------- Original message ----------------------
From: "Steve Landess" <sjl_abc@xxxxxxxxxxx>

Interesting coincidence, and timely question...

We are experimenting with using triggers for part of our encryption project,
by creating SQL update and insert triggers which would call a UDF or stored
procedure to perform the encryption of the field at output time.

However, when you create an SQL trigger the database manager actually
creates and compiles an ILE C program which becomes the trigger-handling
program on the file.

Please don't let it be true, but does this mean that we would need to have
the compilers on our production system in order to create the triggers?
This would violate our rules about having a compiler on the production
system/LPAR...

Regards,
Steve

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.