Re: Issue with regular expressions.

On 7/25/2023 12:33 PM, Jason Olson wrote:

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.

Without seeing code or regex, my guess is that there's a fixed length variable (trailing blanks) being assigned to a varchar. FWIW, this works for me on 7.4:

dcl-s ip varchar(64) inz('192.168.140.230');
dcl-s ip_regex varchar(128) inz;
dcl-s count int(10) inz;

ip_regex = '^(?:(?:25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])\.){3}+
(?:25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9][0-9]|[0-9])$';

exec sql
select
REGEXP_COUNT('192.168.140.230', :ip_regex)
into :count from SYSIBM.SYSDUMMY1;

dump(a) 'literal';

exec sql
select
REGEXP_COUNT(:ip, :ip_regex)
into :count from SYSIBM.SYSDUMMY1;

dump(a) 'variable';

*inlr = *on;