Stored Programs/Triggers
Is it possible to query the entire database to determine if there are triggers or stored 4gl programs in the tables? I see in DBAccess I can check for triggers on individual tables. Thanks!
On Tue, 13 May 2003 10:17:13 -0500, "Impy" <impy2101@yahoo.com> wrote: >Is it possible to query the entire database to determine if there are >triggers or stored 4gl programs in the tables? I see in DBAccess I can check >for triggers on individual tables. >Thanks! > Triggers can be found in systriggers and systrigbody. Stored 4gl programs???????
"John Carlson" <john_carlson@whsmithusa.com> wrote in message news:pr42cvgh79s416pq1qgltq6rqhpdp6qfv6@4ax.com... > On Tue, 13 May 2003 10:17:13 -0500, "Impy" <impy2101@yahoo.com> wrote: > > >Is it possible to query the entire database to determine if there are > >triggers or stored 4gl programs in the tables? I see in DBAccess I can check > >for triggers on individual tables. > >Thanks! > > > > Triggers can be found in systriggers and systrigbody. > Stored 4gl programs??????? I'm working on an upgrade project - it was a question asked of me: "Does the client have any 4gl stored programs?"
On Tue, 13 May 2003 10:57:56 -0500, "Impy" <impy2101@yahoo.com> wrote: >"John Carlson" <john_carlson@whsmithusa.com> wrote in message >news:pr42cvgh79s416pq1qgltq6rqhpdp6qfv6@4ax.com... >> On Tue, 13 May 2003 10:17:13 -0500, "Impy" <impy2101@yahoo.com> wrote: >> >> >Is it possible to query the entire database to determine if there are >> >triggers or stored 4gl programs in the tables? I see in DBAccess I can >check >> >for triggers on individual tables. >> >Thanks! >> > >> >> Triggers can be found in systriggers and systrigbody. >> Stored 4gl programs??????? >I'm working on an upgrade project - it was a question asked of me: "Does the >client have any 4gl stored programs?" > I thought I had heard and seen a lot, but I've missed this one . . .. what is a 4gl stored program? Or should I say, what is 'their' definition?
"John Carlson" <john_carlson@whsmithusa.com> wrote in message news:4f52cvc3cmbdjmhne57v2nlm2ba80vmf07@4ax.com... > On Tue, 13 May 2003 10:57:56 -0500, "Impy" <impy2101@yahoo.com> wrote: > > >"John Carlson" <john_carlson@whsmithusa.com> wrote in message > >news:pr42cvgh79s416pq1qgltq6rqhpdp6qfv6@4ax.com... > >> On Tue, 13 May 2003 10:17:13 -0500, "Impy" <impy2101@yahoo.com> wrote: > >> > >> >Is it possible to query the entire database to determine if there are > >> >triggers or stored 4gl programs in the tables? I see in DBAccess I can > >check > >> >for triggers on individual tables. > >> >Thanks! > >> > > >> > >> Triggers can be found in systriggers and systrigbody. > >> Stored 4gl programs??????? > >I'm working on an upgrade project - it was a question asked of me: "Does the > >client have any 4gl stored programs?" > > > I thought I had heard and seen a lot, but I've missed this one . . .. > what is a 4gl stored program? Or should I say, what is 'their' > definition? Definition? Don't be ridiculous - they didn't provide one. I'm assuming it's some kind of customization for the program. This is 'their' program I'm upgrading (using 'their' checklist)...I would think 'they' would have records and documentation if they had provided us with customizations - however, any ineptitude on 'their' part never surprises me. Thanks for your answer on the triggers! Wynne