Re: ALCOBJ and OPEN occurs?

RE:     Re: ALCOBJ and OPEN occurs?


Tim,
Copy the file when you want to, and then do an SQL delete of the records.
No ALCOBJ is needed.   All records will be deleted(same effect as CLRPFM)

Just change the file to Reuse Deleted Records *YES.

We've done this for similar needs and it works great.  

No clearing, no ALCOBJ's 

John Carr
EdgeTech
Have Classes, Will Travel


-----Original Message-----
From: Tim Truax <truax@usaor.net>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Sunday, November 08, 1998 12:32 AM
Subject: Re: ALCOBJ and OPEN occurs?


>Here is what is happening, a program RPG LU6.2 just sits there all day
having
>periodic transmission sent to it.  I want to write a CLP that will
lock the
>accuumulator file then do a quick copy and then clrpfm of the
accumulator file,
>then remove the lock.  This will process the copy of the accumulator
file while
>returning the blank accumulator file to the accumulator LU6.2 program.
>
>Bob Crothers wrote:
>
>> Why does the CLP put a lock on the file that you cant open it for
add?
>> If possible, remove this lock.
>>
>
>
>
>--
>Tok2YaLatR!
>Tim Truax
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---