=============================================================== SEARCH400.com | Administrator Tip Dec. 24, 2002 =============================================================== Essential explanations, tools, and code for the iSeries administrator. More tips: http://search400.techtarget.com/tipsIndex/0,289482,sid3_tax2f8,00.htm l
=============================================================== In today's technical advice roundup you'll find tips, expert answers and input from your peers on the following iSeries administrator questions and concerns: Today's Featured Administrator Tip: -- Improved SQL source-level debugging in V5R2 Answers to Other Technical Questions - Debugging and testing programs - Debugging batch jobs - Debugging an RPGLE program when its source does not exist - V5R2 and you Important Announcements and Links - Tips Exchange: Win a Garmin eMap GPS - 2002 Product Guide: Gadgets, gizmos and more - NEW Book Excerpt: Exploring IBM eServer iSeries Computers - White Papers: Hundreds of free iSeries-related white papers - Monthly Newsletter: Top Expert Advice _______________________________________________________________ ****************** Previous Webcasts Archives **************** Take a look at these informative transcripts from previous webcasts: FTP Fundamental, Security, and Source Control Management tools. http://search400.techtarget.com/onlineEvents/0,289675,sid3,00.html =============================================================== Today's Featured Tip =============================================================== Improved SQL source-level debugging in V5R2 If you're an SQL programmer, you may find that on many occasions you wish to perform program source-level debugging on the SQL routines that you create. Since V4R2, you have been able to do this by using the syntax SET OPTION DBGVIEW = *STMT or *LIST with the CREATE FUNCTION, PROCEDURE, or TRIGGER syntaxes. But the source-level listing you can see in the debugger view is displayed in C-generated codes only, which tends to be quite long and thus difficult to identify the SQL entities of your interest. ISeries programmers wanting to debug these SQL objects soon found that they had to step through the C code generated by DB2 UDB, which is not a pleasant experience for an RPG or Cobol programmer. To improve the debug process in V5R2, an SQL source-level debugger has been delivered so that the programmer sees and debugs only the SQL statements he coded. Hernando Bedoya gives you the details. >> CLICK here to view the complete tip: http://www.search400.com/tip/1,289483,sid3_gci870658,00.html =============================================================== Answers to Other Administrator Questions =============================================================== Debugging and testing programs Search400.com member Dean Schweitz says when debugging and testing programs try the RGPLE compile options: OPTION(*SHOWCPY *EXPDDS) DBGVIEW(*LIST). http://search400.techtarget.com/tip/1,289483,sid3_gci800715,00.html Debugging batch jobs Using your interactive screen to debug a batch job submitted to the job queue allows you to put the batch job into debug mode and to set breakpoints without having to change the program to run interactively. http://search400.techtarget.com/tip/1,289483,sid3_gci773936,00.html Debugging an RPGLE program when its source does not exist How can you debug an RPGLE program when its source doesn't exist? Site expert John Kohan tells you. http://search400.techtarget.com/ateQuestionNResponse/0,289625,sid3_cid385496_tax285217,00.html V5R2 and you Want to know what V5R2 has that other operating systems don't? We've got all the news right here, as well as a few tech tips and expert advice to help you get the most out of it http://search400.techtarget.com/featuredTopic/0,290042,sid3_gci858475,00.html _______________________________________________________________ _______________________________________________________________ ::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- WIN A GARMIN EMAP GPS | Search400.com tips contest Is a Garmin eMap GPS on your holiday wish list? If so, you'll want to get involved in this months Search400.com tips contest. Yes, that's right, this month we're giving away a Garmin eMap GPS. And you always believed it was Rudolph that guided Santa sleigh -- the secret's out! With the eMap, no matter if you are in a sleigh or hiking at the North Pole, you're never alone. The eMap contains a differential-ready, 12-parallel channel GPS receiver that continuously tracks and uses up to 12 satellites to compute and update your position. Send in your tip -- you could be our holiday winner. >> SUBMIT a Tip: http://search400.techtarget.com/tipsPrize/0,289492,sid3_prz804422_cts866220,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 2002 PRODUCT GUIDE | Gadgets, gizmos and more IT professionals spend far too much of their time wrestling with databases that scale to mega terabytes, and keeping thousands of PCs purring. At times, they need to kick back and look at how little slices of technology can make our lives more productive -- OK, more fun. TechTarget's editors and IT staff have launched their first annual look at some of the latest gadgets and gizmos that can help an IT professional get through the day. The reviewers share their thoughts on more than 40 personal technology products that they tested, ranging from games to cameras and high-powered Web development tools. Highlights include IBM's powerful and slick T30 notebook, which won the heart of one of our project managers, Macromedia's latest release of Studio MX, and Sony's interactive U.S. Navy SEALs game. >> START your tech-toy tour by clicking here: http://searchwin2000.techtarget.com/gadgets_gizmos_and_more/0,294153,sid1,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE BOOK EXCERPT | Exploring IBM eServer iSeries and AS/400 Computers, 10th Edition Search400.com would like to offer our members the opportunity to download for free the table of contents and first chapter of Exploring IBM eServer iSeries and AS/400 Computers, 10th Edition written by Jim Hoskins and Roger Dimmick, and published by Maximum Press. This updated guide to the iServer and AS/400 world provides an overview and comprehensive reference to the latest models, options, disk storage equipment, printers, tape drives, software enhancements, Lotus Domino, displays, network stations and more. It addresses such business issues as lease vs. purchase, maintenance strategies, cost justification and office ergonomics. It also includes hypothetical case studies of small, medium and large businesses to illustrate how real business problems can be solved with iSeries and AS/400 systems. Non-technical readers will appreciate its straightforward style. >> DOWNLOAD the chapter: http://search400.techtarget.com/whitepaperPage/0,293857,sid3_gci866745,00.html >> BUY the book: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&category_name=&product_id=1885068433&partner_id=55 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HUNDREDS OF FREE WHITE PAPERS | Search400.com research Visit our new 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MONTHLY NEWSLETTER | Top Expert Advice newsletter The Top Expert Advice newsletter was designed to help iSeries professionals manage tasks they deal with regularly. Each month we will give you expert advice on such topics as security, backup and recovery, Web development and application development. To receive this newsletter, simply edit your member profile at http://search400.techtarget.com/editSummary/1,291026,sid3,00.html and check Top Expert Advice newsletter under the Tips section. ________________________________________________________________ :::::::::::::::::::::: 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. All Rights Reserved. Unsubscribe from 'Administrator 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."
