Order ID migration

SQL error - extra single quote

Log:

.17:37:34,584 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_022011 t, ORDERMAST o  where t.TRX_CODE = '1000'  and o.ORDERID = t.TRX_ORDER_NO ' and t.TRX_STATUS <> 'R' and t.REASON_CODE is NULL and t.TRX_STATUS = 'P' and o.ORDERSTATUS = 'I' and o.SHOPPERVOIDORDER <> 'Y' and o.SUPPLIERACTION <> 'J' and o.ORDERID between '0' and  '400000000'' and t.TRX_TYPE <> 'M' ) as T1  ) as T2  where rowNo between 1 and 16
17:37:34,608 INFO  [STDOUT] A database manager error occurred.
17:37:34,608 INFO  [STDOUT] SQL State: 42601
17:37:34,608 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:37:34,608 ERROR [STDERR] wpwong: OrderEnquirySummary.java: 24-01-2011 05:37:34: 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_022011 t, ORDERMAST o  where t.TRX_CODE = '1000'  and o.ORDERID = t.TRX_ORDER_NO ' and t.TRX_STATUS <> 'R' and t.REASON_CODE is NULL and t.TRX_STATUS = 'P' and o.ORDERSTATUS = 'I' and o.SHOPPERVOIDORDER <> 'Y' and o.SUPPLIERACTION <> 'J' and o.ORDERID between '0' and  '400000000'' and t.TRX_TYPE <> 'M' ) as T1  ) as T2  where rowNo between 1 and 16