Re: sql - create view and order by

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

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.