We have multiple copies of the same library for testing, QA, development etc. consisting of hundreds of tables. Over time these libraries got out of sync and we run into a lot of level check problems. I would like to list all tables with a different Record Level Format Identifier from the corresponding tables in a model library. Is this possible using SQL? If not what other choices do we have?
Yes. There is a view qsys2.sysfiles that has this information. There is a link to this view in the IBM online documentation for the (very complex) QDBRTVFD API.