Re: Update Operation Failure Help Please

So do we know know an sql update between a native read & update
is a problem? What if the sql had been a select statement, I assume would we
no longer be on the correct record to update...
Is this like a shared odp?
jim

To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, June 02, 2006 12:17 PM
Subject: RE: Update Operation Failure Help Please

Thanks, Tommy.  That worked great.  I moved a bit of code around so that
my subsequent SQL statements occur after the update.

Brian.

-----Original Message-----
From: Holden Tommy [mailto:Tommy.Holden@xxxxxxxxxxxxxxxxx]
Sent: Friday, June 02, 2006 11:57 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Update Operation Failure Help Please

Geez...not an answer to your question directly but this is really
ugly...why not just use native I/O on the ssw85 file updates(which
incidentally could be causing your issue but I'm not sure on that...)

SQL IS a wonderful thing but use it where needed, not just because it's
there...not to mention it will run a lot faster since you're doing 1 I/O
compare to 3.


--
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.