Re: File information data structure via SQL

Hi John

Try and use the Object_statistics table function.

https://www.ibm.com/docs/en/i/7.5?topic=services-object-statistics-table-function



Kind regards,



Martijn van Breden

lead software architect


Hello,
I can I replace this statements with SQL in RGPLE Free ?

dcl-f envrsq01 disk usage(*input) keyed INFDS(infds);

dcl-ds infds;
library char(10) pos(93);
end-ds;

I need the library name for where the file is.

Thanks
John Slanina



--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.