RE: STRSQL SELECT * on a logical file: keys not recognized

The inter-active sql does not use the keys and you might have to use the
order by to get the desired keyed order.  But at the same time, if you
use an order-by on sql, it will try use the existing (PF/LF) access path
for execution.
Thanks,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax
 
 
-----Original Message-----
From: rwoconnor@xxxxxxxxxxx [mailto:rwoconnor@xxxxxxxxxxx] 
Sent: Sunday, March 20, 2005 9:58 AM
To: midrange-l@xxxxxxxxxxxx
Subject: STRSQL SELECT * on a logical file: keys not recognized


When I do an interactive SQL session (STRSQL) on a keyed logical file,
and
SELECT *, the list of records returned is not in keyed order.  I do not
use
an ORDER BY, because I was thinking that the use of the logical file
provides the "keyed" view of the physical file it is based on.  Is there
some other keyword required with the SELECT statement which forces the
key
sequence of the logical file to be used when listing the records?  Or
must
the ORDER BY be used even for a keyed logical file?


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