Download
"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
License
Public DomainFollow Query for Free
Other Useful Business Software
$300 Free Credits for Your Google Cloud Projects
Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
Rate This Project
Login To Rate This Project
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
