If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
<br /> THE #1 RESOURCE FOR AS/400, iSERIES, & i 5 ^ SYSTEMiNETWORK.COM<br /> SyetemlNEWS<br /> ^0 b Penton Publication MARCH 2 00 7<br /> A Locate Ajax Resources & Components A Use Design Patterns to<br /> A Simplify Web Apps with Ajax, RPG, & XSL Levera9e AJax Development<br /> *<br /> CiVLisiS: ll'UrU aetata<br /> Willi a 13li7^L2lLaLto=:<br /> PLUS!<br /> IWIP<br /> EXPANDED EDITION<br /> xtemalize Database<br /> . rocessing<br /> Troubleshoot N<br /> Apps with TRCH<br /> Collect System i Pe<br /> Data<br /> ???' Get Familiar with IBM Director<br /> The Java SDO Data Access<br /> Option<br /> r Load 'n' Go: Sort Sequences,<br /> Field Lists, or Selection Criteria<br /> ??? And More!<br /> m<br /> V A Short History of DB2/400<br /> T How to Write a Killer Resume<br /> ??? Opinion: Wish List for i5 DB ??? Online Banking<br /> ??? Industry Report: Linux <a title="March 2007 page 1" href="https://secure.viewer.zmags.com/publication/955da42b?page=1"> THE #1 RESOURCE FOR AS/400, iSERIES, & i 5 ^ SYST</a> <a title="March 2007 page 2" href="https://secure.viewer.zmags.com/publication/955da42b?page=2"> Look what i can do Web Development on the Sy</a> <a title="March 2007 page 3" href="https://secure.viewer.zmags.com/publication/955da42b?page=3"> HIGH AVAILABILITY · DISASTER RECOVERY · SYSTEM MA</a> <a title="March 2007 page 4" href="https://secure.viewer.zmags.com/publication/955da42b?page=4"> Our Monarch solution can modernize 15,000 lines</a> <a title="March 2007 page 5" href="https://secure.viewer.zmags.com/publication/955da42b?page=5"> Contents MARCH 2007 COVER STORY </a> <a title="March 2007 page 6" href="https://secure.viewer.zmags.com/publication/955da42b?page=6"> The Labeling Answer?? ...Since 1983 ' System i </a> <a title="March 2007 page 7" href="https://secure.viewer.zmags.com/publication/955da42b?page=7"> Part of the System i Network Group Publisher/Edi</a> <a title="March 2007 page 8" href="https://secure.viewer.zmags.com/publication/955da42b?page=8"> FEEDBACK SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY</a> <a title="March 2007 page 9" href="https://secure.viewer.zmags.com/publication/955da42b?page=9"> 5&@&@>A@41$ ?e_`QYUMPYUZU_`^M`[^_M^QZµ`^QM</a> <a title="March 2007 page 10" href="https://secure.viewer.zmags.com/publication/955da42b?page=10"> GUEST VIEWPOINT 5 Things I'd Add SOLUTIONS ST</a> <a title="March 2007 page 11" href="https://secure.viewer.zmags.com/publication/955da42b?page=11"> you can try and dress up OR change from the ins</a> <a title="March 2007 page 12" href="https://secure.viewer.zmags.com/publication/955da42b?page=12"> GUEST VIEWPOINT UPDATE with a few minor changes,</a> <a title="March 2007 page 13" href="https://secure.viewer.zmags.com/publication/955da42b?page=13"> HIGH AVAILABILITY AND DISASTER RECOVERY HIGH </a> <a title="March 2007 page 14" href="https://secure.viewer.zmags.com/publication/955da42b?page=14"> GUEST VIEWPOINT immediately after you generate y</a> <a title="March 2007 page 15" href="https://secure.viewer.zmags.com/publication/955da42b?page=15"> ,Br Server Proven Are my critical applications </a> <a title="March 2007 page 16" href="https://secure.viewer.zmags.com/publication/955da42b?page=16"> Community Education Advocacy A USERS GROUP To</a> <a title="March 2007 page 17" href="https://secure.viewer.zmags.com/publication/955da42b?page=17"> SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE</a> <a title="March 2007 page 18" href="https://secure.viewer.zmags.com/publication/955da42b?page=18"> Get instant online search results for all things </a> <a title="March 2007 page 19" href="https://secure.viewer.zmags.com/publication/955da42b?page=19"> </a> <a title="March 2007 page 20" href="https://secure.viewer.zmags.com/publication/955da42b?page=20"> ' ) ! ! * ! +! 2</a> <a title="March 2007 page 21" href="https://secure.viewer.zmags.com/publication/955da42b?page=21"> , "9 $</a> <a title="March 2007 page 22" href="https://secure.viewer.zmags.com/publication/955da42b?page=22"> . .%=.+ ; # </a> <a title="March 2007 page 23" href="https://secure.viewer.zmags.com/publication/955da42b?page=23"> </a> <a title="March 2007 page 24" href="https://secure.viewer.zmags.com/publication/955da42b?page=24"> -: 9= !! !" # </a> <a title="March 2007 page 25" href="https://secure.viewer.zmags.com/publication/955da42b?page=25"> " # 9= : $%(81%, </a> <a title="March 2007 page 26" href="https://secure.viewer.zmags.com/publication/955da42b?page=26"> + # $ ## /0* "!(1 ( 20 $ $ 3</a> <a title="March 2007 page 27" href="https://secure.viewer.zmags.com/publication/955da42b?page=27"> f.y.iSYSTEM IBM's 4Q06 Solid, System i Not So Mu</a> <a title="March 2007 page 28" href="https://secure.viewer.zmags.com/publication/955da42b?page=28"> f.y.iSYSTEM News in Brief Zend's V5R3 PHP Zend</a> <a title="March 2007 page 29" href="https://secure.viewer.zmags.com/publication/955da42b?page=29"> Exploring System i's Excess Power In the last fi</a> <a title="March 2007 page 30" href="https://secure.viewer.zmags.com/publication/955da42b?page=30"> Discover System i Business Intelligence </a> <a title="March 2007 page 31" href="https://secure.viewer.zmags.com/publication/955da42b?page=31"> IBM Updates Storage Manager V5.4 IBM has upgrade</a> <a title="March 2007 page 32" href="https://secure.viewer.zmags.com/publication/955da42b?page=32"> Bsafe/Enterprise Security </a> <a title="March 2007 page 33" href="https://secure.viewer.zmags.com/publication/955da42b?page=33"> INDUSTRY REPORT Linux on System i: Infusion or</a> <a title="March 2007 page 34" href="https://secure.viewer.zmags.com/publication/955da42b?page=34"> INDUSTRY REPORT Linux on POWER Of course, you c</a> <a title="March 2007 page 35" href="https://secure.viewer.zmags.com/publication/955da42b?page=35"> Regardless, Here's the Good News Let's say that L</a> <a title="March 2007 page 36" href="https://secure.viewer.zmags.com/publication/955da42b?page=36"> iSeries to .NET Thinking of moving your iSeries </a> <a title="March 2007 page 37" href="https://secure.viewer.zmags.com/publication/955da42b?page=37"> PRODUCT GUY Mandate Mania Showing Some Benefit</a> <a title="March 2007 page 38" href="https://secure.viewer.zmags.com/publication/955da42b?page=38"> SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE</a> <a title="March 2007 page 39" href="https://secure.viewer.zmags.com/publication/955da42b?page=39"> Security Kisco Unveils </a> <a title="March 2007 page 40" href="https://secure.viewer.zmags.com/publication/955da42b?page=40"> HOT NEW PRODUCTS Programmer Tools Mrc Adds Web </a> <a title="March 2007 page 41" href="https://secure.viewer.zmags.com/publication/955da42b?page=41"> When I was designing the SkyView Risk Assessor a</a> <a title="March 2007 page 42" href="https://secure.viewer.zmags.com/publication/955da42b?page=42"> WHICH PIECE ARE YOU MISSING? X-ANALYSIS for sou</a> <a title="March 2007 page 43" href="https://secure.viewer.zmags.com/publication/955da42b?page=43"> ???Bl^ M* .'??? ^ SystemiNetwork^^com 1</a> <a title="March 2007 page 44" href="https://secure.viewer.zmags.com/publication/955da42b?page=44"> ($& % !& )*/.9*565.,25286*1)72*1) (52663/'7+</a> <a title="March 2007 page 45" href="https://secure.viewer.zmags.com/publication/955da42b?page=45"> ()&&( '67'1)!'+* 217-*!5'1) 5.; ,C"+?698>/ 8-</a> <a title="March 2007 page 46" href="https://secure.viewer.zmags.com/publication/955da42b?page=46"> ','(!5"(+#& '5&#)( "& &"$& ,/;:@5:A10 '! '("'#"(</a> <a title="March 2007 page 47" href="https://secure.viewer.zmags.com/publication/955da42b?page=47"> ! ::'1+9(5:.'685,+99/54'2:+'3'4*:566+8,583/</a> <a title="March 2007 page 48" href="https://secure.viewer.zmags.com/publication/955da42b?page=48"> ','(!5"(+#& '5&#)( "& !"((## '$&#)(&#)")$/;:@5:A</a> <a title="March 2007 page 49" href="https://secure.viewer.zmags.com/publication/955da42b?page=49"> #""# ! ;:@>;8?C45/4A?1>?4-B1-A@4;>5@E2;> </a> <a title="March 2007 page 50" href="https://secure.viewer.zmags.com/publication/955da42b?page=50"> ($& % !& I+63<E3</a> <a title="March 2007 page 51" href="https://secure.viewer.zmags.com/publication/955da42b?page=51"> MARCH 2007 Conte</a> <a title="March 2007 page 52" href="https://secure.viewer.zmags.com/publication/955da42b?page=52"> ecov DON'T GAMBLE WITH YOUR DATA ENCRYPT IT! T</a> <a title="March 2007 page 53" href="https://secure.viewer.zmags.com/publication/955da42b?page=53"> Navigating the Ajax Jungle This Ajax resour</a> <a title="March 2007 page 54" href="https://secure.viewer.zmags.com/publication/955da42b?page=54"> ■ NAVIGATING THE AJAX JUNGLE Technology Reports </a> <a title="March 2007 page 55" href="https://secure.viewer.zmags.com/publication/955da42b?page=55"> FIGURE 1 CONTINUED Name </a> <a title="March 2007 page 56" href="https://secure.viewer.zmags.com/publication/955da42b?page=56"> ■ NAVIGATING THE AJAX JUNGLE Technology Reports </a> <a title="March 2007 page 57" href="https://secure.viewer.zmags.com/publication/955da42b?page=57"> FIGURE 2 Ajax components survey Name </a> <a title="March 2007 page 58" href="https://secure.viewer.zmags.com/publication/955da42b?page=58"> ■ NAVIGATING THE AJAX JUNGLE FIGURE 2 CONTINUED </a> <a title="March 2007 page 59" href="https://secure.viewer.zmags.com/publication/955da42b?page=59"> Service Data Objects: A New D</a> <a title="March 2007 page 60" href="https://secure.viewer.zmags.com/publication/955da42b?page=60"> ■ SERVICE DATA OBJECTS Application Code currency</a> <a title="March 2007 page 61" href="https://secure.viewer.zmags.com/publication/955da42b?page=61"> vert the XML query definition into an SQL stateme</a> <a title="March 2007 page 62" href="https://secure.viewer.zmags.com/publication/955da42b?page=62"> iSeries to .NET Thinking of moving your iSeries </a> <a title="March 2007 page 63" href="https://secure.viewer.zmags.com/publication/955da42b?page=63"> Ajax Design Patterns Use design patterns to le</a> <a title="March 2007 page 64" href="https://secure.viewer.zmags.com/publication/955da42b?page=64"> ■ AJAX DESIGN PATTERNS Programming & Development</a> <a title="March 2007 page 65" href="https://secure.viewer.zmags.com/publication/955da42b?page=65"> of view if the number of fields exceeds the size </a> <a title="March 2007 page 66" href="https://secure.viewer.zmags.com/publication/955da42b?page=66"> ■ AJAX DESIGN PATTERNS ciated with the splitter</a> <a title="March 2007 page 67" href="https://secure.viewer.zmags.com/publication/955da42b?page=67"> The Yahoo e-mail client does a nice job of this. </a> <a title="March 2007 page 68" href="https://secure.viewer.zmags.com/publication/955da42b?page=68"> Simplifying Web Apps with Ajax, RPG, and XSL The</a> <a title="March 2007 page 69" href="https://secure.viewer.zmags.com/publication/955da42b?page=69"> FIGURE 2 XML for SOAP response FI</a> <a title="March 2007 page 70" href="https://secure.viewer.zmags.com/publication/955da42b?page=70"> ■ SIMPLIFYING WEB APPS WITH AJAX check to see</a> <a title="March 2007 page 71" href="https://secure.viewer.zmags.com/publication/955da42b?page=71"> an RPG analogy, XSL templates are similar to RPG </a> <a title="March 2007 page 72" href="https://secure.viewer.zmags.com/publication/955da42b?page=72"> Externalize Database Processing Make y</a> <a title="March 2007 page 73" href="https://secure.viewer.zmags.com/publication/955da42b?page=73"> FIGURE 1 Using setters, getters, and validaters </a> <a title="March 2007 page 74" href="https://secure.viewer.zmags.com/publication/955da42b?page=74"> ■ EXTERNALIZE DATABASE PROCESSING the format of</a> <a title="March 2007 page 75" href="https://secure.viewer.zmags.com/publication/955da42b?page=75"> FIGURE 6 Subprocedures to assign and release hand</a> <a title="March 2007 page 76" href="https://secure.viewer.zmags.com/publication/955da42b?page=76"> ■ EXTERNALIZE DATABASE PROCESSING Programming & </a> <a title="March 2007 page 77" href="https://secure.viewer.zmags.com/publication/955da42b?page=77"> A B C D E F FIGU</a> <a title="March 2007 page 78" href="https://secure.viewer.zmags.com/publication/955da42b?page=78"> ■ EXTERNALIZE DATABASE PROCESSING retrieves the</a> <a title="March 2007 page 79" href="https://secure.viewer.zmags.com/publication/955da42b?page=79"> Load 'n' Go Subfile Command for CL The LISTS</a> <a title="March 2007 page 80" href="https://secure.viewer.zmags.com/publication/955da42b?page=80"> ■ LOAD 'N' GO Programming & Development line. I</a> <a title="March 2007 page 81" href="https://secure.viewer.zmags.com/publication/955da42b?page=81"> </a> <a title="March 2007 page 82" href="https://secure.viewer.zmags.com/publication/955da42b?page=82"> ■ LOAD 'N' GO and replaces it with the header de</a> <a title="March 2007 page 83" href="https://secure.viewer.zmags.com/publication/955da42b?page=83"> will be an issue. Length of the SQL before the</a> <a title="March 2007 page 84" href="https://secure.viewer.zmags.com/publication/955da42b?page=84"> ADVERTISEMENT CASE STUDY: ABC Fine Wine & Spiri</a> <a title="March 2007 page 85" href="https://secure.viewer.zmags.com/publication/955da42b?page=85"> Troubleshooting TCP/IP Trace the Inner Workings </a> <a title="March 2007 page 86" href="https://secure.viewer.zmags.com/publication/955da42b?page=86"> ■ TRACE INNER WORKINGS system. Think of a socke</a> <a title="March 2007 page 87" href="https://secure.viewer.zmags.com/publication/955da42b?page=87"> FIGURE 3 Format of TRCINT record other unique fa</a> <a title="March 2007 page 88" href="https://secure.viewer.zmags.com/publication/955da42b?page=88"> ■ TRACE INNER WORKINGS errno values are </a> <a title="March 2007 page 89" href="https://secure.viewer.zmags.com/publication/955da42b?page=89"> FIGURE 6 : bind() entry FIGURE 7 bind() ex</a> <a title="March 2007 page 90" href="https://secure.viewer.zmags.com/publication/955da42b?page=90"> ■ TRACE INNER WORKINGS FIGURE </a> <a title="March 2007 page 91" href="https://secure.viewer.zmags.com/publication/955da42b?page=91"> </a> <a title="March 2007 page 92" href="https://secure.viewer.zmags.com/publication/955da42b?page=92"> ■ TRACE INNER WORKINGS data over the network (e</a> <a title="March 2007 page 93" href="https://secure.viewer.zmags.com/publication/955da42b?page=93"> Collect System i Performance Data with</a> <a title="March 2007 page 94" href="https://secure.viewer.zmags.com/publication/955da42b?page=94"> ■ COLLECTION SERVICES The raw data that's col</a> <a title="March 2007 page 95" href="https://secure.viewer.zmags.com/publication/955da42b?page=95"> </a> <a title="March 2007 page 96" href="https://secure.viewer.zmags.com/publication/955da42b?page=96"> Inside Systems Management IBM Direc</a> <a title="March 2007 page 97" href="https://secure.viewer.zmags.com/publication/955da42b?page=97"> to manage a whole subnet of systems, I use the di</a> <a title="March 2007 page 98" href="https://secure.viewer.zmags.com/publication/955da42b?page=98"> FIGURE 3 Resource monitors on i5/OS Networking &</a> <a title="March 2007 page 99" href="https://secure.viewer.zmags.com/publication/955da42b?page=99"> useful information for i5/OS, you have to hunt an</a> <a title="March 2007 page 100" href="https://secure.viewer.zmags.com/publication/955da42b?page=100"> Secured, single point Web access to your iSeries </a> <a title="March 2007 page 101" href="https://secure.viewer.zmags.com/publication/955da42b?page=101"> Killer Club Tech Finding Passwords That Match </a> <a title="March 2007 page 102" href="https://secure.viewer.zmags.com/publication/955da42b?page=102"> ■ KILLER CLUB TECH important to know which user</a> <a title="March 2007 page 103" href="https://secure.viewer.zmags.com/publication/955da42b?page=103"> FIGURE 1 Display Module Source screen Display </a> <a title="March 2007 page 104" href="https://secure.viewer.zmags.com/publication/955da42b?page=104"> by Mel Beckman ■ Dear Doctor, We've configu</a> <a title="March 2007 page 105" href="https://secure.viewer.zmags.com/publication/955da42b?page=105"> 5&@&@>A@4# 5ZMPQ]aM`QYQM_a^Q_R[^_QOa^U`eO[</a> <a title="March 2007 page 106" href="https://secure.viewer.zmags.com/publication/955da42b?page=106"> WHICH PIECE ARE YOU MISSING? X-ANALYSIS for sou</a> <a title="March 2007 page 107" href="https://secure.viewer.zmags.com/publication/955da42b?page=107"> Cruising Megadata: </a> <a title="March 2007 page 108" href="https://secure.viewer.zmags.com/publication/955da42b?page=108"> CRUISING MEGADATA terabytes, companies are exper</a> <a title="March 2007 page 109" href="https://secure.viewer.zmags.com/publication/955da42b?page=109"> FIGURE 3 Star schema fact and dimensions informat</a> <a title="March 2007 page 110" href="https://secure.viewer.zmags.com/publication/955da42b?page=110"> CRUISING MEGADATA </a> <a title="March 2007 page 111" href="https://secure.viewer.zmags.com/publication/955da42b?page=111"> Give your company an edge. Go paperless. Documen</a> <a title="March 2007 page 112" href="https://secure.viewer.zmags.com/publication/955da42b?page=112"> (OHFWURQLF)RUPV %XVLQHVV,QWHOOLJHQFH </a> <a title="March 2007 page 113" href="https://secure.viewer.zmags.com/publication/955da42b?page=113"> 25TH ANNIVERSARY CELEBRATION A Short Histor</a> <a title="March 2007 page 114" href="https://secure.viewer.zmags.com/publication/955da42b?page=114"> 25TH ANNIVERSARY CELEBRATION address space. If </a> <a title="March 2007 page 115" href="https://secure.viewer.zmags.com/publication/955da42b?page=115"> support symmetric multiprocessing (SMP) to exploi</a> <a title="March 2007 page 116" href="https://secure.viewer.zmags.com/publication/955da42b?page=116"> '%&<''///// \%&&2^t&</a> <a title="March 2007 page 117" href="https://secure.viewer.zmags.com/publication/955da42b?page=117"> CAREER TRACK Write a Killer Résumé Follow t</a> <a title="March 2007 page 118" href="https://secure.viewer.zmags.com/publication/955da42b?page=118"> CAREER TRACK “high maintenance” employees who ch</a> <a title="March 2007 page 119" href="https://secure.viewer.zmags.com/publication/955da42b?page=119"> FIGURE 2 Example of a functionally organized résu</a> <a title="March 2007 page 120" href="https://secure.viewer.zmags.com/publication/955da42b?page=120"> CAREER TRACK the human resource contact's name, </a> <a title="March 2007 page 121" href="https://secure.viewer.zmags.com/publication/955da42b?page=121"> Tw]/J2J jrxxrx)JJSiS TjTX>J"/J 2J/J xJsr i/</a> <a title="March 2007 page 122" href="https://secure.viewer.zmags.com/publication/955da42b?page=122"> THE COMPLETE ENTERPRISE DOCUMENT MANAGEMENT SOLUT</a> <a title="March 2007 page 123" href="https://secure.viewer.zmags.com/publication/955da42b?page=123"> SOLUTION SPOTLIGHT An On-RAMP for SOA by John</a> <a title="March 2007 page 124" href="https://secure.viewer.zmags.com/publication/955da42b?page=124"> ■ SOLUTION SPOTLIGHT Once users are happy, </a> <a title="March 2007 page 125" href="https://secure.viewer.zmags.com/publication/955da42b?page=125"> Data in the Vault Off-site, encrypted, compressed</a> <a title="March 2007 page 126" href="https://secure.viewer.zmags.com/publication/955da42b?page=126"> CN CO 0) i ? Clean up your address data</a> <a title="March 2007 page 127" href="https://secure.viewer.zmags.com/publication/955da42b?page=127"> PRODUCT ROUNDUP Program Documentation Tools P</a> <a title="March 2007 page 128" href="https://secure.viewer.zmags.com/publication/955da42b?page=128"> PRODUCT ROUNDUP Program Documentation Tools Doc</a> <a title="March 2007 page 129" href="https://secure.viewer.zmags.com/publication/955da42b?page=129"> Business Intelligence, Anywhere, Anytime. NG</a> <a title="March 2007 page 130" href="https://secure.viewer.zmags.com/publication/955da42b?page=130"> DEMO BOOTH SOLUTIONS STRATEGIC DIRECTIONS INDUS</a> <a title="March 2007 page 131" href="https://secure.viewer.zmags.com/publication/955da42b?page=131"> FIGURE 2 Initial layout of BRMS </a> <a title="March 2007 page 132" href="https://secure.viewer.zmags.com/publication/955da42b?page=132"> ■ DEMO BOOTH policy that lists the locations w</a> <a title="March 2007 page 133" href="https://secure.viewer.zmags.com/publication/955da42b?page=133"> FIGURE 7 Rich data available in the columns sch</a> <a title="March 2007 page 134" href="https://secure.viewer.zmags.com/publication/955da42b?page=134"> Use this index as a one-stop source of leading </a> <a title="March 2007 page 135" href="https://secure.viewer.zmags.com/publication/955da42b?page=135"> Solutions Library </a> <a title="March 2007 page 136" href="https://secure.viewer.zmags.com/publication/955da42b?page=136"> 6 2 November 2006 March 2007 62 TOTAL400 Tool</a> <a title="March 2007 page 137" href="https://secure.viewer.zmags.com/publication/955da42b?page=137"> March 2007 63 Change Management PDE/400 </a> <a title="March 2007 page 138" href="https://secure.viewer.zmags.com/publication/955da42b?page=138"> HOT OR NOT? SOLUTIONS STRATEGIC DIRECTIONS IND</a> <a title="March 2007 page 139" href="https://secure.viewer.zmags.com/publication/955da42b?page=139"> Control Your Job Schedule Ge</a> <a title="March 2007 page 140" href="https://secure.viewer.zmags.com/publication/955da42b?page=140"> WebSAWOrt lets you Modernize iSeries Applications</a>