Re: SQL views over multi member physical file

[CRPence <CRPbottle@xxxxxxxxx>]

On 08 Aug 2013 13:56, Sam_L wrote:
> <<SNIP>>
>
> Given that, one alternative might be to write a User Defined Table
> function with an RPG program behind it.
>
>  Select t.*
>  from mytable('MEMBER_1',500) as t
>
> would return the last 500 rows of MEMBER_1.
>
> For efficiency, the RPG could start at the end of the member and
> read backwards.
>
> You would have to train your internet group in this syntax, but hey,
> aren't they SQL geeks?
>
> I doubt if you could put the above in a view, given that you are in
> essence passing two parameters <<SNIP>>

  Irrespective of the sensibility in so doing... Such a UDTF could 
easily be encapsulated in a VIEW:

    create MyTable_Mbr01_Last500 as
    select t.*
    from TABLE ( mytable('MEMBER_1', 500) ) as T