RE: Updating a Program using SETLL/READPE - Suggestions

Brian,

When the job is running, and you look at the wrkactjob screen, does the
status frequently say "LCKW" ?  


>-----Original Message-----
>From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
>On Behalf Of Brian Piotrowski
>Sent: Wednesday, December 14, 2005 3:20 PM
>To: RPG programming on the AS400 / iSeries
>Subject: RE: Updating a Program using SETLL/READPE - Suggestions
>
>Well, you know that wouldn't surprise me - I've been reviewing a lot of
>the code for the system, and the former programmers tend to lock the
>entire table as opposed to a single record within it.
>
>Brian.
>
>-----Original Message-----
>From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
>Sent: Wednesday, December 14, 2005 3:09 PM
>To: RPG programming on the AS400 / iSeries
>Subject: RE: Updating a Program using SETLL/READPE - Suggestions
>
>I'd wonder about the record lock myself.  Unless he meant to say that
>the
>READE reads a million records, but does some further checking and only
>updates 10-100 of those records.
>
>Rob Berendt
>--
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000
>Dock 108
>6928N 400E
>Kendallville, IN 46755
>http://www.dekko.com
>
>
>
>
>
>Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx>
>Sent by: rpg400-l-bounces@xxxxxxxxxxxx
>12/14/2005 02:46 PM
>Please respond to
>RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
>To
>"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
>cc
>
>Fax to
>
>Subject
>RE: Updating a Program using SETLL/READPE - Suggestions
>
>
>
>
>
>
>On Wed, 2005-12-14 at 14:18 -0500, Brian Piotrowski wrote:
>> I thank you all for the insight and great suggestions.
>>
>> One question to which I did want to respond was with regards to the
>> number of records that are updated.  The answer is: it's variable.
It
>> could be as many as 100, or less than ten.  It all depends on what is
>> being shipped at the time.
>>
>
>Didn't you say it was taking five minutes in some cases?  I would not
>expect anything near that type of response unless someone is holding
>open a record lock on one of the records that you are trying to update.
>Ten records or a hundred should be 'lickity-split' (a technical term).
>
>Regards,
>Rich
>
>--
>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.
>
>
>--
>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.
>
>
>
>--
>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.