Order ID migration

Super Selection Order Administration - Order Approval ========================
SQL error - extra single quote

Log:

17:49:08,845 INFO  [STDOUT] wpwong: OrderEnquirySummary.java: sql= select * from  (select rownumber() OVER (ORDER BY trxOrderNo) as rowNo, trxOrderNo, memberID, shopperID, trxDate,  callbackTelNo, callbackStatus, isPermanentAddr, ototalChargedAmt, opaymentStatus, orderStatus, supplierStatus, mainOrderId  from (Select distinct t.TRX_ORDER_NO trxOrderNo, t.MEMBER_ID memberID, t.SHOPPER_ID shopperID, t.TRX_DATE trxDate,  t.TM_NUMBER callbackTelNo, t.TM_STATUS callbackStatus, t.CHG_ADDR_IND isPermanentAddr, o.TOTALCHARGEDAMT ototalChargedAmt, o.PAYMENTSTATUS opaymentStatus, o.ORDERSTATUS orderStatus, o.SUPPLIERACTION supplierStatus, o.main_order_id mainOrderId  from TRANSACTION_122010 t, ORDERMAST o  where t.TRX_CODE = '1000'  and o.ORDERID = t.TRX_ORDER_NO ' and t.TRX_STATUS <> 'R' and t.TRX_STATUS = 'A' and o.ORDERSTATUS = 'A' and o.ORDERID between '0' and  '400000000'' and t.TRX_TYPE <> 'M' ) as T1  ) as T2  where rowNo between 1 and 16
17:49:08,864 INFO  [STDOUT] A database manager error occurred.
17:49:08,865 INFO  [STDOUT] SQL State: 42601
17:49:08,865 INFO  [STDOUT] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: o.ORDERID = t.TRX_ORDER_NO ' and t.TRX_STA;X_CODE = '1000'  and;<name>
17:49:08,865 ERROR [STDERR] wpwong: OrderEnquirySummary.java: 24-01-2011 05:49:08: orderEnquiry: Get transaction detail, sql error= select * from  (select rownumber() OVER (ORDER BY trxOrderNo) as rowNo, trxOrderNo, memberID, shopperID, trxDate,  callbackTelNo, callbackStatus, isPermanentAddr, ototalChargedAmt, opaymentStatus, orderStatus, supplierStatus, mainOrderId  from (Select distinct t.TRX_ORDER_NO trxOrderNo, t.MEMBER_ID memberID, t.SHOPPER_ID shopperID, t.TRX_DATE trxDate,  t.TM_NUMBER callbackTelNo, t.TM_STATUS callbackStatus, t.CHG_ADDR_IND isPermanentAddr, o.TOTALCHARGEDAMT ototalChargedAmt, o.PAYMENTSTATUS opaymentStatus, o.ORDERSTATUS orderStatus, o.SUPPLIERACTION supplierStatus, o.main_order_id mainOrderId  from TRANSACTION_122010 t, ORDERMAST o  where t.TRX_CODE = '1000'  and o.ORDERID = t.TRX_ORDER_NO ' and t.TRX_STATUS <> 'R' and t.TRX_STATUS = 'A' and o.ORDERSTATUS = 'A' and o.ORDERID between '0' and  '400000000'' and t.TRX_TYPE <> 'M' ) as T1  ) as T2  where rowNo between 1 and 16