If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> l:\l! \!JH$<br /> \/A \/A V^<br /> STEM i PROS<br /> SystemiNETO<br /> ./A Pen.on Publication MARCH 200S<br /> PLUS!<br /> Application Appliances Go Virtual<br /> Behind IBM's Reorganizations<br /> Opinion:CUL8RSEU! ???Oracle's<br /> Cunning Strategies<br /> Products: Profound Logic's RPGsp<br /> ??? Roundup of Accounting Apps<br /> And More!<br /> Extend Your<br /> SQL Skills<br /> Leap Ahead with DB2 for V6R1<br /> Work with Multiple Tables<br /> Deliver Results for<br /> Multidimensional Requests<br /> Explore Common Table<br /> Expressions<br /> EXPANDED EDITION<br /> etReady for V6R1<br /> Access Data with .NET Datasets & Table Adapters<br /> Test Out Your Index Advisor Theories<br /> Understand Disk Performance Metrics<br /> And More!<br /> <br /> Get Blown Away By How Fast and Easy Modernization Can Be<br /> in 11<br /> oaic Software<br /> RPGsp (RPG Sm<a title="March 2008 page 1" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=1"> l:\l! \!JH$ \/A \/A V^ STEM i PROS SystemiN</a> <a title="March 2008 page 2" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=2"> Get Blown Away By How Fast and Easy Modernizatio</a> <a title="March 2008 page 3" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=3"> The Time for High Availability Is Now! Only a </a> <a title="March 2008 page 4" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=4"> mj i******' When you're ready for RFID... Barcode</a> <a title="March 2008 page 5" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=5"> MARCH 2008 33 | Brighten Your IT Career Prospect</a> <a title="March 2008 page 6" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=6"> Multiple Project and Portfolio Management from an</a> <a title="March 2008 page 7" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=7"> On the Web at SystemiNetwork.com Network Poll: W</a> <a title="March 2008 page 8" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=8"> ?? I Don't burn up your money on return mail, ex</a> <a title="March 2008 page 9" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=9"> GUEST VIEWPOINT CU L8R SEU! by Bryan Meye</a> <a title="March 2008 page 10" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=10"> GUEST VIEWPOINT Another feature is the LPEX</a> <a title="March 2008 page 11" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=11"> Z'Z m%& A New Era for Data Replication Databases</a> <a title="March 2008 page 12" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=12"> Harne \ m ??? Organize and automate multiplatform</a> <a title="March 2008 page 13" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=13"> GUEST VIEWPOINT Foxy Larry by Sean Chandler</a> <a title="March 2008 page 14" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=14"> GUEST VIEWPOINT Foxes in History Don’t get me wr</a> <a title="March 2008 page 15" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=15"> Security Check-up for i5/OS and OS/400 -A Managed</a> <a title="March 2008 page 16" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=16"> To know where you are going, you must know where </a> <a title="March 2008 page 17" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=17"> INDUSTRY OBSERVER by Sharon L. Hoffman ➲ Live L</a> <a title="March 2008 page 18" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=18"> Considering the LT04 for Encryption? Data protect</a> <a title="March 2008 page 19" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=19"> </a> <a title="March 2008 page 20" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=20"> # $$ "" % ! ! " ( %) ' % &# & $ </a> <a title="March 2008 page 21" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=21"> '$$ $!% !"( '$$ ! </a> <a title="March 2008 page 22" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=22"> >D85!5I5>DBIDI@59>3 1 JG89389CD85122B5F91D9?</a> <a title="March 2008 page 23" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=23"> </a> <a title="March 2008 page 24" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=24"> </a> <a title="March 2008 page 25" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=25"> f.y.iSYSTEM V6R1 a Sweet Treat for System i User</a> <a title="March 2008 page 26" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=26"> f.y.iSYSTEM continued from page 17 ment of </a> <a title="March 2008 page 27" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=27"> IBM Reorg Turns into Major Overhaul WhSeynsteImB</a> <a title="March 2008 page 28" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=28"> IBM ANNOUNCEMENTS WebSphere Portal Express In</a> <a title="March 2008 page 29" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=29"> ^evdutfo*^' I Turn your standard printer files. I</a> <a title="March 2008 page 30" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=30"> SYSTEM i NETWORK PRESENTS July 20-23 • </a> <a title="March 2008 page 31" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=31"> Top 4 reasons to attend: • Evaluate & C</a> <a title="March 2008 page 32" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=32"> LEGACY MODERNIZATION FROM THIS... TO THIS.</a> <a title="March 2008 page 33" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=33"> INDUSTRY REPORT IBM’sNewSMBMonsterGarage by </a> <a title="March 2008 page 34" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=34"> INDUSTRY REPORT zation, this time even bigger t</a> <a title="March 2008 page 35" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=35"> These seem like solid business plans, until y</a> <a title="March 2008 page 36" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=36"> ROD UCT GUY P Evidence GrowsThat App Moderniza</a> <a title="March 2008 page 37" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=37"> HOT NEW PRODUCTS Data</a> <a title="March 2008 page 38" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=38"> HOT NEW PRODUCTS </a> <a title="March 2008 page 39" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=39"> Database Tools </a> <a title="March 2008 page 40" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=40"> Enjoy the View with the New SEQUEL Web Interface </a> <a title="March 2008 page 41" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=41"> TECHNOLOGY REPORTS ProVIP 3 | Leap Ahead with </a> <a title="March 2008 page 42" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=42"> Harness Software Complexity How ARCAD-Observer Sh</a> <a title="March 2008 page 43" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=43"> Leap Ahead with DB2 for V6R1 DB2 V6R1 </a> <a title="March 2008 page 44" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=44"> ■ DB2 FOR V6R1 to perform multiple database oper</a> <a title="March 2008 page 45" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=45"> FIGURE 2 Extended indicator EXEC SQL DECLARE</a> <a title="March 2008 page 46" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=46"> ■ DB2 FOR V6R1 either fail with an error flaggin</a> <a title="March 2008 page 47" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=47"> FIGURE 5 Ignoring unsupported syntax CREATE T</a> <a title="March 2008 page 48" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=48"> ■ DB2 FOR V6R1 I/O characteristics (as well as r</a> <a title="March 2008 page 49" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=49"> FIGURE 6 SQL derived index FIGURE 7</a> <a title="March 2008 page 50" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=50"> ■ DB2 FOR V6R1 Technology Reports Advisor in V5</a> <a title="March 2008 page 51" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=51"> Working with MultipleTables in SQL Joi</a> <a title="March 2008 page 52" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=52"> ■ WORKING WITH MULTIPLE TABLES IN SQL on the lef</a> <a title="March 2008 page 53" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=53"> A FIGURE 3 Left outer join example SELECT EM.</a> <a title="March 2008 page 54" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=54"> ■ WORKING WITH MULTIPLE TABLES IN SQL RUNSQ</a> <a title="March 2008 page 55" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=55"> FIGURE 8 Using a cross join to show all products,</a> <a title="March 2008 page 56" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=56"> ■ WORKING WITH MULTIPLE TABLES IN SQL and Instea</a> <a title="March 2008 page 57" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=57"> FIGURE 11 continued LEFT OUTER JOIN VERTICA</a> <a title="March 2008 page 58" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=58"> Get Ready for V6R1 Follow these 7 steps to con</a> <a title="March 2008 page 59" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=59"> Programs with Creation Data, on Pr</a> <a title="March 2008 page 60" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=60"> ■ GET READY FOR V6R1 • *OBJDTL: A detailed repor</a> <a title="March 2008 page 61" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=61"> the ANZOBJCVN command on V5R3 or V5R4. Als</a> <a title="March 2008 page 62" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=62"> Design & Print Labels i C?T 111 Harbor BM \V Gt</a> <a title="March 2008 page 63" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=63"> CommonTable Expressions Explore the flexibility</a> <a title="March 2008 page 64" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=64"> ■ COMMON TABLE EXPRESSIONS Union All Select </a> <a title="March 2008 page 65" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=65"> FIGURE 4 Result set from query in Figure 3 EmpI</a> <a title="March 2008 page 66" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=66"> ■ COMMON TABLE EXPRESSIONS Programming & Develop</a> <a title="March 2008 page 67" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=67"> A B C FIGURE 10 Revised main subselect for q</a> <a title="March 2008 page 68" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=68"> Multidimensional Grouping Made Easy Introduc</a> <a title="March 2008 page 69" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=69"> FIGURE 2 GROUP BY ROLLUP query SELECT * FROM </a> <a title="March 2008 page 70" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=70"> ■ MULTIDIMENSIONAL GROUPING FIGURE 3 FIGURE 4 G</a> <a title="March 2008 page 71" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=71"> FIGURE 5 GROUPING SET table OrderYear </a> <a title="March 2008 page 72" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=72"> ■ MULTIDIMENSIONAL GROUPING engine setting some </a> <a title="March 2008 page 73" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=73"> The query rewrite capability also includes sup</a> <a title="March 2008 page 74" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=74"> Access Data with .NET Datasets </a> <a title="March 2008 page 75" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=75"> FIGURE 1 Create a Windows Application project </a> <a title="March 2008 page 76" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=76"> ■ .NET DATASETS Programming & Development examp</a> <a title="March 2008 page 77" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=77"> </a> <a title="March 2008 page 78" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=78"> Optimize your System i... Maximize your ROI! I </a> <a title="March 2008 page 79" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=79"> Test Out Your Index AdviceTheories Generate an </a> <a title="March 2008 page 80" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=80"> add the WHERE clause after the FROM QSYS2 .SYSIXA</a> <a title="March 2008 page 81" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=81"> FIGURE 4 Second export wizard page </a> <a title="March 2008 page 82" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=82"> ■ INDEX ADVICE with the data you are importing. Y</a> <a title="March 2008 page 83" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=83"> FIGURE 10 Run SQL Scripts (import) dialog </a> <a title="March 2008 page 84" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=84"> Understanding Disk Performance Metrics Find pote</a> <a title="March 2008 page 85" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=85"> A few general considerations apply to most met</a> <a title="March 2008 page 86" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=86"> ■ DISK PERFORMANCE METRICS say that an average r</a> <a title="March 2008 page 87" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=87"> tiplier that relates service time and response ti</a> <a title="March 2008 page 88" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=88"> ■ DISK PERFORMANCE METRICS the characteristics o</a> <a title="March 2008 page 89" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=89"> age adapter cache management software designers, </a> <a title="March 2008 page 90" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=90"> Clover™Query real-time System i Web Reports & Que</a> <a title="March 2008 page 91" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=91"> Killer Club Tech Save/Restore Spooled Files in </a> <a title="March 2008 page 92" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=92"> ■ KILLER CLUB TECH named xldemo.xls in a shared</a> <a title="March 2008 page 93" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=93"> FIGURE 2 Filling in the command’s full IFS path n</a> <a title="March 2008 page 94" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=94"> ■ Dear Doctor, Our System i is in a secure colloc</a> <a title="March 2008 page 95" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=95"> SAVE! TIME WATCH iMonthly Video EW: a video ser</a> <a title="March 2008 page 96" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=96"> ADVERTISEMENT CASE STUDY </a> <a title="March 2008 page 97" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=97"> BrightenYour IT Career Prospects No matter how s</a> <a title="March 2008 page 98" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=98"> BRIGHTEN YOUR IT CAREER PROSPECTS Think Outside </a> <a title="March 2008 page 99" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=99"> and positioning you for advancement. At the same </a> <a title="March 2008 page 100" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=100"> BRIGHTEN YOUR IT CAREER PROSPECTS Although the </a> <a title="March 2008 page 101" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=101"> Automated Encryption Solutions! Guarding valuable</a> <a title="March 2008 page 102" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=102"> DB2Web Quer y? IBM says it’s time to replace Que</a> <a title="March 2008 page 103" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=103"> Virtual Appliances: Hardware Out, Images In Virt</a> <a title="March 2008 page 104" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=104"> VIRTUAL APPLIANCES preconfigured bundle. One su</a> <a title="March 2008 page 105" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=105"> minus an allowance for VMM overhead. Depending on</a> <a title="March 2008 page 106" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=106"> A=;3>3=>:3/@3>@=2C1B7D7BG4@3/9A A=;3/@33447173<1G</a> <a title="March 2008 page 107" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=107"> SOLUTION SPOTLIGHT RPGsp Integrates RPG, HTM</a> <a title="March 2008 page 108" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=108"> SOLUTION SPOTLIGHT use (i.e., shows users a pict</a> <a title="March 2008 page 109" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=109"> SystemlNetwork Special Offers ooks Compute</a> <a title="March 2008 page 110" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=110"> U\J\JI\J Computer-Based Learning E-Learnin</a> <a title="March 2008 page 111" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=111"> Microsoft EXCEL with the By Wayne Hawkins iSeri</a> <a title="March 2008 page 112" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=112"> Computer-Based Learning E-Learning Live, affordab</a> <a title="March 2008 page 113" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=113"> PROD UCT ROUND UP Accounting Applications Pro</a> <a title="March 2008 page 114" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=114"> PRODUCT ROUNDUP System i Accounting Applications</a> <a title="March 2008 page 115" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=115"> Call Now for a FREE 30-day demo! Want your desk</a> <a title="March 2008 page 116" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=116"> jr ???IfDili ??J/J THE e-TWIN@X CONT JnuE Y'S SOL</a> <a title="March 2008 page 117" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=117"> Use this index as a one-stop source of leading </a> <a title="March 2008 page 118" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=118"> 54 November 2006 March 2008 Marketplace In</a> <a title="March 2008 page 119" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=119"> March 2008 </a> <a title="March 2008 page 120" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=120"> HOT OR NOT? FastTimes with an Anxious Dog by</a> <a title="March 2008 page 121" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=121"> Robot/SPACE—Instant Disk Space Information For Yo</a> <a title="March 2008 page 122" href="https://secure.viewer.zmags.com/publication/7b1383ad?page=122"> WebSmart® offers you more Web Application Develop</a>