Problem solve Get help with specific problems with your technologies, process and projects.

Return multiple columns on a single function call

We use UDFs to change the representation of a field when retrieving via SQL, i.e. perform BITON/BITOFF conversion. Can a UDF be used to select all results from a table, i.e. a complete row? And in addition, do conversions on select fields within the row.

If I code SELECT * FROM FILEA I want all fields returned, and additionally the 1A bit status field to be returned as 8A with each bit setting shown as on/off.
A user-defined table function (new with V5R2) can be used to return multiple columns on a single function call. However, each column would have to be passed in as individual input parameters to each function.


Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this Search400.com Featured Topic: Database issues resolved

Dig Deeper on Oracle on iSeries