"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

You Might Also Like
SKUDONET Open Source Load Balancer Icon
SKUDONET Open Source Load Balancer

Take advantage of Open Source Load Balancer to elevate your business security and IT infrastructure with a custom ADC Solution.

SKUDONET ADC, operates at the application layer, efficiently distributing network load and application load across multiple servers. This not only enhances the performance of your application but also ensures that your web servers can handle more traffic seamlessly.
Rate This Project
Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
1
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 5 / 5

User Reviews

  • Very interesting and very ingenious, it is being very useful in a system that I am creating. Congratulations to the creator and the people who contribute ideas to our community of programmers. Greetings from Mexico. Jose Meza
  • 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