You are not missing anything ... except you are running the statement with
STRSQL!
STRSQL is stabilized since Release V4R5 (not a typo!) all newer enhancements
in SQL are NOT supported.
Install ACS (IBM i Access Client Solutions) and run the SQL Statement with
"Run SQL Scripts"
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Monty
G. James
Sent: Friday, 1 March 2024 16:21
To: 'midrange-l@xxxxxxxxxxxxxxxxxx' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: IFS_OBJECT_STATISTIC what am I dong wrong/missing
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.
midrange.com
