RE: DBA Question

Thanks to all, that's the kind of information I need along with your
experience on allocation of file space and the operational limitation of any
of the three object types.

Jack Derham
Direct Systems, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Liotta
Sent: Monday, June 20, 2005 9:07 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: DBA Question

Jack:

I didn't see a lot of responses that seemed to get at the heart of your
question. Maybe I misunderstood.

One example of a 'physical' difference between a DDS logical file and a SQL
view is that DDS LFs can have multiple members; the sub-type for SQL views
will reject any attempt to add more members.

Is this the kind of info you were looking for?

Tom Liotta

midrange-l-request@xxxxxxxxxxxx wrote:

>  11. DBA Question (Jack Derham)
>
>Got into a discussion this afternoon about what the real differences are
>between logical files, views and indexes. The discussion got a little
heated
>at times so I would ask that some of you well versed members to please help
>out less fortunate uninformed members about the real physical and logical
>attributes of these object types.