Re: Problem with an SQL View that has selects/omits

"James H. H. Lampert" <jamesl-6/ELSmrcqeUu8xhjR5IN5AC/[email protected]> Thu, 18 Mar 2010 13:14:19 -0700
Newsgroups gmane.comp.lang.as400.mi
Message-ID <[email protected]>
CRPence wrote:
>    I see that was already done, but I am still confused about the 
> actual file definitions, the physical data, and the selection 
> defined for each.  I am beginning to think the LF must be a 
> non-keyed LF?

In the case of the SQL VIEW, it's inherently non-keyed.

In the case of the DDS LF, it's keyed, but being forced to RRN access.

--
JHHL
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.