Midrange News for the IBM i Community


Posted by: Chris Proctor
Programmer Analyst
Columbia Sports Company
Portland, OR
WRKDBF command???
has no ratings.
Published: 22 May 2012
Revised: 21 Feb 2013 - 1494 days ago
Last viewed on: 26 Mar 2017 (5480 views) 

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.

WRKDBF command??? Published by: Chris Proctor on 22 May 2012 view comments(14)

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

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: chrisp
Premium member *
Portland, OR
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 19 hours 31 minutes ago

Darn!! The command will only display deleted records for non-keyed files! So much for that!

Posted by: sarge
Premium member *
United States
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 19 hours ago

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

Posted by: BrianR
Premium member *
Green Bay, WI
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 17 hours 52 minutes ago

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.

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 16 hours 56 minutes ago

...or use DBU

Posted by: chrisp
Premium member *
Portland, OR
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 14 hours 41 minutes ago

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!

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: WRKDBF command???
Posted: 4 years 10 months 3 days 10 hours 35 minutes ago

VIEW? Can't find it on google. What is it?

Posted by: ambusy
Premium member *
Comment on: WRKDBF command???
Posted: 4 years 1 months 19 days 59 minutes ago

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

Posted by: Viking
Premium member *
CA
Comment on: WRKDBF command???
Posted: 4 years 1 months 18 days 21 hours 38 minutes ago
Edited: Mon, 04 Feb, 2013 at 12:15:57 (1511 days ago)

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.

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: WRKDBF command???
Posted: 4 years 1 months 18 days 14 hours 4 minutes ago
Edited: Thu, 21 Feb, 2013 at 13:04:47 (1494 days ago)

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?

Posted by: Paulster
Premium member *
Sweden and The Netherlands
Comment on: WRKDBF command???
Posted: 4 years 1 months 18 days 7 hours 52 minutes ago

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.

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: WRKDBF command???
Posted: 4 years 1 months 17 days 22 hours 34 minutes ago

Never saw Easy View from Help/Systems until just now. Thanks Paulster.

Posted by: Viking
Premium member *
CA
Comment on: WRKDBF command???
Posted: 4 years 1 months 17 days 21 hours 53 minutes ago

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.

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: WRKDBF command???
Posted: 4 years 1 months 17 days 21 hours 45 minutes ago

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.

Posted by: Viking
Premium member *
CA
Comment on: WRKDBF command???
Posted: 4 years 1 months 17 days 18 hours 34 minutes ago

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.