Re: sql - create view and order by

Yes, Richard, but if you don't have the right indexes built then you could 
be taken a performance hit.  At that point your join logical has no more 
function than an SQL view.  It's not that the SQL would be more of a pig 
than the OPNQRYF, (the underlying engines are the same).  You could do SQL 
over that join logical also.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/28/2003 12:42 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Re: sql - create view and order by



Mike,

as Vern pointed out, my idea of an index over a view was misguided (at
best).

You CAN, on the other hand, do an opnqryf over a join logical, using keys
from both the 1st and 2nd level physicals.

Harder to use if you are doing random keyed access, but if you are reading
front to back, very doable.

hth,

rick

-----original message-------
Rick,

If I try
create index osp_a on mikee/osp (oheda8)

I get
OSP in MIKEE not a table.

I'm doing this because one of our RPG programmers wants to join two files
(header and detail) and do the primary sort on a field in the detail file
and the secondary sort on a field in the header file.  She says she can't
do this in DDS.

I thought I could possibly create such a logical with SQL, so she could 
use
RLA against it in her RPG program.  She's not against using embedded SQL 
in
her program, but she doesn't know how and I thought this might be easier.

Thanks,
Mike E.



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