Helpful SQL Commands for RiTA

Wipe out data in TEST environment

UPDATE RITADB30/REQUEST SET BATCH_SEQ_NUM = -10002, STATUS_CODE = 7
WHERE CLIENT_ID = ‘100010001′

Batch Sequence

select * from ritadb30/merch_term_btch where client_id = ‘100010001′

UPDATE RITADB30/MERCH_TERM_BTCH SET BATCH_SEQ_NUM = 20 WHERE
CLIENT_ID = ‘100010001′