With TurboQuery/400 you will supercharge your queries, saving time and processor resources. Upon completion you will: 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 132 columns. 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.

Turbo Query/400: Automating & Enhancing Turbo Query/400

Computers & Technology

G. Wayne Hawks

Software

Rochester Initiative

Quickly and easily modernize iSeries reporting with Microsoft Excel with the iSeries. 
This is practical training developed in a real working environment and used on a daily basis. Learn to get any file into an Excel spreadsheet, to use Query/400 to "filter" what records to put into Excel, to use the AS/400 IFS to copy information into Excel, to call programs on the iSeries on your PC using RMTCMD, and to click a button in Excel and open other PC programs, other spreadsheets, even web-sites. 
This course comes with an illustrated manual and a CD containing all the exercise source code, a complete Excel workbook with buttons to run queries and a sample user request workbook for creating clearly defined user requests that will make your job easier. 
Media: Self-paced manual with source code CD. Estimated completion time: 12 hours.

Microsoft Excel with the iSeries

Operating Systems

Talk about smiling managers and happy users! Now you can create better looking, easier to read and understand RPG report printouts with graphics, fonts, underlines, and bolding using Microsoft Word with the iSeries! Create Microsoft Word templates that contain graphics, fonts, bold text, and underlined text that can be saved to the Integrated File System (IFS) on your iSeries and copied directly into OS/400 Database files. Create and use RPG programs to modify the contents of those physical files, merge information from other files into the appropriate documents (based on your organization's rules), and then store them in appropriate folders on your IFS. Create better looking, easier to read and understand RPG report printouts with fonts, underlines, bolding, and graphics and a lot more. Media: Self-paced manual with source code CD. Estimated completion time: 4 hours.

Microsoft Word with the iSeries

See the best price to sell, buy, or rent books by G. Wayne Hawks. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by G. Wayne Hawks

See the best price to sell, buy, or rent books by G. Wayne Hawks. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Turbo Query/400: Automating & Enhancing Turbo Query/400

Microsoft Excel with the iSeries

Microsoft Word with the iSeries