Work Around for Oracle EXACT funct
Posted in 1994
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(@IF(@EXACT('B',TRADE.TRADE_TRANSACTION),TRADE.TRADE_SHARES,0)), @ROUND(SUM(TRADE.TRADE_UNIT_PRICE/TRADE_USDRATIO* @IF(@EXACT('S',TRADE.TRADE_TRANSACTION),TRADE.TRAADE_SHARES,0)),2),, SUM(@IF(EXACT('S',TRADE.TRADE_TRANSACTION),TRADE.TRADE_SHARES,0)),2), @ROUND(SUM(TRADE.TRADE_UNIT_PRICE/TRADE_USDRATIO* @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