Programmer Tip: Take control of Query

[Search400.com]

Title: Programmer Tips

October 06, 2004 Published by  Search400.com    Programmer Tips Issue Sponsored By:   > Aldon   > Profound Logic Software's RPGsp IN THIS ISSUE:   >  Take control of Query   >  Queries creating a new temporary access path   >  Use the CHGQRYA command to help lessen interactive workloads   >  Improving OPNQRYF performance   >  Query feature helps you produce reports faster   >  Get answers to your questions fast   >  September tip winners announced   >  Accepting nominations now Take control of Query [Search400.com] Most iSeries sites have a lot of Query/400 users, and most iSeries sites have to put up with the headache of users running the killer interactive query that brings response times to its knees. What can you do to make this situation better? Paul Tuohy show you how to create your own version of the WRKQRY command that allows you to determine how much time should be allotted for interactive queries. MORE INFO: > View previous tips by Paul Tuohy   The Natural Selection for Enterprise Change Management In the new climate of regulatory compliance, enterprise change management has become an increasingly complex animal. If you're not taking steps to comply with the Sarbanes-Oxley Act, you might soon find it's a real jungle out there. The survivors are those who rely on Aldon software to automate complex compliance and development process control procedures. Click for our free Sarbanes-Oxley White Paper.   Queries creating a new temporary access path [Search400.com] A user said he would like to be able to find out which queries are creating a new temporary access path during any given day. What should he do? Site expert John Brandt details one option. Use the CHGQRYA command to help lessen interactive workloads [Search400.com] If your shop allows users to create and run their own queries or if your systems include many predefined queries that users run often, you may want to consider using the Change Query Attributes (CHGQRYA) command to help lessen interactive workloads. Improving OPNQRYF performance [Search400.com] To improve OPNQRYF performance Search400.com member David Moore says, "In an interactive session, enter STRDBG. Then run a CL containing the OPNQRYF that needs to be improved. What will happen is, the query optimizer will place messages into the job log that explain what actions it took to optimize the query. Also, it makes permanent performance recommendations." Read his full tip to get all the details. Query feature helps you produce reports faster [Search400.com] Many of us use query every day for various reporting needs. We may want to report what orders were shipped, what products were produced or any type of daily activity that is important to our organization. As part of query that IBM placed on the iSeries, you have a way to let the queries that you build decide what day it is. Find out how you can define a field as the current date so you can avoid manually changing the query each time you run the report. ITKNOWLEDGE EXCHANGE:  Get answers to your questions fast Now you can ask any one of your fellow TechTarget members -- 1.2 million strong -- specific questions on technology, best practices or other IT issues. Just tell us who you are and the subjects you're interested in (iSeries, RPG, DB2, WebSphere, etc.) and then ask your questions or offer advice to other IT professionals. Our ITKnowledge Exchange brings members from all 22 TechTarget Web sites together to share information and experiences.   RPGsp Has Revolutionized iSeries Web Development! - Use numerous Wizards and Over 100 Templates to get started instantly - Create Inquiries, Forms, E-commerce sites, and more - Reuse RPG code and skills -- no proprietary languages to learn - Continually evolving: over 250 new enhancements added in the past year alone - Affordably priced Schedule a Live RPGsp Demo or download a FREE Trial today!   SEARCH400.COM TIP CONTEST:  September tip winners announced Please join in and congratulate this month's winners for the September Tip Contest. The top winner is Karen Hodge. Karen won a hand-held TV and was added to our Hall of Fame for her tip: How to do date manipulation in a CL Congratulations also to our runner-up winners: Drew Dekreon, Vincent Mascarenhas and Itto Cruz. View all winning tips in Search400.com's Hall of Fame. New tips contest for October: We're giving away a Skagen slimline watch. This watch has a sophisticated large black face with chrome arrow markers. It's a chrome-plated, 100% stainless steel case with luxurious black calfskin leather band. It also features scratch-resistant mineral crystal and Japanese quartz movement. So don't waste time, send in your tip today! SEARCH400.COM PRODUCTS OF THE YEAR AWARDS:  Accepting nominations now Have a great product or tool? In January, Search400.com will present its Second Annual Products of the Year awards. The awards will highlight and celebrate those entries in the market that are deemed outstanding examples of new and innovative technological advancement for users. Submit an application to have your product considered. But act fast: The deadline to submit nominations is Monday, Oct. 25.   Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED]     Free E-Newsletters! Select e-newsletters you would like to receive via e-mail!  Search400: Administrator Tips  Search400: Security Tip  Search400: Today's News Not a Member? We?ll activate your membership with your subscription.   This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. To unsubscribe from "Programmer Tips": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?track=NL-17&ad=493348 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search400 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494