Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- SELECT * FROM p_rcv_log ORDER BY rcv_log_id DESC LIMIT 10
- SELECT * FROM p_rcv_data_log WHERE rcv_log_id = 42 AND flg_process = 'FAIL'
- "{"id":553,"tenantId":10,"partnerId":263,"groupPartner":"C","typePartnerId":20,"dueDate":30,"currencyCode":"IDR","amountLimit":5.0E7,"flagCommision":"N","active":"Y","activeDateTime":"20150330120000","nonActiveDateTime":" ","createUserId":-1,"createDateTime":"20150330120000","updateUserId":103,"updateDateTime":"20170613155442","version":1}"
- --UPDATE m_partner_type SET version=2 WHERE partner_type_id = 613
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 510
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 554
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 553
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 609
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 630
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 530
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 536
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 552
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 558
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 583
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 585
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 590
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 595
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 616
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 628
- --UPDATE m_partner_type SET version=1 WHERE partner_type_id = 624
- --UPDATE m_partner_type SET version=2 WHERE partner_type_id = 618
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement