zOs/SQL/EXLIKE

with d (d) as                                                           00001004
(                                                                       00002004
            select 'ab%cd_ef' from sysibm.sysDummy1                     00003004
  union all select 'ab?cd?ef' from sysibm.sysDummy1                     00004004
)                                                                       00005004
select d                                                                00006004
    , case when d like 'ab%' then 'ab% Li' else 'ab% No' end            00007004
    , case when d like 'ab\%c%f' escape '\'                             00008004
         then 'ab\%c%f Li' else 'ab\%c%f No' end                        00009004
    , case when d like 'a%\__f' escape '\'                              00009104
         then 'a%\__f Li' else 'a%\__f No' end                          00009204
    from d                                                              00009304
;xx;                                                                    00009404
select name                                                             00010000
    from sysibm.sysTables                                               00020000
    where dbName = 'DGDB9998'                                           00030001
        and   name like strip('TWK4% ')                                 00040003
    order by name                                                       00050000