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

This thread ...


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