<br />
THE ULTIMATE RESOURCE FOR SYST<br />
' <;l??v<br />
L:'\fu|3Lli,<ii; ix cuTv<br />
SystemiNEWS<br />
^Jk Penton Publication DECEMBER 2008<br />
IzLllbaLl'aSSLLlg CeLllL2LLteL' SLlafiiS<br />
Bypass This Batch of Blunders<br />
PLUS!<br />
Why Don't We Have a Native Web Ul?<br />
Opinion: Happy Birthday to the i ??? The Art of No<br />
Hot or Not? Consumerization of I<br />
jstry<br />
liable<br />
Industry Report: The i Doesn't Get More<br />
Available than This<br />
Computer SligIus<br />
Get a Chuckle from These Snafus<br />
Avoid RCLSTG & SQL Mistakes<br />
rli<br />
EDITION<br />
meters for RPG<br />
rface Basics<br />
ts6.<br />
_ Optimization<br />
iority<br />
<br />
6 business-critical applications<br />
1,500 legacy programs<br />
4,200 screens<br />
ALL MODERNIZED IN A MATTER OF WEEKS<br />
NOW THAT’S PROFOUND!<br />
INGENUITY AT YOUR FINGERTIPS WITH GENIE<br /<a title="December 2008 page 1" href="https://secure.viewer.zmags.com/publication/701b20a3?page=1"> THE ULTIMATE RESOURCE FOR SYST ' <;l??v L:'\fu|3L</a>
<a title="December 2008 page 2" href="https://secure.viewer.zmags.com/publication/701b20a3?page=2"> 6 business-critical applications 1,500 legacy p</a>
<a title="December 2008 page 3" href="https://secure.viewer.zmags.com/publication/701b20a3?page=3"> they are still monitoring </a>
<a title="December 2008 page 4" href="https://secure.viewer.zmags.com/publication/701b20a3?page=4"> m Valence: Web 2.0 to System i Valence The Valenc</a>
<a title="December 2008 page 5" href="https://secure.viewer.zmags.com/publication/701b20a3?page=5"> DECEMBER 2008 VIEWPOINT 7 | GuestViewpoin</a>
<a title="December 2008 page 6" href="https://secure.viewer.zmags.com/publication/701b20a3?page=6"> Control multiple iSeries and LPAR System Consoles</a>
<a title="December 2008 page 7" href="https://secure.viewer.zmags.com/publication/701b20a3?page=7"> Kim Paulsen, Senior Vice President, Penton New Me</a>
<a title="December 2008 page 8" href="https://secure.viewer.zmags.com/publication/701b20a3?page=8"> Call Now for a FREE 30-day demo! Connecting dat</a>
<a title="December 2008 page 9" href="https://secure.viewer.zmags.com/publication/701b20a3?page=9"> GUEST VIEWPOINT They Say It’sYour Birthday b</a>
<a title="December 2008 page 10" href="https://secure.viewer.zmags.com/publication/701b20a3?page=10"> GUEST VIEWPOINT ing, at least) “IBM i on Power </a>
<a title="December 2008 page 11" href="https://secure.viewer.zmags.com/publication/701b20a3?page=11"> Caught in the pinch of downsizing? Build a bette</a>
<a title="December 2008 page 12" href="https://secure.viewer.zmags.com/publication/701b20a3?page=12"> Take The Paper Out Of Your Paperwork! PROBLEM </a>
<a title="December 2008 page 13" href="https://secure.viewer.zmags.com/publication/701b20a3?page=13"> FROM THE TRENCHES The Art of No by Jef Su</a>
<a title="December 2008 page 14" href="https://secure.viewer.zmags.com/publication/701b20a3?page=14"> INDUSTRY OBSERVER by Sharon L. Hoffman ➲ Live L</a>
<a title="December 2008 page 15" href="https://secure.viewer.zmags.com/publication/701b20a3?page=15"> ?? \ A New Era for Data Replication Databases </a>
<a title="December 2008 page 16" href="https://secure.viewer.zmags.com/publication/701b20a3?page=16"> f.y.iSYSTEM IBM Intros 560 Express Power Syste</a>
<a title="December 2008 page 17" href="https://secure.viewer.zmags.com/publication/701b20a3?page=17"> YiPs Plan Open-Source Development for i on Websit</a>
<a title="December 2008 page 18" href="https://secure.viewer.zmags.com/publication/701b20a3?page=18"> Audax Buys Up i Companies ThHelpr/iSvyasttemeqsu</a>
<a title="December 2008 page 19" href="https://secure.viewer.zmags.com/publication/701b20a3?page=19"> THE ESSENTIAL GUIDE TO NINE IT SECURITY</a>
<a title="December 2008 page 20" href="https://secure.viewer.zmags.com/publication/701b20a3?page=20"> (( ( ( ( </a>
<a title="December 2008 page 21" href="https://secure.viewer.zmags.com/publication/701b20a3?page=21"> THE ESSENTIAL listed here because it’s one you </a>
<a title="December 2008 page 22" href="https://secure.viewer.zmags.com/publication/701b20a3?page=22"> GUIDE TO however, much of the IDS/IDP job is au</a>
<a title="December 2008 page 23" href="https://secure.viewer.zmags.com/publication/701b20a3?page=23"> SECURITY passwords hard to type and too short-li</a>
<a title="December 2008 page 24" href="https://secure.viewer.zmags.com/publication/701b20a3?page=24"> Trojan </a>
<a title="December 2008 page 25" href="https://secure.viewer.zmags.com/publication/701b20a3?page=25"> IBM ANNOUNCEMENTS IBM Launches Power 560 Expre</a>
<a title="December 2008 page 26" href="https://secure.viewer.zmags.com/publication/701b20a3?page=26"> Do You Have What It Takes To Become The </a>
<a title="December 2008 page 27" href="https://secure.viewer.zmags.com/publication/701b20a3?page=27"> INDUSTRY REPORT The i Doesn’t Get More Availab</a>
<a title="December 2008 page 28" href="https://secure.viewer.zmags.com/publication/701b20a3?page=28"> INDUSTRY REPORT “One of the reasons it’s im</a>
<a title="December 2008 page 29" href="https://secure.viewer.zmags.com/publication/701b20a3?page=29"> same market-broadening activity. “There’s a g</a>
<a title="December 2008 page 30" href="https://secure.viewer.zmags.com/publication/701b20a3?page=30"> EfystemiNetwor ><>???< Special Offers Computer-Ba</a>
<a title="December 2008 page 31" href="https://secure.viewer.zmags.com/publication/701b20a3?page=31"> Special Off Books | Computer-Based Leamin E-Lea</a>
<a title="December 2008 page 32" href="https://secure.viewer.zmags.com/publication/701b20a3?page=32"> SystemlNetwor pecial Offers c 0 43 (0 [ JU 0 m</a>
<a title="December 2008 page 33" href="https://secure.viewer.zmags.com/publication/701b20a3?page=33"> Computer-Based Leamin E-Leaminq ????????? Master </a>
<a title="December 2008 page 34" href="https://secure.viewer.zmags.com/publication/701b20a3?page=34"> LEGACY MODERNIZATION FROM THIS... TO THIS.</a>
<a title="December 2008 page 35" href="https://secure.viewer.zmags.com/publication/701b20a3?page=35"> A FRESH i David Phillips by Rita-Lyn Sanders </a>
<a title="December 2008 page 36" href="https://secure.viewer.zmags.com/publication/701b20a3?page=36"> o ?? COMPLIANCE ??, WITH LESS COFFEE Visit us a</a>
<a title="December 2008 page 37" href="https://secure.viewer.zmags.com/publication/701b20a3?page=37"> HOT NEW PRODUCTS Security </a>
<a title="December 2008 page 38" href="https://secure.viewer.zmags.com/publication/701b20a3?page=38"> HOT NEW PRODUCTS Backup and Recovery SafeData I</a>
<a title="December 2008 page 39" href="https://secure.viewer.zmags.com/publication/701b20a3?page=39"> Business Intelligence NGS Introduces Financial Pe</a>
<a title="December 2008 page 40" href="https://secure.viewer.zmags.com/publication/701b20a3?page=40"> Automatically Encrypt: • Database Fields • Backup</a>
<a title="December 2008 page 41" href="https://secure.viewer.zmags.com/publication/701b20a3?page=41"> A System iNEWS Special Report Browser User In</a>
<a title="December 2008 page 42" href="https://secure.viewer.zmags.com/publication/701b20a3?page=42"> mashups—web applications that use other web appli</a>
<a title="December 2008 page 43" href="https://secure.viewer.zmags.com/publication/701b20a3?page=43"> FIGURE 4 acmeords.css #content { width: 80</a>
<a title="December 2008 page 44" href="https://secure.viewer.zmags.com/publication/701b20a3?page=44"> hearing impairment or be unable to use a keyboard</a>
<a title="December 2008 page 45" href="https://secure.viewer.zmags.com/publication/701b20a3?page=45"> FIGURE 7 Viewing the document typed in Firefox in</a>
<a title="December 2008 page 46" href="https://secure.viewer.zmags.com/publication/701b20a3?page=46"> the HTTP methods to perform on a resource. The st</a>
<a title="December 2008 page 47" href="https://secure.viewer.zmags.com/publication/701b20a3?page=47"> Considering Browser User Interfaces? Hemroedaerr</a>
<a title="December 2008 page 48" href="https://secure.viewer.zmags.com/publication/701b20a3?page=48"> Modernize Your Legacy Systems with Seagull Softwa</a>
<a title="December 2008 page 49" href="https://secure.viewer.zmags.com/publication/701b20a3?page=49"> DECEMBER 2008 IN-DEPTH: COMPUTER SNAFUS Nohuma</a>
<a title="December 2008 page 50" href="https://secure.viewer.zmags.com/publication/701b20a3?page=50"> ARCAD's AIM framework manages all software change</a>
<a title="December 2008 page 51" href="https://secure.viewer.zmags.com/publication/701b20a3?page=51"> Computer Snafus Unplugged: Not Ready for PrimeTim</a>
<a title="December 2008 page 52" href="https://secure.viewer.zmags.com/publication/701b20a3?page=52"> ■ UNPLUGGED off our machines. When I left the</a>
<a title="December 2008 page 53" href="https://secure.viewer.zmags.com/publication/701b20a3?page=53"> I referred the matter to someone in the networ</a>
<a title="December 2008 page 54" href="https://secure.viewer.zmags.com/publication/701b20a3?page=54"> ■ UNPLUGGED annoying beep to announce that you h</a>
<a title="December 2008 page 55" href="https://secure.viewer.zmags.com/publication/701b20a3?page=55"> EGL Puts the i in iPhone An Enterprise Generati</a>
<a title="December 2008 page 56" href="https://secure.viewer.zmags.com/publication/701b20a3?page=56"> ■ EGL PUTS THE i IN iPHONE Technology Reports v</a>
<a title="December 2008 page 57" href="https://secure.viewer.zmags.com/publication/701b20a3?page=57"> FIGURE 3 Sample schedule plan Browser </a>
<a title="December 2008 page 58" href="https://secure.viewer.zmags.com/publication/701b20a3?page=58"> ■ EGL PUTS THE i IN iPHONE Technology Reports r</a>
<a title="December 2008 page 59" href="https://secure.viewer.zmags.com/publication/701b20a3?page=59"> FIGURE 8 The web service function loginUser(u</a>
<a title="December 2008 page 60" href="https://secure.viewer.zmags.com/publication/701b20a3?page=60"> RFID "Smart Labels" tnJLs&jwf1^ Barcode pffl Labe</a>
<a title="December 2008 page 61" href="https://secure.viewer.zmags.com/publication/701b20a3?page=61"> Solve Programming Snafus by Mastering RCLSTG and </a>
<a title="December 2008 page 62" href="https://secure.viewer.zmags.com/publication/701b20a3?page=62"> ■ MASTER RCLSTG AND SQL command to assess the st</a>
<a title="December 2008 page 63" href="https://secure.viewer.zmags.com/publication/701b20a3?page=63"> FIGURE 3 Multiple SQL statements for extract and </a>
<a title="December 2008 page 64" href="https://secure.viewer.zmags.com/publication/701b20a3?page=64"> File Parameters for RPG Learn how to properly p</a>
<a title="December 2008 page 65" href="https://secure.viewer.zmags.com/publication/701b20a3?page=65"> FIGURE 3 Program using the /COPY file /define</a>
<a title="December 2008 page 66" href="https://secure.viewer.zmags.com/publication/701b20a3?page=66"> FIGURE 7 A file with associated variables Fcus</a>
<a title="December 2008 page 67" href="https://secure.viewer.zmags.com/publication/701b20a3?page=67"> Creating andTesting an RPG Web Service from </a>
<a title="December 2008 page 68" href="https://secure.viewer.zmags.com/publication/701b20a3?page=68"> ■ RPG WEB SERVICE FROM WDSC two-character custom</a>
<a title="December 2008 page 69" href="https://secure.viewer.zmags.com/publication/701b20a3?page=69"> FIGURE 6 F Using the ReturnState method U </a>
<a title="December 2008 page 70" href="https://secure.viewer.zmags.com/publication/701b20a3?page=70"> ■ RPG WEB SERVICE FROM WDSC Explorer view for the</a>
<a title="December 2008 page 71" href="https://secure.viewer.zmags.com/publication/701b20a3?page=71"> MI for the CL Programmer Machine Interface Basic</a>
<a title="December 2008 page 72" href="https://secure.viewer.zmags.com/publication/701b20a3?page=72"> ■ MACHINE INTERFACE BASICS need for ADDN—you si</a>
<a title="December 2008 page 73" href="https://secure.viewer.zmags.com/publication/701b20a3?page=73"> FIGURE 3 Prototype for MATMATR Bound program </a>
<a title="December 2008 page 74" href="https://secure.viewer.zmags.com/publication/701b20a3?page=74"> ■ MACHINE INTERFACE BASICS Programming & Develop</a>
<a title="December 2008 page 75" href="https://secure.viewer.zmags.com/publication/701b20a3?page=75"> FIGURE 6 Prototype for TSTBTS Bound program </a>
<a title="December 2008 page 76" href="https://secure.viewer.zmags.com/publication/701b20a3?page=76"> Optimize Your System i. Maximize Your ROI. “With</a>
<a title="December 2008 page 77" href="https://secure.viewer.zmags.com/publication/701b20a3?page=77"> Do More with Run SQL Scripts in 6.1 New feature</a>
<a title="December 2008 page 78" href="https://secure.viewer.zmags.com/publication/701b20a3?page=78"> ■ RUN SQL SCRIPTS 6.1 Networking & Systems Manag</a>
<a title="December 2008 page 79" href="https://secure.viewer.zmags.com/publication/701b20a3?page=79"> FIGURE 4 Show JDBC Properties dialog box FIGURE </a>
<a title="December 2008 page 80" href="https://secure.viewer.zmags.com/publication/701b20a3?page=80"> More Performance-Analysis Capabilities Run SQL Sc</a>
<a title="December 2008 page 81" href="https://secure.viewer.zmags.com/publication/701b20a3?page=81"> FIGURE 8 Example of running a non-standard SQL st</a>
<a title="December 2008 page 82" href="https://secure.viewer.zmags.com/publication/701b20a3?page=82"> Out of the BoxTuning Work Management Configurati</a>
<a title="December 2008 page 83" href="https://secure.viewer.zmags.com/publication/701b20a3?page=83"> FIGURE 1 Workloads for Scenario 1 Shared pool </a>
<a title="December 2008 page 84" href="https://secure.viewer.zmags.com/publication/701b20a3?page=84"> ■ WORK MANAGEMENT CONFIGURATIONS paging option p</a>
<a title="December 2008 page 85" href="https://secure.viewer.zmags.com/publication/701b20a3?page=85"> Transaction ResponseTime Variation and D</a>
<a title="December 2008 page 86" href="https://secure.viewer.zmags.com/publication/701b20a3?page=86"> The overall system setup of the example scenar</a>
<a title="December 2008 page 87" href="https://secure.viewer.zmags.com/publication/701b20a3?page=87"> FIGURE 4 CPU by Job Priority zero through 23 </a>
<a title="December 2008 page 88" href="https://secure.viewer.zmags.com/publication/701b20a3?page=88"> ■ TRANSACTION RESPONSE TIME System i SQL compatib</a>
<a title="December 2008 page 89" href="https://secure.viewer.zmags.com/publication/701b20a3?page=89"> FIGURE 7 Finding and summarizing the adjusted job</a>
<a title="December 2008 page 90" href="https://secure.viewer.zmags.com/publication/701b20a3?page=90"> They won't believe these are your System i Applic</a>
<a title="December 2008 page 91" href="https://secure.viewer.zmags.com/publication/701b20a3?page=91"> Killer Club Tech Access MS SQL Server Database </a>
<a title="December 2008 page 92" href="https://secure.viewer.zmags.com/publication/701b20a3?page=92"> ■ KILLER CLUB TECH These comments also describe </a>
<a title="December 2008 page 93" href="https://secure.viewer.zmags.com/publication/701b20a3?page=93"> FIGURE 4 Code to call JDBC_PrepStmt procedure </a>
<a title="December 2008 page 94" href="https://secure.viewer.zmags.com/publication/701b20a3?page=94"> by Mel Beckman ■ Dear Doctor, I’ve set up </a>
<a title="December 2008 page 95" href="https://secure.viewer.zmags.com/publication/701b20a3?page=95"> FREE! NEWS Daily Not just any news — ChrisMaxcer</a>
<a title="December 2008 page 96" href="https://secure.viewer.zmags.com/publication/701b20a3?page=96"> ADVERTISEMENT CASE STUDY </a>
<a title="December 2008 page 97" href="https://secure.viewer.zmags.com/publication/701b20a3?page=97"> Youdunit: Embarrassing Computer Snafus Learn fro</a>
<a title="December 2008 page 98" href="https://secure.viewer.zmags.com/publication/701b20a3?page=98"> YOUDUNIT staff members, contractors, and manage</a>
<a title="December 2008 page 99" href="https://secure.viewer.zmags.com/publication/701b20a3?page=99"> whole application. We finally developed the S</a>
<a title="December 2008 page 100" href="https://secure.viewer.zmags.com/publication/701b20a3?page=100"> YOUDUNIT </a>
<a title="December 2008 page 101" href="https://secure.viewer.zmags.com/publication/701b20a3?page=101"> WE’VE GOT YOUR BACK Your expertise </a>
<a title="December 2008 page 102" href="https://secure.viewer.zmags.com/publication/701b20a3?page=102"> Query All Your Databases Directly From the IBM i </a>
<a title="December 2008 page 103" href="https://secure.viewer.zmags.com/publication/701b20a3?page=103"> Hey, IBM! We Need a NativeWeb UI Big Blue can pr</a>
<a title="December 2008 page 104" href="https://secure.viewer.zmags.com/publication/701b20a3?page=104"> HEY, IBM! ILoveIBMForever.org blog site. So why</a>
<a title="December 2008 page 105" href="https://secure.viewer.zmags.com/publication/701b20a3?page=105"> Business PartnerI Simple & Efficient! \ What's be</a>
<a title="December 2008 page 106" href="https://secure.viewer.zmags.com/publication/701b20a3?page=106"> Change management enhances security and high avai</a>
<a title="December 2008 page 107" href="https://secure.viewer.zmags.com/publication/701b20a3?page=107"> SOLUTION SPOTLIGHT Raz-Lee Offers (H)iSecuri</a>
<a title="December 2008 page 108" href="https://secure.viewer.zmags.com/publication/701b20a3?page=108"> SOLUTION SPOTLIGHT System i provides built-in e</a>
<a title="December 2008 page 109" href="https://secure.viewer.zmags.com/publication/701b20a3?page=109"> Use this index as a one-stop source of leading </a>
<a title="December 2008 page 110" href="https://secure.viewer.zmags.com/publication/701b20a3?page=110"> 46 November 2006 December 2008 Marketplace </a>
<a title="December 2008 page 111" href="https://secure.viewer.zmags.com/publication/701b20a3?page=111"> December 2008 </a>
<a title="December 2008 page 112" href="https://secure.viewer.zmags.com/publication/701b20a3?page=112"> HOT OR NOT? Consumer Confidence? by Sean Cha</a>
<a title="December 2008 page 113" href="https://secure.viewer.zmags.com/publication/701b20a3?page=113"> NEW! Robot/CONSOLE 5.0 CutsYour Checklist Down to</a>
<a title="December 2008 page 114" href="https://secure.viewer.zmags.com/publication/701b20a3?page=114"> RFID "Smart Labels" tnJLs&jwf1^ Barcode pffl Labe</a>
<a title="December 2008 page 115" href="https://secure.viewer.zmags.com/publication/701b20a3?page=115"> TO ORDER, CALL 800-40-MANTA Library Descr</a>
<a title="December 2008 page 116" href="https://secure.viewer.zmags.com/publication/701b20a3?page=116"> THE SYSTEM i TRAINING LIBRARY Keeping </a>
<a title="December 2008 page 117" href="https://secure.viewer.zmags.com/publication/701b20a3?page=117"> TO ORDER, CALL 800-40-MANTA Delivery Options</a>
<a title="December 2008 page 118" href="https://secure.viewer.zmags.com/publication/701b20a3?page=118"> OPTIONAL PRODUCTS Student Reference Guides 4EXT B</a>
<a title="December 2008 page 119" href="https://secure.viewer.zmags.com/publication/701b20a3?page=119"> MANTA VERSUS LOCAL DELIVERY MantaNow! (Internet</a>
<a title="December 2008 page 120" href="https://secure.viewer.zmags.com/publication/701b20a3?page=120"> SYSTEM USE & OPERATIONS Introduction to the Sys</a>
<a title="December 2008 page 121" href="https://secure.viewer.zmags.com/publication/701b20a3?page=121"> TO ORDER, CALL 800-40-MANTA Operations Combi</a>
<a title="December 2008 page 122" href="https://secure.viewer.zmags.com/publication/701b20a3?page=122"> T H E MANTA ONL I NE SEM I NAR SER I ES Bringing</a>
<a title="December 2008 page 123" href="https://secure.viewer.zmags.com/publication/701b20a3?page=123"> Available Seminars Joe Pluta Pluta Brothers Desi</a>
<a title="December 2008 page 124" href="https://secure.viewer.zmags.com/publication/701b20a3?page=124"> SYSTEM ADMINISTRATION Work Management </a>
<a title="December 2008 page 125" href="https://secure.viewer.zmags.com/publication/701b20a3?page=125"> TO ORDER, CALL 800-40-MANTA The Integrated F</a>
<a title="December 2008 page 126" href="https://secure.viewer.zmags.com/publication/701b20a3?page=126"> PROGRAMMING RPG Programming Series order number:</a>
<a title="December 2008 page 127" href="https://secure.viewer.zmags.com/publication/701b20a3?page=127"> TO ORDER, CALL 800-40-MANTA Introduction to </a>
<a title="December 2008 page 128" href="https://secure.viewer.zmags.com/publication/701b20a3?page=128"> eBUSINESS eBusiness for System i Programmers Ser</a>
<a title="December 2008 page 129" href="https://secure.viewer.zmags.com/publication/701b20a3?page=129"> ORDER FORM $ESCRIPTION 3YSTEMI4RAINING,IBRARY </a>
<a title="December 2008 page 130" href="https://secure.viewer.zmags.com/publication/701b20a3?page=130"> ORDER INFORMATION Ordering Courses 9OUCANPLACEOR</a>