Re: More fun with native RLA on an SQL view

[CRPence <CRPbottle@xxxxxxxxx>]

James H. H. Lampert wrote:
> Uh, Rob, we're talking about VIEWS, not TABLES. And so far as I'm
> aware, SQL has no concept equivalent to a keyed logical file,
> i.e., a construct that imposes BOTH an index AND a format upon a
> physical file, OTHER THAN what is intrinsic to the physical file.
> An index cannot reformat the records; a view cannot resequence
> them, and there appears to be no way within SQL to arc-weld the
> two together into a single construct (although a DDS LF will use
> any existing SQL-generated index that is relevant).

  See CREATE INDEX syntax diagram in the IBM i 6.1 InfoCenter.

> At any rate, though, the issue I bring up here (as opposed to the
> one I bring up on the MI list) is that for some reason, RLA is
> failing to honor the WHERE clause in an SQL view (so far as I'm
> aware, it's only doing it for one record in one file), and I'm at
> a complete loss to understand why.

  The query debug messages might give some insight; i.e. to 
reproduce the scenario might require the same implementation.

Regards, Chuck