RE: Tables and PFs

we have an old pf where a load of unrelated information is stored. The rpg program would read it into a data structure. We always referred to this file as our parameter file. Depending on the type of information you are looking for, the rpg would load it into the corresponding DS. These groups of records in the parametre file are still referred to as tables. Hence the confusion and slight irritation when someone mentions table meaning physical file.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Jerry Adams
Envoyé : mardi 12 janvier 2010 17:21
À : Midrange Systems Technical Discussion
Objet : RE: Tables and PFs

Agreed. It's just semantics. Table and file are
interchangeable just as row and record are. My boss, who
does a heck of a lot more SQL on PC apps than I do on IBM i
apps, and I often talk about the systems and he will say,
"Row," and I will says, "Record." Neither of us have a
problem understanding the other.

In formal documentation I try to use the term "table," but
will frequently in conversation use "file." Either way, it's
a database object.

There are more important things to get bugged about.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: Tuesday, January 12, 2010 10:05 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Tables and PFs

Is there a simple way to explain the difference between a

table and a

physical file a part from one is created by SQL and the

other with DDS?

Should it bug me when a coworker says table but means a PF? It does
and I'm not sure why.

The difference between a table and a physical file is the
same as the difference between a thing and an object.

Well, that is unless the table you're referring to is the
thing that holds your supper. There is a difference there, I
hope. :)

I'm not sure why it bothers you either. But I am sure that
it shouldn't.
:)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The efficiency of our criminal jury system is only marred by
the difficulty of finding twelve men every day who don't know
anything and can't read."
-- Mark Twain



--
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.

--
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.