×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.



  1.  Home
  2. RPG400-L
  3. January 2008

RE: CPF4328 Member CACUB3CUP not journaled to journal *N.

Thank you to everyone who replied. Some really good suggestions.

The article Robert suggested had the answer on page 4:
"If you select the update or delete rule of a referential constraint to
have a value other than *RESTRICT, both the parent and dependent files
must be journaled.".

I had NO ACTION for both the ON UPDATE and ON DELETE rules.
It's a subtle difference between NO ACTION and RESTRICT.
Once I changed them to RESTRICT, it is working fine.

So thank you again!!

Glenn Gundermann
ggundermann@xxxxxx
(647) 272-3295


Glenn,
Check this article http://www.itjungle.com/mpo/mpo031303-story02.html
Especially the section "Some Rules for Using Referential Integrity
Constraints"

Robert A. Rogerson

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.