==================================================================== SEARCH400.COM | Programmer Tip Oct. 9, 2002 ==================================================================== FROM OUR SPONSORS: iStudio400.com -- iSeries experts at your service http://istudio400.com
==================================================================== Essential explanations, tools and code for the iSeries programmer. More tips: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f9,00.html ==================================================================== In today's technical advice roundup you'll find tips, expert answers and input from your peers to the following iSeries programmer questions and concerns: Today's Featured Programmer Tip: -- Beyond DSPPGMREF: Scan all libraries before changing a database file 1. Answers to Other Technical Questions: 1. A use of DSPPGMREF ... 2. Determine the external call to programs 3. Stay current with PTFs to prevent problems 4. Create a cross-reference file 2. Important Announcements and Links - Search400 IT Excellence Awards: Accepting nominations now - Tips Contest: September winners announced - White Papers: Hundreds of iSeries-related white papers - Advice: Programmer Discussion Forum - Featured Book: Java for S/390 and AS/400 COBOL Programmers ____________________________________________________________________ *********************SPONSORED BY iStudio400.com ****************** In today's business environment, a company's ability to quickly and successfully respond to change means success. The experts at iStudio400.com can help cut through the oppressive IT environment to quickly implement solutions in hardware, software, networking, systems management, security and privacy, and business recovery. No bull, just bucks. Visit us at iStudio400.com to get your expert advice today. http://istudio400.com ==================================================================== Today's Featured Tip ==================================================================== Beyond DSPPGMREF: Scan all libraries before changing a database file No matter how much planning you do when you design a database file, it will eventually need to be changed. A seemingly small change, such as adding a new field or changing an existing field, may actually become a very involved job, depending on the usage of the file in question. You must find all program references to that file and its associated logical files so you can begin checking each program for necessary changes and recompiling. This search, unfortunately, is not limited solely to a single library. It must encompass your whole system to avoid an unexpected level-check error in the future. You don't know how big a job you're facing until you find all references to the physical file (and attached logical files) being changed. Your first step is to scan your HLL source code (one library at a time) for references to the physical file and its associated logical files plus any references in CL. The software in this article eliminates the hassle of checking libraries on your iSeries one by one and gives you a systemwide scan of all of them. >> CLICK here for the full tip: http://www.search400.com/tip/1,289483,sid3_gci855513,00.html ==================================================================== Answers to Other Programmer Questions ==================================================================== 1. A use of DSPPGMREF ... Member Luc Herpelinck shows you how to use the DSPPGMREF command to output program references to a file. http://search400.techtarget.com/tip/1,289483,sid3_gci518058,00.html 2. Determine the external call to programs If you want to find out the external call to programs and all files used in your RPG program or module, you can use DSPPGMREF. http://search400.techtarget.com/tip/1,289483,sid3_gci758145,00.html 3. Stay current with PTFs to prevent problems Installing new software and upgrades doesn't have to be a nightmare. Follow site expert Pascal Jacquemain's steps using the DSPFD and DSPPGMREF commands to ensure compatibility between files and programs. http://search400.techtarget.com/tip/1,289483,sid3_gci331525,00.html 4. Create a cross-reference file Using the DSPPGMREF command, site expert Tim Granatir tells you how to create a file that cross references all programs to each other. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid475760_tax285217,00.html ____________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ACCEPTING NOMINATIONS NOW | Search400 IT Excellence Awards We're on the lookout for medium- and large-scale companies that are blazing new trails in iSeries 400 computing. Are you pushing the limits of the iSeries server capacity or taking Web development for the iSeries to the next level? If so, then submit your nomination for Search400's IT Excellence Awards. This awards program recognizes the IT achievers at end-user companies who design, build and manage these complex technologies (no vendors, please). The deadline for submissions is Friday, Oct. 25, 2002. >> NOMINATE a company today: http://search400.techtarget.com/awards =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEPTEMBER WINNERS ANNOUNCED | Search400.com tips contest You've been patient all month, and the results are finally in... The top winner for Search400's Tips Contest for September is Manolis Mariakakis. Manolis won a Futuristic Mega stereo and was added to our Hall of Fame for his tip: "Convert spooled files to PDF using Java," http://www.search400.com/tip/1,289483,sid3_gci847978,00.html Congratulations also to our runner-up winners: Nico Beekhuijs and Jeff Worthington. View all winning tips in Search400's Hall of Fame: http://search400.techtarget.com/tipsHallOfFame/0,289489,sid3_prz826588_cts826578,00.html NEW CONTEST FOR OCTOBER: This month we're giving away a $50 Amazon.com gift certificate. Buy yourself something that you really want, rather than settling for something less. You can choose from several categories of items such as books, music, videos, electronics, gardening, toys, housewares and more. Submit a winning tip and treat yourself to something you really want at Amazon.com! Send in your tip -- you could be our next winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsSubmit/0,289485,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HUNDREDS OF FREE WHITE PAPERS | Search400.com research Visit our white papers section and start boning up before your next purchase decision. You can browse by topic, author, or even search with your own keywords. If you know of other white papers that should be included, e-mail us or use our simple submission form. Check back often as we're adding more white papers every day. >> CLICK for iSeries-related white papers: http://search400.techtarget.com/whitepapers/0,293835,sid3,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DISCUSSION FORUM | Interact with other programmers Are you an iSeries programmer with questions? Join your peers in Our Programmer Forum to ask and answer questions about XML, COBOL, CL, ILE, Web development, Java and much more. >> RECENT Discussion threads you may find of interest: * Working with JavaScript and Java http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/2706 * Program to print work with TCP/IP connection status http://search400.discussions.techtarget.com/WebX?[EMAIL PROTECTED]@.ee84636/2671 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- THIS WEEK'S FEATURED BOOK | Search400's Bookstore Title: Java for S/390 and AS/400 COBOL Programmers Author: Phil Coulthard and George Farr This book is designed to help COBOL programmers make the jump to Java. It teaches COBOL programmers how to read and write Java programs and helps them understand the concepts necessary to continue to improve their Java skills. http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=1583470115&partner_id=55 ____________________________________________________________________ :::::::::::::::::::::: SEARCH400.COM CONTACTS :::::::::::::::::::::: TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. ____________________________________________________________________ MICHELLE DAVIDSON, site editor (mailto:[EMAIL PROTECTED]) >> Send us your story ideas and best practices. ____________________________________________________________________ DEBRA TART, assistant editor (mailto:[EMAIL PROTECTED]) >> Send us your tips and Best Web Links. ____________________________________________________________________ DAVID GABEL, executive tech editor (mailto:[EMAIL PROTECTED]) >> Send me your technical tips and tip ideas. ____________________________________________________________________ GABRIELLE DERUSSY (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ____________________________________________________________________ ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002 TechTarget. All rights reserved. Unsubscribe from 'Programmer Tips' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search400.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
