Re: INSERT is changing column value
Posted by: joe conery
Date: December 01, 2004 03:04PM

The problem is actually worse...The insert statement causes most of the previously existing rows to change to that value as well. Here is an insert statement string that actually triggered the problem:

insert into transhistorytable (thr_primebroker, thr_counterpart ,thr_sectype ,thr_transid ,thr_currencypair, thr_trademethod , thr_tradetype , thr_tradeowner , thr_levmult , thr_buysell , thr_baseamount , thr_dollarbaseamount , thr_countercurrency , thr_traderate , thr_tradedate , thr_valuedate , thr_entrydate, thr_pbfee, thr_sendersubid, thr_fixmessage) VALUES ("UBS","ABN","FOR","BASIS-EURUSD_FOR_ABN_1101911686.191771_516","EUR/USD","FX Stream","Spot","account1","10","BUY",375000.0,0.0,-499275.0,1.3314,'2004-12-01 00:00:00','2004-12-03 00:00:00','2004-12-01 09:34:47',0.0,"CMEBasis","8=FIX.4.4^A9=267^A35=D^A34=589^A49=TRADE_CLEARER^A50=CMEBasis^A52=20041201-20:32:38.033^A56=COUNTERPART_WIN^A115=4^A128=2^A1=FX314596^A11=BASIS-EURUSD_FOR_ABN_1101911686.191771_516^A38=375000^A40=1^A44=1.3314^A54=1^A55=EUR/USD^A60=20041201-14:34:47^A63=0^A64=20041203^A75=20041201^A167=FOR^A207=ABN^A854=0^A10=208^A")

the thr_baseamount and thr_countercurrency columns are having problems.

Options: ReplyQuote

Written By
December 01, 2004 10:32AM
Re: INSERT is changing column value
December 01, 2004 03:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.