Hi Firends
I have this type of file
Rows read = 4823832
Statement text = SELECT QUEUE, REPLY_QUEUE, REPLY_QMGR FROM HUB_REF.CORNERSTONE.HUB_REF_QUEUE AS RQ WHERE (RQ.SERVICE_NAME = 'modifyParty' OR RQ.SERVICE_NAME = '*') AND RQ.SERVICE_TYPE = 'REQ' AND RQ.VERSION = 'NA' AND RQ.TARGET ='MARS'
Rows read = 0
Statement text = SELECT BSB_NUMBER,NAME,STREET,POSTCODE,SUBURB,STATE FROM HUB_REF.CORNERSTONE.HUB_REF_BANK AS BANK WHERE BANK.BSB_NUMBER LIKE '%013762%'
Rows read = 482
Statement text = SELECT BSB_NUMBER,
Rows read = 0
Statement text =vbnmkliu
I need the SQL statement where Rows read > 100
I am trying to extract it but unable to do please help ?
Thanks