TechTip: Automate Complex Tasks Using SQL and User-Defined Table Functions

​[[{“value”:”For example, I was recently asked if there was an IBM i service the user could run that would return the same information as the Display Problems (DSPPRB) command.
A UDTF is a function that you define that takes parameters as input, executes a series of SQL statements in a routine body, and then returns a results table that can be referenced in the FROM clause of a selection statement.”}]] Read More 

Verified by MonsterInsights