Use an SQL user-defined table function (UDTF) to access messages in a message file.

By Mike Faust

If you've ever needed to retrieve information from a message file, you're probably already aware of the Retrieve Message (QMHRTVM) API, which allows you to retrieve message descriptions for messages in a specified message file. But is that enough?

Coding SQL within RPG or Java is time-consuming and tedious, but what if you could automatically generate SQL for RPG or Java in seconds?

By Scott Salisbury

As System i programmers, we are being nudged, prodded, and goaded to use embedded SQL in our programs.