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.
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.
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.