Re: Using PF constraints

It depends on your business concerns.  Which action do you want to occur 
if you delete a customer with order history:
1)  Stop!  I thought that this was an inactive customer.
2)  Blast the orders.

If 1 is the goal then use *RESTRICT.  If 2 is the goal then use *CASCADE.

Other concerns may include what if your order history file has children 
also?  Such as order lines.  You may have to cascade them also.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Saunders, Martin P" <martin.saunders@xxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/29/2003 09:37 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Using PF constraints


Hello all,

I am canvassing for opinions on using ADDPFCST to effect data purges 
instead
of writing (comparatively) more complex RPG programs to perform this
function.  The way I see it, if we add the appropriate constraint to a
detail file which has an associated header file with a primary key and
specify 'cascading delete', deleting records from the header file will
automatically zap the associated detail records right?

Is there a good reason why I've never seen this being used?  Or is it just
the shops that I've worked with that do not think this is a useful 
feature?

Thanks in advance for your opinions.


Martin


********************************************************************************************
" This message contains information that may be privileged or confidential 
and 
is the property of the Cap Gemini Ernst & Young Group. It is intended only 
for 
the person to whom it is addressed. If you are not the intended recipient, 
you 
are not authorized to read, print, retain, copy, disseminate, distribute, 
or use 
this message or any part thereof. If you receive this message in error, 
please 
notify the sender immediately and delete all copies of this message ".
********************************************************************************************

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.