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
This was first published in July 2003