Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Impy asked how to find triggers or stored 4gl programs across a whole database for an upgrade project. John Carlson pointed to systriggers and systrigbody for triggers and asked what a stored 4gl program is. Impy said the client's checklist gave no definition. The 4gl question was left unanswered.
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!
↪ replying to Impy
John Carlson — — source: Usenet: comp.databases.informix
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?"
↪ replying to Impy
John Carlson — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.