× 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. July 2009

Re: Finding invalid data in zoned numeric fields with SQL

On Mon, Jul 13, 2009 at 1:21 PM, Jim Essinger<dilbernator@xxxxxxxxx> wrote:
Yes - I believe the software vendor did create this with DDS, and even
thought it is defined as Zoned, it somehow allows invalid data to be added
to the file in 4 fields.

That's working as designed.

With a DDS defined file, the data is not validated when written but
instead whenever it is read.

On the other hand, a data written into an file defined with SQL DDL is
validated when written.

Note this means if you have a file that is read more than written, you
can save soem CPU cycles by defining the file with DDL.

Charles

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.