MVSFORUMS.com

[tcurrier]

In QMF, is there a way to immediately convert a numeric value to an alpha value for display purposes ?

In other words, say I have a column called STATE_CODE that contains values 01 thru 49. When I perform the query, I want the report not to show 01 thru 50, but rather 'Arizona' thru 'Wyoming'.

Obviously, I would have to hard-code this, but would this be possible to do ?

Thanks for any help.

[GuyC]

Do you mean without changing the query, directly in the report ?
I guess it's doable wih user defined edit codes : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.qmf9.doc.iandm/edit.htm#edit

but the usual way is to join with a table in your query

[tcurrier]

Looks like I have found one way to do it:

[dbzTHEdinosauer]

as long as i don't require a SELECT in my UDF
(because of the db2 vsn i am using)
i have several UDF's that 'convert' columns for spufi/unloads/qmf
since i am the creator, they are not used in imbedded sql.

i have several transaction type columns,
and there are some 140 different descriptions.
i have just pulled the 'descriptions' from application programs,
and wrote a UDF with a large (140 WHENs) CASE statement.
though possibly not as efficient as a join, much less code /
nur a function statement in the select.
_________________
Dick Brenholtz
American living in Varel, Germany

[danm]

Create a table with the state_code and state_name and join this table with your table.