"qryff" is a command that runs on the IBM iSeries (or AS400). It allows you to run SQL queries on the OS400 database from the command line or a CL program. You can output information to the screen, print, or a file. You can also update, delete, insert, and whatever else the iSeries query engine supports.

Technically, it is simply an interface to the operating system's "Start Query Management Query (STRQMQRY)" command. I wrote this back in the 1990's and it's been freeware since.

Project Samples

Project Activity

See All Activity >

License

Public Domain

Follow Query for Free

Query for Free Web Site

Other Useful Business Software

ManageEngine now lets you patch computers from cloud ManageEngine now lets you patch computers from cloud Icon
ManageEngine now lets you patch computers from cloud Icon

ManageEngine Patch Manager Plus offers patching capabilities on cloud - Patch all OS updates and 550 third party apps on-demand and stay secure!

Last year saw the hackers unleash their expertise in skills for a ransom - targeting those unpatched computers in data-critical institutions. Only if the computers were patched on time, billions of dollars could have been saved. ManageEngine’s Patch Manager Plus comes to your rescue, offering you an automated patching solution, now on cloud, for latest hotfixes of Windows updates and a wide range of third-party applications (over 550 of them).
Automate patching with Patch Manager Plus, sit back & relax!
Patch On Cloud Now

Rate This Project

Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
0
0
1
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

  • very good. i use a similar tool "RUNSQL" From "Power Tools for the AS/400, Volume II," Duke Press. Author : Dan Riehl that tool had a similar problem with "spaces" mostly if the space was the first character in the variable IF COND(%SST(&LINEX &IX 1) = ' ') THEN(DO) /* + 55 byte boundary is a blank */ CHGVAR VAR(&IX) VALUE(&IX + 1) /* Add extra blank */ might be helpful in fixing your tool. Bryan

Read more reviews >

Additional Project Details

Intended Audience

System Administrators, Developers

User Interface

Command-line

Database Environment

IBM DB2

Registered

2012-12-31