Re: IFS_OBJECT_STATISTIC what am I dong wrong/missing

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

If you want to see why the tool makes a difference, go into Run SQL Scripts
and select Insert from Examples and look at:  IBM i Services, PTF, Group
PTF currency and they show an example of how to modify a statement from
iACS to that crappy STRSQL.  Basically it has to do with some variable
types.

On Fri, Mar 1, 2024 at 10:36 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> Because of your choice of tool?
> Try it in iACS Run SQL Scripts instead of STRSQL.
>
> On Fri, Mar 1, 2024 at 10:21 AM Monty G. James <monty.james@xxxxxxxxxxxxxx>
> wrote:
>
> > When I do:
> > SELECT PATH_NAME FROM TABLE
> > (QSYS2.IFS_OBJECT_STATISTICS(START_PATH_NAME =>
> > '/tmp/.com_ibm_tools_attach',
> > SUBTREE_DIRECTORIES => 'YES',
> > OBJECT_TYPE_LIST => '*DIR'))
> >
> > I get this:
> > PATH_NAME
> > *POINTER
> > *POINTER
> > *POINTER
> > *POINTER
> > *POINTER
> > *POINTER
> > *POINTER
> > *POINTER
> >
> > When I do:
> > WRKLNK OBJ('/tmp/.com_ibm_tools_attach/*') DETAIL(*EXTENDED) DSPOPT(*ALL)
> >
> > I get this:
> > Object link            Type
> > .                             DIR
> > ..                            DIR
> > 132                       DIR
> > 133                       DIR
> > 135                       DIR
> > 136                       DIR
> > 137                       DIR
> > 15                         DIR
> > 7100                    DIR
> >
> > Why am I getting *POINTER instead of the directory name?
> >
> > Thanks,
> > Monty
> >
> > ________________________________
> >
> > This email message, including any attachment(s) is for the sole use of
> > the intended recipient(s) and may contain confidential information. Any
> > unauthorized review, use, disclosure or distribution is strictly
> > prohibited. If you are not the intended recipient, please immediately
> > contact the sender by email.
> >
> > --
> > 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.