I need a FILE EDIT UTILITY. Flex/edit? FEU? Help!

[Guest.Visitor]

I am a new AS/400 user and I need a good file edit utility. I need to be able to edit record by key, record number and GLOBALLY based on parameters. I am migrating from a S/36 and I am used to a product called SFP (System Fire Power) by the Worth Group. Anyway it is easy to use and has UNDO. CAN ANYONE GIVE ADVICE? ANY AND ALL COMMENTS ARE APPRECIATED.

[dchristie]

www.prodatacomputer.com has DBU. Also if you are in to SQL they have SQL/PRO. We use both these products with great results.

[Guest.Visitor]

You might try www.wrkdbf.com

[D.Handy]

David, <font color=blue>I am a new AS/400 user and I need a good file edit utility. </font> Flex/edit is generally used as a text editor for source members as a replacement for SEU. It's very good at what it does, including editing binary files on a PC, but it is the wrong tool for this job. I'd suggest getting a copy of a freeware product called WRKDBF (Work with Database File). It does most of what you want, other than undo. Global changes are done via SQL commands (even if you don't have the SQL program product on your system). More information and install packages for either CISC or RISC systems can be obtained from www.wrkdbf.com Doug

[B.Myrick]

David, Go to www.prodatacomputer.com They have a product called DBU (DataBase Utility), that lets you be in up to four files at once, doing updates on the current window. Their window actually splits the screen display into 1, 2, 3 or 4 sections. It's kinda cool for green screen. Also, you can download a working demo from their website. Best of all? It is dirt cheap compared to the other stuff on the market. You can search for records by criteria or by key. Update one or multiple records. Delete one or multiple records and you can control the access via their user security file. Has a bit of query overhead when reading through large files, but it is well worth the money. Later, Bret Myrick

[Guest.Visitor]

I use WRKDBF and love it! You can't beat the price either! (It's free). Check out www.wrkdbf.com (http://www.wrkdbf.com) ==Scott==

[nycsusan@hotmail.com]

I like the Easy View product from HelpSystems. Great, flexible tool, but it's not free as some of the other suggestions are. But, sometimes you get what you pay for. Here's the URL that describes the features of the product: http://www.helpsystems.com/products/easyview.html

[T.Holt]

Linoma Software sells a GUI database manager that includes a file editor. It lets you edit in a grid that looks like a spreadsheet. You can filter out just certain records and change them all at once, things like that. Click <a > href="http://www.linomasoftware.com">here</a> for more info.

[Guest.Visitor]

I second the motion for DBU. Combined with SQL and I am a danger to databases everywhere. As far as an undo procedure, I don't know of a utility that provides this.

[Guest.Visitor]

I use FEU by Applied Logic and can save deleted records in a file if I chose to do so. I went directly from POP to this with no problems.

[daly.michael@verizon.net]

John S Panzenhagen wrote on 05/19 at 01:42 PM : <font color=blue> I second the motion for DBU. Combined with SQL and I am a danger to databases everywhere. </font> Ditto. DBU rocks! You can even set up all four files into specific column views and save them as DBU applications. This eases setup for repeated file maintenance like when debugging apps. Michael

[Guest.Visitor]

RDR from dbu will retrieve deleted records. Is that what you need???

[David Abramowitz]

I am currently using FEU, and I have used DBU in the past. They are both very good. Dave

[Guest.Visitor]

I evaluated these a while back and at the time EZview & DBU were the best. The graphical one sounds interesting, it wasn't available at the time.

[Guest.Visitor]

Ezview chokes on Float and Null because it is written in RPG. I didn't use DBu enough to find out, but in general their software is well designed. I inquired about float and null fields at Surveyor/400 and have not received a reply yet.. bobh

[Guest.Visitor]

We use FEU Pro. It's pretty good, but doesn't have multiple screens at once (I think), has some internal functions that I wish they also supplied as external commands (listing a PF's logicals and their keys/select/omit/unique), and it chokes on null-capable fields (or maybe only such fields when they have an actual null value). Pretty good, could be a little better.