Yes, but first I have to locate them!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Tuesday, January 15, 2013 12:36 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL is numeric function

Hi again

It would be a good idea, I think, to find out why a numeric (packed?
zoned?) field has blanks.


On 1/15/2013 10:50 AM, Stone, Joel wrote:
Does Iseries SQL have a numeric test?

For example:

Runsql 'select * from ItemMaster where itemNbr is not numeric'

This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot 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 here. If you have questions about this, please contact