Re: Using PF constraints

[rob@xxxxxxxxx]

How do you have your database logic separate?

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




MWalter@xxxxxxxxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/29/2003 10:28 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Re: Using PF constraints



I'd love to be able to use PF constraints and triggers but it seems pretty
cumbersome to return the constraint violation messages back to the initial
caller. Especially if you have your database logic separate from the
presentation logic. If there is a tried and true method of doing this, I'd
like to know what it is.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


   
                    rob@xxxxxxxxx   
                    Sent by:                     To:     Midrange Systems 
Technical Discussion <midrange-l@xxxxxxxxxxxx>  
                    midrange-l-bounces@xx        cc:     
                    drange.com                   Subject:     Re: Using PF 
constraints 
   
   
                    04/29/2003 11:05 AM    
                    Please respond to    
                    Midrange Systems   
                    Technical Discussion    
   
   




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.


_______________________________________________
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.





_______________________________________________
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.