Guru: Search Source Code For Strings Using SQL

October 9, 2023 Bob Cozzi

The IBM-supplied Find String Using PDM (FNDSTRPDM) command and PDM option 25 are how most developers scan for a simple value in a list of source file members. But what if you need more? For example, what if you want to find something complex, such as the field named “CUST” but not the field named “CUSTNAME” “CUSTOMER” or “CUSTNO”? Go ahead, I’ll wait?

While I do use FNDSTRPDM all the time, I now use the SQL READSRC (Read Source File Member) Table function more often.

READSRC SQL UDTF

The READSRC SQL Table function or UDTF (User-defined table function) uses an …