× 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

There are non-numeric code points that have 'F' in the first nybble, so
the test might have to be expanded to exclude (include?) A to F.

Vern

Elvis Budimlic wrote:
Not overly ugly for a one time thing... perhaps:

select rrn(a),hex(myField), f1 from myLib/myFile a
where substring(hex(myField), 1,1) <> 'F' and
substring(hex(myField), 3,1) <> 'F' and
substring(hex(myField), 5,1) <> 'F' and
substring(hex(myField), 7,1) <> 'F' and
substring(hex(myField), 9,1) <> 'F' and

It's beginning to look a tad expensive. Wouldn't a simple RPG-based
solution serve the need better and more efficiently?

Regards,
Dennis

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Genius is one per cent inspiration and ninety-nine per cent perspiration."
-- Thomas Edison


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