clearing multple members in a physical file
Does anyone know of a way (or utility) to clear multiple members in a physical file ? i create multiple members for the file on the fly based upon date/time in a cl program. the file is a weekly archive of data from a transaction processor, and i want to clear it and start over on a weekly basis. i know i can handle this in rpg400, but i don't want to !
mike
Software/Hardware used:
Software/Hardware used:
ASKED:
February 10, 2009 8:17 PM
UPDATED:
February 14, 2009 7:53 PM
Answer Wiki:
Are you sure that you want to clear the members
I would think that you want to remove the members
would the *ALL in RMVM command do the trick?
Remove Member (RMVM)
e choices, press Enter.
a base file . . . . . . . . . Name
ibrary . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
ber . . . . . . . . . . . . . Name, generic*, *ALL
Phi
after thinking about it you're right. i want to remove them. thanks for the response !
mike
To see all answers submitted to the Answer Wiki: View Answer History.
Hi,
You can also use CLRPFM :-
CLRPFM FILE(yourlib/yourfile) MBR(*ALL)
Regards,
Martin Gilbert.
Thanks Martin, but i don’t have the *ALL option on the clrpfm command. only *FIRST, *LAST or MEMBER name.
mike
Hi,
Maybe it’s something new – I hadn’t noticed it before. We’re on V5R4.
Regards,
Martin Gilbert.
We’re at V5R3 and we have the option of clrpfm member *all
MBR(*ALL) not available till V5R2
Without *all you would have to use dspfd *mbrlist to an outfile
read that file into a cl and use cLRPFM or RMVMBR on each member
Phil