Select all failed OFS transactions
You can select all the failed OFS transactions using this query SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -... This will select all the records from the file F.OFS.RESPONSE.QUEUE which are failed due to any reason. If you want to select only the failures due to error then use this query SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -1... If you want to select only the failures due to overrides then use this query SELECT F.OFS.RESPONSE.QUEUE WITH F1 LIKE -2...