|
midrange.com
Make that:
/exec sql
delete from mylib/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 Bob Cozzi
Sent: Wednesday, September 11, 2002 3:34 PM
To: rpg400-l@midrange.com
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.
