Re: Handling special characters in an ifs file name

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Now the only ones left were a small handful of directories ending with
.TMP.  That service doesn't handle directories.  But the number was small
enough I was able to handle by hand.
Thanks again.

On Fri, Oct 31, 2025 at 2:29 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> Thank you!  It appears that worked.  To verify I'm rebuilding the output
> file and that takes a spell.
>
> On Fri, Oct 31, 2025 at 2:23 PM cesco via MIDRANGE-L <
> midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> >  Rob,have you tried IFS_UNLINK directly to avoid escaping into QCMDEXC
> > and hacking with strings?
> > The thing is that IBMi supports filename with also unicode ccsid (not in
> > the content, but the name itself, there is a ccsid even at that level), so
> > you can have legitimately for example files named with chinese ideograms
> > mixed with basic latin.... in fact IFS_OBJECT_STATISTICS returns UTF8 as a
> > file name...
> >
> >
> >
> >     On Friday, October 31, 2025 at 06:58:12 PM GMT+1, Rob Berendt <
> > robertowenberendt@xxxxxxxxx> wrote:
> >
> >  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?
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.