Hi all, I'm new to this forum, I apologize in advance for my poor english.
In order to manage our IBM i system better, I already use some of the new SQL function introduced in the latest technlogy updates, as in https://www.ibm.com/support/pages/node/1119123
In particular, I often use the OBJECT_STATISTICS(), which is very useful, so I built some utilities that make use of it.
Now I'd like to make an utility to check the consistency of files over multiple libraries, in particular I want to make sure all files have the same parameters (like LVLCHK and record level id): now I'm using a combination of DSPFD with OUTPUT(*OUTFILE) and then process the resulting table, but it'd be very nice to have a table function like OBJECT_STATISTICS() to check it at a glance.
So far I haven't found it, does it exists?
Thanks in advance.
In order to manage our IBM i system better, I already use some of the new SQL function introduced in the latest technlogy updates, as in https://www.ibm.com/support/pages/node/1119123
In particular, I often use the OBJECT_STATISTICS(), which is very useful, so I built some utilities that make use of it.
Now I'd like to make an utility to check the consistency of files over multiple libraries, in particular I want to make sure all files have the same parameters (like LVLCHK and record level id): now I'm using a combination of DSPFD with OUTPUT(*OUTFILE) and then process the resulting table, but it'd be very nice to have a table function like OBJECT_STATISTICS() to check it at a glance.
So far I haven't found it, does it exists?
Thanks in advance.
Comment