Exploring the IFS with DB2 services

Last Updated on 23 February 2020 by Roberto De Pedrini The rich “family” of DB2 for i services has recently seen the birth of a new category: IFS services. This group of services is available from IBM i 7.3 with the DB2 SF99703 Level 16 update (but it is better to consider only Level 17, since level 16 led to some problems… see here ). These new services return information about objects located in IFS folders; 4 services are available, and the most interesting is IFS_OBJECT_STATISTICS , a function returning a table with the list of files in a specified directory (or starting from the specified directory), with all related information. …