Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Has anyone here downloaded WRKDBF from wrkdbf.com? I want to be able to view deleted records in a file and found this. I want to hear some rave reviews or concerns before I load it to production to help me investigate an issue.
Gracias!
Chris
Darn!! The command will only display deleted records for non-keyed files! So much for that!
are you certain? i remember using this product years ago and most of my files were keyed. you just had to be able to scroll through the file to get to them.
the only issue we ever had was if the file was set to reuse deleted record, the keyed record could be overwritten, just as a non-keyed file.
-sarge
You can display the deleted records of keyed files by changing the access method to relative record number. On the WRKDBF command line at the top of the screen, use "C ACCESS" to change the access method, or when issuing the WRKDBF command, use the *RRN option of the access method parameter.
...or use DBU
Thanks, Brian. I'll try that. I was reading thru the documentation and it says that F17 is only available for non-keyed files. Bob, I wish we had DBU! We have VIEW where I work now and don't like it!
VIEW? Can't find it on google. What is it?
I have a similar shareware product,
http://digilander.libero.it/ambusy/computerWD.html
lacks Undelete, but that's to be found at
http://www.dbg400.net/foswiki/bin/view/DBG400/UndelVersion2
I remember using something called VIEW many years ago and I kinda liked it, but I think it was one of those freebie utilities we dumped when it showed up on the list when we ran ANZOBJCVN as we were converting to i6.1. Now I use DBU and I like Surveyor/400 from Linoma even better but I don't recall if it can view deleted records... haven't had that need in a long time.
Follow-up: Just remembered the full name of the one we had was Yulee View. This is the only reference I find to it:
https://groups.google.com/forum/?fromgroups=#!topic/comp.sys.ibm.as400.misc/K9rY8GhtBx8
Not sure if this is the same one referred to in this thread.
I don't know why you would bother with it today. It is no longer freeware, therefore spending $500 US dollars on it would need to be justified, just like any products, such as DBU.
Anyone know what a DBU license costs today? Is it higher than $500 per system?
I use EZVIEW since DBU went expensive. EZVIEW is a bit 'rough around the edges', has no great interface and is not the nicest tool to work with (being gentle here...) but it's free at last. Dunno if you can see deleted records.
Never saw Easy View from Help/Systems until just now. Thanks Paulster.
The Linoma Surveyor/400 is free for a one-user license, although you do need to keep getting new freebie keys every 3 months or so. It works very well, looks good, and has lots of functionality.
Surveyor looks like an easier iSeries Nav product. That's good. But I don't see how it would allow you to edit and then UNDELETE a record in a file.
Surveyor/400 is for me a replacement for both System i Navigator and DBU (although I do also have both of those). And I just checked, and it actually has an undelete function. However, strangely enough the documentation says it only works on V5R3 or lower, and I just tried it and sure enough it gave me that same message (I'm on i7.1). So obviously something relevant changed in V5R4 that affected that functionality.