×
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.
On 19 Jun 2013 11:53, Jeff Crosby wrote:
Suppose I have a file defined via DDL with unique key consisting of
Item (ascending)
Date (ascending)
<<SNIP>>
FWiW: By suggesting that the "file" had been created with SQL DDL to
have a "unique key", any affirmative replies with regard to getting the
desired\expected record would have presumed that file had been created
by CREATE INDEX [i.e. logical file; LF] or that the /unique key/ was
established as a PRIMARY KEY constraint added either by CREATE TABLE
[i.e. physical file; PF] or ALTER TABLE .. ADD CONSTRAINT [or its CL
equivalent: ADDPFCST].
A UNIQUE constraint does not directly make a TABLE a /keyed file/
from the perspective of the RPG. The physical file without a primary
key would have defined as its AccPth, per DSPFD, "Access Path = Arrival"
and thus not available as a keyed file except via a shared query ODP
[from a request to: OPNQRYF KEYFLD()].
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
