MIDRANGE dot COM Mailing List Archive



MIDRANGE-L » January 2013

RE: SQL is numeric function



Gives an example of how to extend your rpg subprocedure to become a UDF
and then be used by SQL but the rpg may be a bit simplistic. For example,
123.45 would not be numeric. Just adding a period to the check string may
not be sufficient for the example another poster gave: 123.156.121.45 or
some such thing. That's 'numeric' enough for an IP address but not
numeric for mathematical functions.


Rob Berendt





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

This mailing list archive is Copyright 1997-2013 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