× 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.



"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 07/19/2016
01:59:42 PM:
Second, can somebody explain TRGLIB? So far, all I have been able to
find is something from 2012, in an IBM DeveloperWorks forum, that sheds
some light on this, but not a whole lot.

In the case where the trigger program is a CL or RPG program, no
separate object is required for the trigger definition. It is simply a
table row entry. However, an SQL trigger can be a native compound SQL
statement similar to a stored procedure. As such, the native SQL code is
"compiled" into a separate (C) program object and, hence, needs a library
in which to store said object. But, a qualified library name was not used
because an SQL trigger name is a variable-length string that can be so
long that a separate parameter was chosen, instead.

Sincerely,

Dave Clark

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.