Fresche Quadrant Software BCD Software SoftBase NetLert ExcelSystems Software Development

Attach Facility's Patent Pending
Multi-Row Fetch Feature

Streamline batch processing and improve batch DB2 performance

Introduced in 1987, SoftBase's Attach Facility™ is the most widely used Call-Attach Facility on the market. Attach Facility allows you to execute applications more efficiently, in less time and with greater flexibility.

The new patent pending Multi-Row FETCH (MRF) feature of SoftBase’s Attach Facility, is a powerful new tool for automatically implementing multi-row fetch in your existing batch DB2 applications. No application coding changes required! With the MRF feature, you can enjoy the performance improvements that multi-row fetch provides your batch applications without tedious recoding and testing.

The results are in.

Our customers are seeing FETCH statement CPU savings as high as 74% with Attach Facility's MRF feature! These shops might have spent months or years and hundreds of thousands of dollars recoding all of their applications by hand - Attach Facility did it for them almost instantly!

How much money can Attach Facility save your organization?

We've run multiple scenarios to that show how many shops can save over a million dollars in a 5 year period using Attach Facility's MRF feature, averaging only 40% FETCH statement CPU savings! Check out the scenario below, or click the link below to build your own custom forecast!

MRF ROI Scenario

View more scenarios and build your own shop's 5-year ROI and savings forecast here.


How it Attach Facility's MRF Feature works

How Attach Facility's MRF Feature works

When the application executes OPEN CURSOR, and FETCH statements are analyzed and, if appropriate, these requests are passed to Attach Facility instead of DB2. The OPEN CURSOR is reformatted for multi-row processing and executed. Attach Facility then issues a new multi-row FETCH statement to DB2 for the number rows specified by the user. It then places these rows into a new temporary result set space, and returns the first row to the application. As subsequent FETCH statements are issued by the application, the MRF feature intercepts these requests and pulls the information from the temporary result set space rather than DB2.

Once the application pulls data from the entire temporary row set, Attach Facility executes the next multi-row FETCH into the result set space, and continues passing each row back to the application as each application FETCH is encountered by the MRF feature. All SQL codes are set so they can be interrogated by the application program.

Build your own shop's 5-year ROI and savings forecast here.