IBM i QSYS2
This is a list of items that you are able to SQL against to get information about your current system. I think you could probably make some small projects to test your RPG skill with them too.
All this information is through manual investigation, so it may not be correct.
Location Type Description ======== ==== =========== QSYS2/LIBLIST LF Your session library list QSYS2/PTF_INFO LF System PTF information QSYS2/SCHED_JOB LF Scheduled job information QSYS2/SYSCOLUMNS LF I presume a list of columns from every file. Be wared when querying this file - the copy on our box contains more than two million records. QSYS2/SYSDISKS LF Information about the drives that the system uses, including capacity and percent used. QSYS2/SYSFEATURE PF Features enabled on the system QSYS2/SYSTABLES LF A list of every table on the system, including name, column count, table desc. and more. QSYS2/SYSTSTAT LF What seems a list of references to every table / file on the system QSYS2/TABLES LF Another list of references to every library on your system. QSYS2/TABLE_CSTS LF Table contraints (?) QSYS2/USER_INFO LF Information about users, including name, last signon, enabled/disabled, authorities, grouped under, initial menu, initial program, description storage used, job description and lots more.
