Question

  Asked: Nov 7 2006   1:25 PM GMT
  Asked by: JohndeCoville

OPNQRYF's MAPFLD

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,

--John

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

thanks,

--John