× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2002

Re: Insure DB consistency in case of recovery

You must mean the check constraint. This is not a part of DDS. The RANGE,
COMP, and VALUES keywords do not stop you from putting invalid values into
a record with SQL. These attributes can be copied to a display file field
as a REFFLD, where the various check mechanisms can generate error messages.

At 09:28 AM 4/12/02 -0400, you wrote:
>This is an area where I am not proficient in HOW to do this, I am somewhat
>knowlegeable only in WHAT can be done.
>
>One of the nice things about DB/2 is that you can put rules in the definition
>of files, that trump 100% of your programs.
>
>For example, you could say that some specified field can never be a negative
>number.
>It does not matter who or how anything tries to make it so ... user tool,
>application software bug, it aint going to be violated.

-snip-

As an Amazon Associate we earn from qualifying purchases.

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

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