Handling special characters in an ifs file name

Rob Berendt <robertowenberendt@xxxxxxxxx>
1:56 PM (0 minutes ago)
to Midrange
Resending, with a subject line this time.

I used the IFS_OBJECT_STATISTICS to generate a list of temporary files
throughout the system I want to delete.
create table rob.tmpfiles as(
select *
from table (qsys2.ifs_object_statistics(
START_PATH_NAME *=>* '/',
SUBTREE_DIRECTORIES *=>* 'YES'
, OBJECT_TYPE_LIST *=>* '*NOQDLS *NOQOPT *NOQSYS'
))
WHERE PATH_NAME LIKE '%.TMP'
OR PATH_NAME LIKE '%.tmp'
OR PATH_NAME like 'heapdump%'
OR PATH_NAME like 'javacore%'
OR PATH_NAME like 'Snap%')
WITH DATA;

I verified the contents are what I want.

I'm trying to pass the column containing the file name to a command to
delete it
select PATH_NAME, qcmdexc('DEL OBJLNK(' *concat* '''' *concat* PATH_NAME
*concat* '''' *concat* ')')
from rob.tmpfiles

Generally it works. Out of about 6k files I'm down to 200 left. These
have characters like an apostrophe or a parenthesis in the file name. I'm
getting tired of playing silly games to count apostrophes and whatnot.

How do I blast these?

Is there any use for the columns FILE_IDENTIFIER_NUMBER,
GENERATION_IDENTIFIER, FILE_SYSTEM_IDENTIFIER, FILE_IDENTIFIER? Can they
be used somehow, instead of PATH_NAME to delete these files?