Work Around for Oracle EXACT funct

From: Jessica Kung <jesskung_at_solomon.technet.sg>
Date: 13 May 1994 04:07:53 GMT
Message-ID: <2quuep$n6e_at_raffles.technet.sg>

Hi there,

We need your help with regards to the following SQL feature for OnLine 5 and 6.

We have a query in SQL Base from Gupta for an existing application as follows:n

SELECT
  '', '', '',
 SUM(_at_IF(@EXACT('B',TRADE.TRADE_TRANSACTION),TRADE.TRADE_SHARES,0)),  _at_ROUND(SUM(TRADE.TRADE_UNIT_PRICE/TRADE_USDRATIO*
_at_IF(@EXACT('S',TRADE.TRADE_TRANSACTION),TRADE.TRAADE_SHARES,0)),2),,
 SUM(_at_IF(EXACT('S',TRADE.TRADE_TRANSACTION),TRADE.TRADE_SHARES,0)),2),  _at_ROUND(SUM(TRADE.TRADE_UNIT_PRICE/TRADE_USDRATIO*
_at_IF(@EXACT('S',TRADE.TRADE_TRANSACTION),TRADE.TRADE_SHARES,0)),2),
 SUM(TRADE.TRADE_NET_COMM/TRADE.TRADE_USDRATIO),  0
FROM TRADE, COMM
WHERE

TRADE_BARGAIN_NO=COMM_BARGAIN AND
TRADE_DATE>=1993-MAR-1 AND
TRADE_DATE<=1994-MAR-1 AND
TRADE_HOMEMKT IN ('CH','CF','HK','IND','IN','MA','OTH','PH','SP','SL','TH') AND
TRADE_TYPE IN('N','H','M','I','O','P','S') AND

COMM_SALES IN ('BH','BSH','BC','BD','CMP','CHS'...) GROUP BY 1,2,3 The problem is that INFORMIX do not have the function EXACT which SQL Base and

Oracle 7 has. Can you help us to find the possible work around?

Thank you.

Regards
Jessica Received on Fri May 13 1994 - 06:07:53 CEST