I am trying to create an OPNQRYF and use MAPFLD.
I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD.
These fields are conditionally placed as follows:
LNAME ===> ALPHANAME if LNAME is filled.
BUS_NAME==> ALPHANAME if LNAME is blank
APHANAME is defined this way in MAPFLD.
I would be grateful for any suggestions.
Thank you in advance,
We are on V5R2 and OPNQRY sits on one physical file. I need to create/derive a new column if if/boolean or case logic. i sthat possible?
Let's call the deired column/field: @NEW.
If field A is filled set @NEW = A
If Field B is filled set @NEW = B
( making this real simple. A & B are not filled at the same time)
Thanks in advance if you have information on OPNQRYF