Database triggers.

[dmcmillian]

Hello list,

Has anyone added a TER (trigger event rule) to a native JDE OneWorld =
table such as the F4301 Purchase
Order Header? I have an application where this would work great, but I =
am cautious about using=20
the trigger feature because it might be a performance issue or might not =
be stable in OneWorld.

I would appreciate it if anyone who has any thoughts on this could share =
them with me.

Thanks very much.

Danny McMillian
AS/400 XE SP 15=20

 

[Xe_na_thanks]

Danny

They have given me nothing but grief so I don't use them, I use database
triggers from either Oracle or AS400 instead.

Regards,

Adrian.





Xe SP15 Update1 applied AS400 V4R4 DB2, World A73 Cum 11 00X2

 

[Larry_Jones]

Just a side note: JDE now uses TER under XE. In fact, F4301 already has a trigger setup! (as does Sales Orders also)

Larry Jones
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[david_mallory]

We have used Oracle triggers. We had a bunch of them on F0911 gen ledger,
but they caused a medium performance hit so we removed some of them. For PO
headers, unless you have a giant Purchasing group and a zillion
requisitioners, I imagine they do not write so many reqs and POs in a day
that the performance hit writing to F4301 would be a big deal. I would try
using a database trigger.

Dave Mallory Denver Water OW 7332 SP15.1 Oracle 8.1634 NT 4.0

 

[Zoltan_Gyimesi]

Hi Danny,

Although I never used TER still now (will in the near future) but my colleague have done with succes, mainly to delete records in a custom child Tag Table.

As far as I know, OW use TERs for many tables, at least Currency triggers. Check your b7/pathcode/source folder filtering for "F*.C" to see, how many and which OW tables have triggers in the shipped OW.
Our counter is 259 tables (including our customs but they aren't too many). I suppose (hope?) they sould be work stable.

I suppose, performing something in TER results better performance than performing the same in the APPLs and UBEs and BSFNs.

I am uninformed about AS400 specific issues, because all platforms are Intel and Alpha here.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[dmcmillian]

Thanks Zoltan.

Danny.

----- Original Message -----
From: "Zoltan_Gyimesi" <[email protected]>
To: <[email protected]>
Sent: Thursday, August 16, 2001 1:03 PM
Subject: Re: Database triggers.


colleague have done with succes, mainly to delete records in a custom child
Tag Table.
Check your b7/pathcode/source folder filtering for "F*.C" to see, how many
and which OW tables have triggers in the shipped OW.
many). I suppose (hope?) they sould be work stable.
performing the same in the APPLs and UBEs and BSFNs.
Intel and Alpha here.
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
8917

 

[devimisra]

I have used triggers successfully in Cum 1. The only problem I can think of
is deployment. Update packages do not seem to carry the changes to
server(AS/400), and we have to rely on full package for deployment. I do not
know if the problem exist in Xe.



Devi Misra
Richmond VA.

 

[dmcmillian]

----- Original Message -----
From: "Xe_na_thanks" <[email protected]>
To: <[email protected]>
Sent: Thursday, August 16, 2001 8:23 AM
Subject: Re: Database triggers.


http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
18861

 

[Zoltan_Gyimesi]

Danny,

As far as I know, our CNC guys had the similar problem on XE as Devi reported, struggling to deploy TERs with Update package.
Unfortunaley I can not ask them to confirm it because all of them are already out of office or on holiday.

I think, the best practice to build and deploy Full Package when you make/change TERs.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)