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

assuming you are meaning to "split" the path_name into "directory" and "file"

Need more time to put together, but "locate_in_string" would be an option.
https://www.ibm.com/support/pages/locateinstring-built-function

Bryan

Steve McKay wrote on 8/31/2023 2:18 PM:

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.