Re: More fun with native RLA on an SQL view

[Luis Rodriguez <luisro58@xxxxxxxxx>]

James,

IIRC, you can specify a record format for an index with V6R1.

Also, How are you doing the RLA of your view?  Could you give us an example?
I think that some of my coworkers have read SQL views using RLA without
problems...

Regards,


Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, Apr 15, 2010 at 11:02 AM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> 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).
>
> 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.
>
>
> --
> JHHL
> --
> 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.