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