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

This was first published in July 2003

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.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: