Re: RPGLE native I/O and SQL Tables/Views/Indexes

[Alan Campin <alan0307d@xxxxxxxxx>]

it's not that simple. A physical file created with DDS and a table created
with SQL are the same thing to RPG. If the table has an index, you can do
operations like Chain and Setll just like a DDS defined table.

Views are more complex. Views don't have indexes so the only thing that you
could do with a view in an RPG program is read it sequentially or write to
it.

An SQL index looks like a logical file to an RPG program so you could use
it like a logical file. That's not normally how you would do it. You would
define an SQL index and then define a logical and it should share the
access path (Index) and it is just another logical to RPG.



On Mon, Sep 27, 2021 at 9:11 AM K Crawford <kscx3ksc@xxxxxxxxx> wrote:

> I am trying to help someone and clarify for me the following.  I don't
> think I am typing in my searches correctly.  What I am looking for is:
> What native RPGLE I/O can you do over a SQL Table?
> What native RPGLE I/O can you do over a SQL View?
> What native RPGLE I/O can you do over a SQL Index?
> A chart something like:
> I/O     Table    View    Index
> Read    Yes      Yes     Yes
> Reade   No       No      Yes
> Readp   x        x       x
> Readpe  x        x       x
> Chain   x        x       x
> SetLL   x        x       x
> SetGT   x        x       x
> Delete  x        x       x
> Write    x        x       x
>
> --
> 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