Re: RPG on a Windows PC (Invite)

["Gene Burns" <burns.gene@xxxxxxxxx>]

If SqlServer doesn't support locking of rows for update, I wonder how MySql
will handle this when it is shoehorned onto the iSeries?  Will RPG be able
to access the MySql database directly?  This could prove very interesting.

http://www.itjungle.com/breaking/bn042607-story02.html


On 5/4/07, Steve Richter <stephenrichter@xxxxxxxxx> wrote:
> On 5/4/07, Paul Raulerson <paul@xxxxxxxxxxxxxx> wrote:
> > I thought of that, but it is only at Alpha level right now - so it ain't
> ready for public
> > discussion (or should I say dissection? :) yet.
>
> too bad. it is an interesting topic.  from what I am seeing of
> sqlServer, the concept of selecting a row for update, doing some
> calcs, and then updating the locked row is not supported.   The reason
> being that it is contrary to the disconnected database and network
> model of application programming that MSFT has embraced.
>
> RPG code makes heavy use of what I think is called optimistic locking.
>   How would you port RPG code that wants to read records, lock them
> and then update?
>
> -Steve
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.