Administrator Tip: New Query function can boost productivity

[Search400.com]

Title: Administrator Tips

February 03, 2005 Published by  Search400.com    Administrator Tips Issue Sponsored By:   >  Data Center Decisions IN THIS ISSUE:   >  New, undocumented Query function can boost your productivity   >  Take control of Query   >  Set up flexible user queries using CL and Query Manager   >  Query feature helps you produce reports faster   >  Two ways to validate packed decimal data   >  How much do you know about the iSeries Graphical System Debugger?   >  IFS security -- Are you prepared? New, undocumented Query function can boost your productivity [Search400.com] by Ron Turull If the use of Query for iSeries is a part of your daily iSeries chores, then a new function introduced in V5R3 could spell big gains. The new function -- Length -- returns the length of its argument, and it is essential when transferring data to other systems.     Attend Data Center Decisions 2005 Join us in New York for Data Center Decisions 2005. Learn about the latest technologies for the data center, get top advice from industry experts & win a new Mercedes SLK. Register today.     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 shows 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. Set up flexible user queries using CL and Query Manager [Search400.com] Find out how you can provide end users with flexible query options using CL and Query Manager on the iSeries; including the ability to ignore non-selected criteria. 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. Two ways to validate packed decimal data [Search400.com] Sometimes it is necessary to validate packed decimal data before attempting to use it. Search400.com member Nick Hobson shows you two ways to do it. ITKNOWLEDGE EXCHANGE:  How much do you know about the iSeries Graphical System Debugger? ITKnowledge Exchange member "Dalibor" is getting stuck on the "Add System" dialog box step of the debugger. Read the post, and if you have experience with this tool, let us know and we'll post your advice. LIVE EXPERT WEBCAST:  IFS security -- Are you prepared? When: Thursday, Feb. 3 at 2pm EST (19:00 GMT) Speaker: Carol Woodbury, president, CEO, SkyView Partners The IFS is one of the most ignored areas when it comes to security. But now that more products and OS/400 functionality are implemented in the IFS, ignoring it could put you at risk. SURVEY:  User poll: iSeries revenue decline IBM blamed the continued slide in iSeries revenue to the slow transition to i5, implying thing will eventually turn around. Are you optimistic or is IBM fighting a losing battle? Vote now   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: Programmer 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 "Administrator Tips": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?cid=503654&lid=430676&track=NL-176&ad=503654 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