RE: Listing IFS objects created or changed on or after a certain date?

Use ACS (Access Client Solutions) Run SQL Script instead of STRSQL.
The PATH_NAME is a DBCLOB that cannot be displayed in STRSQL.

As a reminder: STRSQL is stabilized since Release V4R5M0 (since more than 25 years!) - Strategical Product for executing SQL Statements is ACS - Run SQL Scripts!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i

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 Steve McKay
Sent: Thursday, 31 August 2023 21:18
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Listing IFS objects created or changed on or after a certain date?

Bryan -

Is there a way to get a meaningful path and object name from your SQL?

Thanks,

Steve McKay
(205) 585-8424
samckay1@xxxxxxxxx



On Thu, Aug 31, 2023 at 1:55 PM Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

and SQL

select * from table (qsys2.ifs_object_statistics(
start_path_name => '/your/Dir',
subtree_directories => 'YES' ) )
where Create_Timestamp > current_timestamp - XX days ;


Bryan

Patrik Schindler wrote on 8/31/2023 1:21 PM:

Hello James,

Am 31.08.2023 um 19:57 schrieb James H. H. Lampert via MIDRANGE-L <

midrange-l@xxxxxxxxxxxxxxxxxx>:

Is there a way to list the objects in an IFS directory, that were

created on or after a specified date?

Yes. Use the find command.

See the -mtime parameter in the documentation.

https://man7.org/linux/man-pages/man1/find.1.html

Should work also on IBM i PASE.

:wq! PoC

--

-- .
Bryan
--
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.