RE: Creating files and then combining them into one PF

No need to rewrite. Just create Views for the SalesXX files for the
existing programs.

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi



"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/17/2010 10:30 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Creating files and then combining them into one PF






Easier to rewrite potentially hundreds of programs rather than to solve
the
problem as stated? You must be in my line of work! :)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If an animal does something, we call it instinct; if we do the same thing
for the same reason, we call it intelligence."
-- Will Cuppy

Why have separate tables at all? It would be much easier to have just
a
SALESHIST table with a key column of SALESYEAR wouldn't it?

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.