|
BPCS slaps us silly. RI will not work on a multi member file. I think BPCS creates all of their files with *NOMAX members. (Yet another reason to avoid multiple members. Think, if you didn't have it could you live without them? The answer is yes.) So any RI I create against a BPCS file I use a trigger. Besides, triggers allow you to do something like: MASTER file RecordCode KEY 'Z' 123 'A' 234 'A' 345 With a trigger you can allow a Before Insert to omit if the master is flagged with a 'Z'. This happens alot in the 'real' world. For example, I terminate an employee. I do not want to eliminate any history, but I don't want to be able to generate new checks for this person. Second example. I have a vendor who has fallen into disfavor. I don't want to lose any history, but I don't want any new purchases from them. Rob Berendt ================== Remember the Cole! "Graap, Ken" <keg@exchange.gasco To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com> .com> cc: Sent by: Subject: RE: Triggers or Journals? owner-midrange-l@mi drange.com 03/29/01 12:09 PM Please respond to MIDRANGE-L >IBM is going gung ho with triggers for editing on their files. I wonder why there isn't a broader use of DB Referential Constraints in DB2/400? Moving editing logic into the database and out of application code sure seems to make sense. Is anyone moving their DB editing logic into DB2/400 via DB Constraints? Kenneth **************************************** Kenneth E. Graap IBM Certified Specialist AS/400e Professional System Administrator NW Natural (Gas Services) keg@nwnatural.com Phone: 503-226-4211 x5537 FAX: 603-849-0591 **************************************** -----Original Message----- From: rob@dekko.com [mailto:rob@dekko.com] Sent: Thursday, March 29, 2001 7:35 AM To: MIDRANGE-L@midrange.com Subject: RE: Triggers or Journals? IBM is going gung ho with triggers for editing on their files. New files from IBM have been known to have triggers on them for editing purposes. Makes sense to me. When you can maintain a file with utilities, programs, web, client server, ... why copy the editing routines all over the place? Rob Berendt ================== Remember the Cole! +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.