1.  Home
  2. RPG400-L
  3. September 2002

RE: F SPEC to clear a file?

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I use this quite often when I cannot seem to get a lock on a file.  CLRPFM
is quite adamant about having a rather exclusive lock on that file.  The
benefit is that CLRPFM will remove the deleted records from the file.  But
using a QTEMP file, reusing deleted records, number of deleted records,
etc can all be analyzed and see if you give a rat's patootie.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Bob Cozzi" <cozzi@rpgiv.com>
Sent by: rpg400-l-admin@midrange.com
09/11/2002 03:33 PM
Please respond to rpg400-l


        To:     <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: F SPEC to clear a file?


How about this?


 /exec sql
    delete from myfile
 /end-exec


Bob Cozzi
www.rpgiv.com/seminars



-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On Behalf Of Ken.Slaugh@cm-inc.com
Sent: Wednesday, September 11, 2002 3:24 PM
To: rpg400-l@midrange.com
Subject: RE: F SPEC to clear a file?


--

Your solution should be based on the number of records you want to clear
but, I agree on the QCMDEXC solution instead of DELETE opcode. To pull
off the execution of the CLRPFM command then you probably need USROPN on
F-Specs of your output file and OPEN/CLOSE opcodes as well.

(Embedded image moved to file: pic19760.pcx)



                    "Hatzenbeler, Tim"
                    <thatzenbeler@clin        To:
"'rpg400-l@midrange.com'"
                    itech.net>                <rpg400-l@midrange.com>
                    Sent by:                  cc:
                    rpg400-l-admin@mid        Subject:     RE: F SPEC to
clear a file?
                    range.com


                    09/11/2002 12:21
                    PM
                    Please respond to
                    rpg400-l






This message is in MIME format. Since your mail reader does not
understand this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Currently I use the 'C' api for _System to issue the clrpfm command, I
was just looking for a cleaner option, where I didn't have to mix rpg/w
CL via API's to perform such a simple function....

tim.

> -----Original Message-----
> From:         Tyler, Matt [SMTP:mattt@wincofoods.com]
> Sent:         Wednesday, September 11, 2002 12:13 PM
> To:           'rpg400-l@midrange.com'
> Subject:           RE: F SPEC to clear a file?
>
> I would not use any "deleted" operation if you do not want your
> 'deletes" journaled (if you are journaling).  CLRPFM does not clog up
> the journal like a 'delete' operation does, unless that is what you
> want.
>
>
> Thank you,
> Matt Tyler
> Mattt@wincofoods.com
>
> -----Original Message-----
> From: Mark A. Manske [mailto:mmanske@minter-weisman.com]
> Sent: Wednesday, September 11, 2002 13:10
> To: rpg400-l@midrange.com
> Subject: RE: F SPEC to clear a file?
>
> The other side of the coin is to make the file update,
> and run though a loop to delete the records.
>
> Or the coin can be stood on edge, and you could
> code a sql statement to knock out the records.
>
> Or you could jump through a small hoop and
> "call" a C api to do the clear,
> or for that matter any language api that you
> write to perform your desired task.
>
> I know this is not what you are hoping to here,
> but as always there are many ways to get to the
> end of the rainbow
>
>
> Hope this gives you some fat to chew on -
>
> Mark
>
>
> -----Original Message-----
> From: rpg400-l-admin@midrange.com
> [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Tyler, Matt
> Sent: Wednesday, September 11, 2002 1:56 PM
> To: 'rpg400-l@midrange.com'
> Subject: RE: F SPEC to clear a file?
>
>
> Not in RPG as a function.  You must use CL commands either called
> before the RPG or from inside with QCMDEXC.
>
>
> Thank you,
> Matt Tyler
> Mattt@wincofoods.com
>
> -----Original Message-----
> From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
> Sent: Wednesday, September 11, 2002 12:57
> To: 'rpg400-l@midrange.com'
> Subject: F SPEC to clear a file?
>
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Is there an option on the F spec line to clear a file.  I know in C
> when you open a file, you have various attributes, (append, overwrite)

> does RPG have
> such a bit?
>
> Thanks, tim
>
> This e-mail message, including any attachments, is for the sole use of
the
> intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review; use, disclosure or distribution

> is prohibited.  If you are not the intended recipient, please contact
> the sender by reply e-mail and destroy the message.
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> 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@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> 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@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> 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@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
This e-mail message, including any attachments, is for the sole use of
the intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution
is prohibited.  If you are not the intended recipient, please contact
the sender by reply e-mail and destroy the message.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@midrange.com To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



--
[ pic19760.pcx of type application/octet-stream deleted ]
--

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@midrange.com To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
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@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.