IBMi SQL Tips #25 - DB2's "secret" Table Functions

Markdown Content: Massimo Duca ### Massimo Duca Published Sep 4, 2026 100% NOT AI-generated content ! We all know (or should know...) that DB2 for i comes packed with a huge collection of SQL views and functions, giving us almost complete visibility over the whole system. However, there’s a set of User Defined Table Functions (UDTFs)—not officially documented by IBM—that are built over existing views and return that same data in a table format. It was Scott Forstie himself (the longtime lead of the DB2 for i development team) who "spilled the beans" a few years ago in a GitHub gist, which you can check out here: When it comes to DB2 for i, anything Scott says is pure gold! …