Q
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.

==================================
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


Dig Deeper on Oracle on iSeries

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close