WRKDBF replacement?

145 pts.
Tags:
SQL
WRKDBF
Does anyone know of a good, free alternative to WRKDBF? I've been using it for years. However we just upgraded our business software. In this new version it has ISO date fields. For those fields that are null (essentially are 0001-01-01), WRKDBF can't handle it and blows up. I'm NOT a programmer by any means and haven't ever been able to figure out SQL. TIA!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

If you’re not a programmer – why do you need WRKDBF? You shouldn’t really be altering data in the files of your application unless you’re a programmer/developer and have an understanding of the effects of such changes. I doubt that the suppliers of your business software would be happy for you to be using something like WRKDBF on their files. If they request for you to do something like this, then I would ask them what tool do they use.

If you only need to look at the data then you should be able to use Query.

Regards,

Martin Gilbert.

Discuss This Question: 23  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Mrnaturl
    That certainly didn't answer my question. As I previously mentioned, I've been using WRKDBF for years. Therefore I must know something about data files, changing them and the effects. Regardless if one is a programmer or not, it IS possible for one to have an understanding of the effects of changing data files. It is also possible for one to know a little something about programming, but claim NOT to be a programmer. For instance, just because I know how to code CL (which I do), that doesn't truly qualify me as a programmer. I couldn't pass myself off as a programmer to another programmer. However I could fully support a programmer walking in the door knowing nothing about our data and having to work on a project. I can read RPG programs, I just can't write them. Ok, so maybe that doesn't make sense ... but it's reality. Since the author stopped production of his WRKDBF tool and has no plans in the forseeable future to bring it back, I am looking for an alternative that will work with null ISO date fields. Any "helpful" information would be appreciated. Thank you!
    145 pointsBadges:
    report
  • Modiyooch
    I'm unclear on the question. We have WRKDBF and we also have date defined fields. WRKDBF works fine on these files. Is it blowing up because of invalid data in the date type fields? If so, don't you need to correct the data and the programs creating junk date fields? Do you also have character data in numeric fields? Sorry for the confusion, but it sounds like the problem is not with WRKDBF but with GIGO.
    540 pointsBadges:
    report
  • Gilly400
    Hi, I suggest you ask the supplier of your business software what they use, since it is their software that is putting null values in date fields, they probably have experience of manipulating the data. I STILL don't think it's wise to be altering the data created/maintained by a software package. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Gilly400
    Incidentally, have you tried DFU with these files? I know it's not as powerful as WRKDBF, but it might let you get around your problem. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Mrnaturl
    Sorry, I'll try to be a little more explanatory here. The date fields aren't being populated with junk. In fact they aren't being populated with anything, except for 0001-01-01, because whatever procedure that has to happen, has not as of yet. For instance, if product has not shipped yet on a new item, then Date Of Last Sale has to be null or 0001-01-01 .... which is it. However WRKDBF does not seem to be able to handle that. Previously, in the software makers last version, that date field would not be an ISO date (it would read 20081231) and it would simply be blank for a new item with no sales. WRKDBF worked perfect with that. Yes, DFU would work .... however it's not conducive to using for mass changes. For instance, if we decide to change Product Classes on a couple thousand items, WRKDBF could perform this switch in seconds. SQL could also, but I'm not familiar enough with SQL to do this. As an aside the software vendor states, that is how their ISO dates are supposed to read (0001-01-01) for the scenario above. They looked at the data and said "Everything is perfectly fine in your data files. You can do this with DFU (if you want to spend the next 2 years doing it), find another alternative to WRKDBF or learn SQL to make mass changes like that". I told them ..... "ummm ok .... Long as you are positive the data is all valid, not much I can complain to you about."
    145 pointsBadges:
    report
  • Gilly400
    Maybe this link will help Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Gilly400
    Hi, Here's another possibility. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Modiyooch
    Something else has to be the problem. I just ran a test with WRKDBF and date defined fields. I changed the date to the default null value of '0001-01-01' , ended the program and then changed the record again. I am not experiencing the problem. BTW: We can quickly bring you up to speed with interactive SQL.
    540 pointsBadges:
    report
  • astradyne
    Hi WRKDBF is now available again from the WRKDBF site and is available as shareware for V6R1 of the operating system. Like others, I use WRKDBF with date fields and nulls and don't have an issue. Best regards Jonathan
    370 pointsBadges:
    report
  • Geekprime
    Since WRKDBF was unavailable, well ok I have a copy, but I wanted to write my own, which is now finished and in testing. But I don't feel it's ready enough for anyone else to use. So a great alternative that I always liked is a comercial one calle EZVIEW, same company that makes all the robot products. Also SQL is great for quick mass updates, but be carefull with it. make a backup of your file first. my clone of WRKDBF ignores data decimal errors and null fields. treating them as blank character fields. But check out EZVIEW, not sure what it costs but works great. I've heard DBU works good too but have no experience with it. MikeC
    275 pointsBadges:
    report
  • Cwc
    I used EZVIEW several years ago, and recall that is has some functions which DBU does not. EZVIEW allows records to be updated in a full screen mode, and can also replicate an existing record. I have not discovered how to do this in DBU, if there is a way. But DBU is a good product.
    4,290 pointsBadges:
    report
  • Geekprime
    my clone of wrkdbf / ezview does allow replication of existing records as well as having a, change, delete, view, and add function. It is written in rpgile and works well on the latest version of the OS so far but every once in a while I discover a small bug. If I ever get to the point where I feel it is bug free, then I may release it as a free download like wrkdbf used to be. I went to wrkdbf.com and can't get that page to load, someone mentioned that it was available again but I don't see it.
    275 pointsBadges:
    report
  • Mrnaturl
    Thanks all!! Agreed, I do not see WRKDBF available again either. Unsure where he got his info but that link supplied just provides a "Cannot diplay this web page" error. Downloaded Surveyor/400. Used it many years ago but don't remember much about it. So, what they hey, it's a free trial, I'll do it again!! Now if I can only find the time to play with it!! EZVIEW was tough to find. If that's what it was called back then, they changed it to EASY VIEW. Once I came back here and read the rest of your message, this part "same company that makes all the robot products" gave me the immediate clue as to where to look. I've been looking at them (HelpSystems) for their SEQUEL report writing product.. They have a lot of nice products .... but, alas, I have no budget. Which is why I keep searching for a WRKDBF freebie. I may download and hopefully have some day to try the DBU product. Again, thanks for everyone's help. Much appreciated! Geekprime ..... some of us who work with Microsoft products daily are used to bugs. So .. your product is bug free, let it loose!! ;)
    145 pointsBadges:
    report
  • Znason
    TAATOOLs Telephone: 914-251-9494 Fax: 914-253-9413 Web site: www.taatool.com E Mail: sales@taatool.com
    460 pointsBadges:
    report
  • Geekprime
    One of these days, I'll put up a website with a download link to my as400 file editor. Too bad the wrkdbf name is already taken. but thats ok, I came up with a better name :P
    275 pointsBadges:
    report
  • Wammes98
    Take a look at an opensource product: http://www.squirrelsql.org/ and select the db2 plugin when you install it... if you use this and install the jt400.jar as the driver for it, you can access any I-series db2 database from your local pc.. user the jdbc:as400://<servername> for your connection url. Hope this helps.
    10 pointsBadges:
    report
  • KJB
    I have looking at the forum for a few days now and hoping that someone would come up with how to find WRKDBF. I currently have FF Plus http://www.bcdsoftware.com/iseries400solutions/file-flashplus and FEU http://www.alcsoftware.com/feu/information.php on trial. No comment to make as its early days but doesn't seem as intuitive as WRKDBF but then I had used WRKDBF for years! I didn't load Easy View as the cost is significantly higher £2000+ for a 515 so its on hold. Another freebie is PEEK/400 and its not bad http://www.tools400.de/English/Peek_400/peek_400.html BUT What I realy want is WRKDBF and I am sure there are many out there who are willing to pay so can someone tell me how to get a copy at a reasonable price. Geekprime - you say you have a utility - my company is willing to put some time into getting it bug free and again I am sure there are other people who will be willing to test/contribute. The other thing is whatever happened to YWRKF from SYNON? I guess this could be another megaprice offering.
    10 pointsBadges:
    report
  • Geekprime
    Hi JKB, drop me an email at talondesforges@gmail.com and I can get a copy of wrkdbf to you.
    275 pointsBadges:
    report
  • astradyne
    WRKDBF is available for v6r1 of the operating system. The author though has been having some problems with his ISP and the www.wrkdbf.com domain name. If you check the midrange.com archives for the MIDRANGE-L list and search for "WRKDBF is baaack" you can find the thread. It also says to contact the author, Bill Reger, directly for a shareware version. Jonathan
    370 pointsBadges:
    report
  • HankHunter
    You might want to check out the "FEU" product. It's been around for a long time and I've used it at different places over the years. They have a free demo download at www.alcsoftware.com/feu
    55 pointsBadges:
    report
  • Brianpick
    Linoma Software provides a free single user license of Surveyor/400. It can be downloaded from here: http://www.linomasoftware.com/products/surveyor Besides graphically editing database files, it allows you to quickly import and export data to/from the IBM i (much easier and faster than Client Access). It has a SQL module for executing statements and the spooled file module allows you to view and convert text spooled files to a PDF or TXT format. An unlimited user license starts at $995 for a P05.
    55 pointsBadges:
    report
  • Mrnaturl
    I ended up purchasing WRKDBF for V6R1. Also got the higher ups to understand the need for Robot Systems' SEQUEL and purchased that product also. Thanks all for your help!!
    145 pointsBadges:
    report
  • ambusy
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following