AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage

IBMi and AS400 Training
HOME >> Training Catalog >> Turbo Query/400

Turbo Query/400 (TQRY)
Author: G. Wayne Hawks

Automate & Enhance Query/400,
save time & processor resources
For a two minute overview of this training click play.

12 Labs and DataFinder Utility All RPG, DDS and CL Source Code Included!

With TurboQuery/400 you will supercharge your queries, saving time and processor resources.

You will learn how to quickly and easily:

  • Automate, document, and organize your queries.
  • Reduce the impact on your system resources from Query/400 queries.
  • Run a group of queries with one command and no modification to any of the queries even if they check for date ranges!
  • Open query reports directly in MS Excel. Stop re-keying into Excel from paper printouts. Put all the information you want on a report. Go way past the width limit of paper printouts.
  • Schedule running of one or a series of queries at your choice of date and time.
  • Receive an email notification when queries are complete!

Don't have time to take the training? Simply Load, Compile and Go using the easy-to-follow instructions!

Bonus Utility Included!

The included DataFinder utility allows you to search file and field text descriptions using the key words you specify. You'll quickly find precisely the data you need to query. For Example, your boss wants a report on rebate totals in one hour, but you didn't even know rebates existed! No problem. Just call up the DataFinder and type "rebate" into the field text search. DataFinder will quickly display all the fields containing the word "rebate." Next, you'll verify that the files have current data by reviewing when they were last used. Then, write your query, keep the boss happy, and quickly return to your other critical projects.

It Works!

You can now run a group of queries with one program selection and only enter the date range once for all the queries in that group. You can still see which date range was last used, the last time the group of queries ran, who ran the group, and when it ran. This will increase the accuracy of your querying and reduce the impact on your system resources by submitting all the queries, rather than running them interactively. You can even receive an e-mail when a query completes.You get all this plus the bonus DataFinder utility with source code!
The big illustrated manual comes with easy to follow instructions, complete with screen shots and source code. You also get 12 Labs with all the RPG, DDS and CL source code included on a CD.
This practical training, developed in a real working environment, is guaranteed to save you time and make your job easier.

Click Here  to view the Table of Contents

Skill Level: Some experience with computer programming and OS/400 DB2 database. Any RPG programmer with 1 or more years of experience will be able to successfully complete this course. Some Microsoft Office Suite experience a plus.  This course is not intended for end-users or for novice programmers.

Turbo Query/400 (TQRY)
Author: G. Wayne Hawks

Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2