Rob,
Are you referring me to me saying we're not using referential integrity? Thing is, I don't want to use any totally free, totally supported, part of the OS. Actually I really do want to use it, however the reality is that doing so is going to be a big culture change. That isn't saying I'm giving up on RI completely, but I am giving up on it for this project at hand for a few reasons. Mainly I would prefer to start small with RI and learn the good and the bad about it. Some of those "bad" things simply mean that we have to adjust certain processes, and right now this project really needs to get into production as we have a lot of other projects hinging upon it. I simply don't have the time to really learn all about the ins and outs of RI at the moment. I spent enough time looking into it to realize that I really need to spend quite a bit more time learning about it.
I also didn't see my question as a "workaround" to RI, but to see if I could delete from multiple files in a single statement. I believe that question would still be valid if I was using RI - maybe the situation is unique and normally I wouldn't cascade a delete across files. In my situation a cascading delete would make sense, but I can see where it wouldn't always make sense in every file relationship.
-Kurt
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, May 22, 2013 6:19 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Delete from multiple files
I understand work arounds, sometimes. However when I hear "I want to do ... but I don't want to use this totally free, fully supported, part of the OS that doesn't conflict with any of my business rules, how do I go about doing that?" I get a little baffled.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Luis Rodriguez <luisro58@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 05/21/2013 03:08 PM
Subject: Re: SQL Delete from multiple files
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Rob,
I agree that using referential integrity would simplify the issue a lot
but, if not available, a work-around would be using a trigger. Like a RI
constraint it would be valid no matter which interface is used (DFU, RLA
program, etc.).
Regards,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
midrange.com
