RE: Help Systems' email about AFP support discontinued at 7.3 - not true ! - or is it ?

Scott,

The common argument we hear for still using a spool file as a source for report downloads or forms is that it would be too complex to re-create the logic that generated the spool file because it was created by an RPG application with gobs of logic not easily replaced.

In an ideal world they could use SQL to join all the data they need.

Unfortunately easier said than done sometimes.

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 6
date: Fri, 9 Dec 2016 22:19:20 +0000
from: "Lindstrom, Scott R." <Scott.Lindstrom@xxxxxxxxxxxxxx>
subject: RE: Help Systems' email about AFP support discontinued at 7.3
- not true ! - or is it ?

Brad - is correct - this is VERY common. Certainly has been done everywhere I have worked.

And to argue the other point of view - a spool file is a snapshot of data *at a point in time*. For an accountant it may be the General Ledger at the close of the month. They don't want to see the data as it is *now*; the want it from the report.

And by using products like Brad's they get their data immediately without having to ask IT to program a file extract, or by doing it themselves using something like Query or ODBC (which for many users is beyond their ability/comfort level) (especially if the data comes from multiples files that have to be joined together).

Scott