×
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.
I figured you would do the create view in the same way you would do a CRTLF.
But, I guess you cannot get the index you need then.?
But, couldn't you then use embedded SQL over the view and sort the view as you need?
(I am now bumping up against the limits of my SQL knpwledge)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Patrik Schindler
Sent: Monday, June 14, 2021 10:04 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [DDS] [V4] Select/omit woes
Hello Paul,
Am 14.06.2021 um 15:05 schrieb Therrien, Paul via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:
Performance of a view, once created, should not be affected by whether
created from SQL or DDS definitions. (Unless you are creating the
LF/View at execution time?)
It's not about creation. It's about using embedded SQL vs. just opening and reading an already available LF. Sorry, I misread your first reply.
:wq! PoC
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
