Re: What Programs are using my service program? (changes to a PF)

<Frank>
WOW. So simple. After 30 years of RPG coding the PF trick NEVER occurred to me. WOW only ever use lgl files. KISS, I am so stupid.
</Frank>

If you succeed to avoid RLA (SQL only access), you could enhance decoupling database implementation and programms. Using view only access, your programms don't need to know anything of your index design, you would use select * and fetch into external DS and update insert without fieldlists everywhere, with instead triggers you could even move fields around from one table to another. That's the real power of SQL (and not SQL DDL versus DDS or index size or which query engine is used or performance).

D*B