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.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
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