|
I'm trying to use regular expressions to validate that an IP address is valid.
When I do this,
exec sql
select
REGEXP_COUNT('192.168.140.230', :ip_regex)
into :count from SYSIBM.SYSDUMMY1;
It's working fine. However, if I use a variable to hold the IP address it fails. I've tried char fields and varchar fields and it always fails. This is on 7.3.
This mailing list archive is Copyright 1997-2026 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.
midrange.com
