The iSeries Blog

Aug 7 2007   8:50AM GMT

iSeries utility FROG user review, pt. 3

Adam Trujillo Profile: Atrujillo

We recently asked users to review Innovative Systems’ iSeries database utility F.R.O.G. Here is one of the responses we received.


I saw this utility and downloaded it. It is better than WRKDBF and DBU. The best thing I like is the Windows component added to this utility.In this era of windows, green screen is becoming obsolete and people like windows based applications and utilities. So FROG is the answer to all users using green screen based utilities for files.

I would give 5 out of 5 to the developers.

Keep up the good work. Thanks.

–A.B.

8  Comments on this Post

 
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 other members comment.

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
  • Atrujillo
    I never knew that more colors and a mouse make a product better in and of itself. You sound like my users. Don't get me wrong FROG works great, but not because its a windows app and/or its written in java. The ERP product my company uses has a JWalk screen scraper utility the runs over our apps, the (L)users love it even though half of the functionality disappears.
    0 pointsBadges:
    report
  • Atrujillo
    Colours and a mouse often make an application much more accessible. For many classes of user, a Windows application is much more approachable than a green screen. Not for the experienced "power user" perhaps, but for most of the others.
    0 pointsBadges:
    report
  • Atrujillo
    I have found that AS400 Expert is eaiser to use. It is Windows based and has rarely failed. Check it out at. http://dartclub.tripod.com/as400expert.htm
    0 pointsBadges:
    report
  • Atrujillo
    I've tried Frog, it's OK, but what works better for me is the "Run SQL Script" that's part of iSeries Navigator. If you have the full version installed, you can put a text file on your desktop with the extension ".sql" and use it to launch the SQL scripts without starting navigator. This tool allows me to keep multiple SQL statements on the screen, separate them with a ";" and if I want, execute them all in sequence. It also allows me to save them as a text file so I can refer to them later... Main downside... gotta remember that it's library.file not library/file!
    0 pointsBadges:
    report
  • Atrujillo
    I agree with Number 4. Frog is clever but I'll probably stick with Navigator scripts for mass changes, and WRKDBF for a few records.
    0 pointsBadges:
    report
  • Atrujillo
    I just started playing with the Data perspective in WDSC. Not sure how you'd use it for editing a single record, but it appears to be pretty nice for browsing data (including running SQL).
    0 pointsBadges:
    report
  • Atrujillo
    I also agree with No. 4. The iSeries Navigator query tool is by far the best utility for running queries. You'll never go back to the green screen equivalents once you get used to it. FROG is OK - maybe it will rival Navigator in time.
    0 pointsBadges:
    report
  • Atrujillo
    Just to comment on 4, but FROG also has the ability to run SQL scripts. In addition, those scripts can contain imbedded "substitution variables" that can be supplied at run time. You can also: * Issue CL commands from within FROG scripts (which I believe you can also do with iSeries Navigiator scripts tools). * Download results to your PC in one of several file formats. * Run PC commands (such as "Open" or a specific program) And you can run these scripts with FROG completely unattended...FROG will sign on to the target machine, execute the script then sign off.
    0 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: