Hi please let me know how can this be given in a IF THEN statement or CASE WHEN
Condition is
IF Fixed Rate Payer(Buyer) = CounterpartyID THEN BUYER NAME = Counterparty AND SELLER NAME = LegalEntity
ELSE BUYER NAME = LegalEntity AND SELLER NAME = Counterparty

where Fixed Rate Payer(Buyer),CounterpartyID,BUYER NAME,SELLER NAME all are field names with data.

No CASE syntax available in WebFOCUS.

DEFINE FILE ...
BUYER_NAME/A100  = IF Fixed_Rate_Payer(Buyer) EQ CounterpartyID THEN Counterparty ELSE LegalEntity;
SELLER_NAME/A100 = IF Fixed_Rate_Payer(Buyer) EQ CounterpartyID THEN LegalEntity  ELSE Counterparty;
END

Thanks Verymuch
Sorted it out 2 mins ago

we can use DECODE instead, for a situation like case

You cannot use DECODE like a CSAE statement - just like IF THEN ELSE, you would have to code the DEOCDE for each field you need to define. In a CASE statement, you would be able to define multiple fields based on a condition.

DEFINE FILE XX
BUYER_NAME/A100 = IF (FIXED_RATE_PAYER EQ CounterpartyID) THEN Counterparty ELSE LegalEntity;
SELLER_NAME/A100 = IF (FIXED_RATE_PAYER EQ CounterpartyID) THEN LegalEntity ELSE Counterparty;
END
.
.
.

Ok, and as for using this in a decode - you would need to have an up front define that sets a flag where they are equal and then use a decode based on the flag.

Not worth it...
go with 1st option.

Ira WF 5.3.6 AIX