zOs/SQL/EXPOS

with s (h, n) as
(
  select           'abcdAbcdAb', 'a' from sysibm.sysDummy1
  union all select 'abcdAbcdAb', 'c' from sysibm.sysDummy1
  union all select 'abcdAbcdAb', 'd' from sysibm.sysDummy1
  union all select 'abcdAbcdAb', 'q' from sysibm.sysDummy1
)
select locate(n, h) "locate(n, h)"
, locate_in_string(h, n) "locate_in_string(h, n)"
, locate_in_string(h, n, 5) "l_i(h, n, 5)"
, locate_in_string(h, n, 1, 2) "l_i(h, n, 1, 2)"
, substr(h, locate(n,h)+1, 10) || '|'
-- , posstr(h, n)       -- needle muss konstante sein|
, n, h
    from s