×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
There is a nice article about the differences between DDS described
physical
and logical files and SQL Defined Tables, Views and Indexes:
Understood. But the distinction (clearly stated in the document to which
you refer, as I recall) is how the entity is created, not in what it's
called. The OP asked about what to CALL these things, and did not specify
how they were created.
I may call an entity created by SQL a file or a table; makes no difference
to me nor to the system. I can create this entity via CREATE TABLE, and
then WRKOBJ .. OBJTYPE(*FILE) and, lo and behold, the entity will appear in
the list. Is the system broken?
By the same token, I can create a PF using DDS... and I can create a view
over that using SQL. SQL couldn't care less because the object *IS* a
table.
To say that a table has this attribute while a PF has that attribute...
that's all nonsense. But let's carry this forward. You create a PF using
DDS. Now you add a column using SQL. Is it a table, a file or a hybrid of
some sort?
What do you call it? Just don't call it late for dinner.
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Nature gave man two ends - one to sit on and one to think with. Ever since
then man's success or failure has been dependent on the one he used most."
-- George R. Kirkpatrick
midrange.com
