|
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 mailing list archive is Copyright 1997-2024 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.