=============================================== SEARCH400.COM DEVELOPER TIP May 23, 2001 More developer tips at: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f9,00.html =============================================== SPONSORED BY: ARCAD Software =============================================== FREE and Fully Functional Source Code Analyzer (SCA) for RPG, COBOL and ILE Developers. The ARCAD SCA is a UNIQUE and powerful tool that presents your program in a graphical form allowing its logical management rules to be broken down and analyzed with more ease, dramatically reducing the time and resources you spend on maintaining your AS/400 applications. Search400.com members can download a FREE, single-user license of the ARCAD Source Code Analyzer at http://www.arcadsoftware.com/ --------------------------------------------------------- TIP OF THE MONTH CONTEST: Enter to win a Toshiba DVD player --------------------------------------------------------- Submit a technical tip and automatically enter to win a Toshiba DVD player. At the end of the month we will select a winner. So, if you haven't already submitted a tip, now's the time to do it. Submit your tip now http://search400.techtarget.com/tipsSubmit/1,289485,sid3,00.html Once you've submitted your tip, don't forget it needs to be rated by search400 members to compete. Encourage your peers and co-workers to check it out. All tip categories can be found at http://search400.techtarget.com/tips/0,289484,sid3_tax2f7,00.html --------------------------------------------------------- Scan query programs easily By Eric Nepsund, search400 member Here's a bit of code that will provide you with a command to can queries looking for a single string. Thanks to reader Eric Nepsund for sending this one in. Command "SCANQRY" provides the ability to scan all query programs in a library for a specified string. The program first creates a list of all query programs for the specified library. Then it retrieves the query source from the query definition object for each query and places it in a temporary source file member. After the source is created for all queries, the members are scanned using the native FNDSTRPDM (Find String Using PDM) command. In addition, the first 10 positions of the search string are placed in the "User Data" portion of the spooled file to better identify it. To get the code, go to http://search400.techtarget.com/tip/1,289483,sid3_gci552195,00.html ---------------------------------------------------- OTHER DEVELOPER TIPS ---------------------------------------------------- Search400 members also submitted the following developer tips recently: Use SQL to change files Submitted by Shalom Carmel http://search400.techtarget.com/tip/1,289483,sid3_gci553317,00.html Power-charged spool file utility Submitted by Sudhakar Kunji http://search400.techtarget.com/tip/1,289483,sid3_gci552235,00.html User-defined commands to the rescue Submitted by Eitan Rosenberg http://search400.techtarget.com/tip/1,289483,sid3_gci552241,00.html What do you think of these tips? Love them or not, we want to know. Click over to check them out and rate them. Or email us at mailto:[EMAIL PROTECTED] to sound off or submit a tip of your own. ------------------------------------- FEATURED BOOK ------------------------------------- Title: Desktop Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400 Authors: Ted Holt and Shannon O'Donnell Description: Now it's easier than ever to implement the best possible solutions for hundreds of tasks and challenges on the iSeries and AS/400. This highly readable, comprehensive new reference, compiled by IBM midrange authorities Ted Holt and Shannon O'Donnell, includes more than 900 entries by more than 300 experts from around the world. These entries address practically every area of your job: RPG, CL, operations, security, database, TCP/IP, and more. http://www.digitalguru.com/dgstore/product.asp?isbn=1583470263&ac_id=55 --------------------------------------------------------- If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://search400.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
