Wednesday, 5 October 2016

Get path,created date time, message id, extractable count of Mailbox with this query in Sterling Integrator

select MB1.PATH, M1.CREATED_DATETIME,MB2.MESSAGE_ID,MB2.EXTRACTABLE_COUNT from MBX_EXTRACT_COUNT MB2,MBX_MESSAGE M1, MBX_MAILBOX MB1 WHERE MB2.EXTRACTABLE_COUNT='1'

No comments:

Post a Comment