Submitted by Anonymous (not verified) on Fri, 07/25/2008 - 00:00 Forums IceBreak Any know where I can get some code that will go through libraries and report files with deleted records? I could re-invent in the wheel, but thought I'd check to see if someone could help save time. Re: Deleted Records Report just write a quick CL : DSPFD *ALLUSR/*ALL TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(mylib/myfile) then you can run a query over the file selecting where MBNDTR <> 0 Experience has it's benefits...unfortunately by the time you acquire it you've forgotten what you needed it for -Tommy Holden Log in or register to post comments Re: Deleted Records Report http://www.code400.com/rgzpfm.php http://www.code400.com/forum/showthr...eleted+records All my answers were extracted from the "Big Dummy's Guide to the As400" and I take no responsibility for any of them. www.code400.com Log in or register to post comments Re: Deleted Records Report Thanks, I knew the command Tom, but was hoping someone had a link with a little more meat to it. Thanks, jamief. Log in or register to post comments Log in or register to post comments
Re: Deleted Records Report just write a quick CL : DSPFD *ALLUSR/*ALL TYPE(*MBR) OUTPUT(*OUTFILE) OUTFILE(mylib/myfile) then you can run a query over the file selecting where MBNDTR <> 0 Experience has it's benefits...unfortunately by the time you acquire it you've forgotten what you needed it for -Tommy Holden Log in or register to post comments
Re: Deleted Records Report http://www.code400.com/rgzpfm.php http://www.code400.com/forum/showthr...eleted+records All my answers were extracted from the "Big Dummy's Guide to the As400" and I take no responsibility for any of them. www.code400.com Log in or register to post comments
Re: Deleted Records Report Thanks, I knew the command Tom, but was hoping someone had a link with a little more meat to it. Thanks, jamief. Log in or register to post comments
Re: Deleted Records Report
just write a quick CL :
then you can run a query over the file selecting where MBNDTR <> 0
Experience has it's benefits...unfortunately by the time you acquire it you've forgotten what you needed it for -Tommy Holden
Re: Deleted Records Report
http://www.code400.com/rgzpfm.php
http://www.code400.com/forum/showthr...eleted+records
All my answers were extracted from the "Big Dummy's Guide to the As400"
and I take no responsibility for any of them.
www.code400.com
Re: Deleted Records Report
Thanks, I knew the command Tom, but was hoping someone had a link with a little more meat to it.
Thanks, jamief.