I'd like to decode a field. I have to "translate" some values but for the rest where I don't have to do a decode I'd like WebFocus to take the original value.
Something like that:
DEFINE FILE XYZ
NEW_FIELD/A10 = DECODE OLD_FIELD (A 'first'
Yet I guess there must be something wrong with the syntax because for all values of the OLD_FIELD which do not match A or B I have now one single value named OLD_FIELD.
However, what I wanted is that all the values that don't match A or B are displayed as they are stored in OLD_FIELD.
Does anybody know how to do this?