Indexes are pointers for sequencing data reads, but a view is a particular way of "view"ing a table, where you are selecting particular records, limiting fields, combining data from multiple tables or in your case adding data that's not in any other table to each record. You've created a logical view of the data versus a logical order for reading the data. That's why a logical file in the native database is a logical file and does both and if you create either an SQL view or index, you get a native logical file as its container. Does that make sense?
Coy Krill
Core Processing Administrator/Analyst
Washington Trust Bank
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vicki Wilson
Sent: Wednesday, February 25, 2015 16:03
To: midrange-l@xxxxxxxxxxxx
Subject: Why does the system see the logical file as a view
Importance: Low
Hi all,
We are starting to talk about modernization. We have older logical files that have new record names, specify the fields in addition to a key for sorting.
We were experimenting with generating an SQL script. We did not find the logical with indexes - we found it with the views. I'm curious. Why does the system recognize it as a view? And how do the key fields get handled since they can't be included in the view?
Bonus question for anyone further down the modernization road. How are you handling goodies like this?
Vic
--
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 electronic mail message and any attachments may contain confidential or privileged information and is intended for use solely by the above-referenced recipient. Any review, copying, printing, disclosure, distribution, or other use by any other person or entity is strictly prohibited under applicable law. If you are not the named recipient, or believe you have received this message in error, please immediately notify the sender by replying to this message and delete the copy you received
---------------------------------------------------------------------
midrange.com
