Re: RPG and SQL view/index

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You can use CHAIN, SETLL, READE, ect on an index, but not a view.

Charles

On Tue, Jul 6, 2021 at 12:20 PM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

> Is there a way to create a view that can be used in an RPG program in a
> native way?
> I have a SQL view over two files/tables.  I want to do an RPGLE CHAIN
> and/or SETLL/READE to this view.
> I think the answer is no but wanted to verify.
>
> --
> KCrawford
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com