insertinto RRTest SELECT Order_ID, Order_ID, Order_ID, CUSTOMER_ID, ORDER_TYPE, EXECUTION_TYPE, ORDER_DATE, ORDER_TIME,ORDER_DATETIME, SIDE, TRADE_TYPE, ORDER_AMOUNT, ORDER_PRICE ,ORDER_ID FROM DB2INST1.Fx_Order where ORDER_DATE >'20070401' GO selectcount(*)From RRTEST 72239
ALTER TABLE"DB2INST1".RRTest ADD PRIMARYKEY (pkID);
CREATE UNIQUE INDEX UNIQINDX ON RRTest(unID1) CREATEINDEX INDX002 ON RRTest(unID2) db2 "RUNSTATS ON TABLE DB2INST1.RRTest ON ALL COLUMNS AND INDEXES ALL ALLOW WRITE ACCESS"
db2 connectto db2TT db2 +c
select * From RRTEST where TSID='20070223ORD01267732'forupdatewith RR select * From RRTEST where TSID='20070222ORD01266302'forupdatewith RR
select * From RRTEST where TSID='20070223ORD01267732'forupdatewith RS select * From RRTEST where TSID='20070222ORD01266302'forupdatewith RS
select * From RRTEST where unID1='20070223ORD01267732'forupdatewith RR select * From RRTEST where unID1='20070222ORD01266302'forupdatewith RR select * From RRTEST where unID1='20070223ORD01267732'forupdatewith RS select * From RRTEST where unID1='20070222ORD01266302'forupdatewith RS
select * From RRTEST where unID2='20070223ORD01267732'forupdatewith RR select * From RRTEST where unID2='20070222ORD01266302'forupdatewith RR select * From RRTEST where unID2='20070223ORD01267732'forupdatewith RS select * From RRTEST where unID2='20070222ORD01266302'forupdatewith RS
select * From RRTEST where pkID='20070223ORD01267732'forupdatewith RR select * From RRTEST where pkID='20070222ORD01266302'forupdatewith RR select * From RRTEST where pkID='20070223ORD01267732'forupdatewith RS select * From RRTEST where pkID='20070222ORD01266302'forupdatewith RS