<br />
®/400, ISERIES, & iS<br />
SYSTEMiNETWORK.CO<br />
SystemiNEWS<br />
^APenton Publication FEBRUARY 2007<br />
RPG Patterns<br />
A Employ Software Design Patterns A Develop ILE RPG Design Patterns<br />
A Implement ILE Successfully<br />
PLUS!<br />
Is PHP<br />
for<br />
You?<br />
??? Vista: When to Upgrade?<br />
??? Product Retrospective from<br />
NEWS's First 3 Years<br />
??? Opinion: Browser-based<br />
Interfaces | Data Center Cooling<br />
??? Industry Report:<br />
The System i DBA Conundrum<br />
??? Products:<br />
Keeping Up with Downtime<br />
Threats, Raz-Lee Security's<br />
iSecurity, NGS's NGS-IQ<br />
??? And More!<br />
" r ???<br />
EXPANDED EDITION<br />
5 Essential Ways to Use the SQE Plan Cache<br />
App Modernization Case Study:<br />
Encore's Extreme Makeover<br />
' Process XML with RPG<br />
??? Explore SQL Union<br />
r Analyze Commu<a title="February 2007 page 1" href="https://secure.viewer.zmags.com/publication/955de4aa?page=1"> ®/400, ISERIES, & iS SYSTEMiNETWORK.CO Systemi</a>
<a title="February 2007 page 2" href="https://secure.viewer.zmags.com/publication/955de4aa?page=2"> Look what i can do Web Development on the Sy</a>
<a title="February 2007 page 3" href="https://secure.viewer.zmags.com/publication/955de4aa?page=3"> HIGH AVAILABILITY AND DISASTER RECOVERY HIGH AVAI</a>
<a title="February 2007 page 4" href="https://secure.viewer.zmags.com/publication/955de4aa?page=4"> B&f< (O Bsafe/Enterprise Security .^^ for </a>
<a title="February 2007 page 5" href="https://secure.viewer.zmags.com/publication/955de4aa?page=5"> FEB RUA RY 2007 Contents VIEWPOI</a>
<a title="February 2007 page 6" href="https://secure.viewer.zmags.com/publication/955de4aa?page=6"> r The Labeling Answer?? ...Si im.^mrJ*l Syst</a>
<a title="February 2007 page 7" href="https://secure.viewer.zmags.com/publication/955de4aa?page=7"> Part of the System i Network Group Publisher/Edi</a>
<a title="February 2007 page 8" href="https://secure.viewer.zmags.com/publication/955de4aa?page=8"> Control multiple iSeries and LPAR System Consoles</a>
<a title="February 2007 page 9" href="https://secure.viewer.zmags.com/publication/955de4aa?page=9"> FEEDBACK ■ The International “i” I’ve just read</a>
<a title="February 2007 page 10" href="https://secure.viewer.zmags.com/publication/955de4aa?page=10"> SYSTEM i STRATEGIST SOLUTIONS STRATEGIC DIRECT</a>
<a title="February 2007 page 11" href="https://secure.viewer.zmags.com/publication/955de4aa?page=11"> ???$>' mobileACCESS Mobile devices become full</a>
<a title="February 2007 page 12" href="https://secure.viewer.zmags.com/publication/955de4aa?page=12"> SYSTEM i STRATEGIST down to the bare bones. Beca</a>
<a title="February 2007 page 13" href="https://secure.viewer.zmags.com/publication/955de4aa?page=13"> ,V<RXU+$6ROXWLRQ 0LVVLQJ6RPHWKLQJ" 7KH2QO\</a>
<a title="February 2007 page 14" href="https://secure.viewer.zmags.com/publication/955de4aa?page=14"> SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE</a>
<a title="February 2007 page 15" href="https://secure.viewer.zmags.com/publication/955de4aa?page=15"> 9KVJQWVOQPKVQTKPIRTQDNGO LQDUECPIGVNQUVKP</a>
<a title="February 2007 page 16" href="https://secure.viewer.zmags.com/publication/955de4aa?page=16"> f.y.iSYSTEM SOLUTIONS STRATEGIC DIRECTIONS INDUS</a>
<a title="February 2007 page 17" href="https://secure.viewer.zmags.com/publication/955de4aa?page=17"> Now You Can IM 157 Million People IBM Lotus Same</a>
<a title="February 2007 page 18" href="https://secure.viewer.zmags.com/publication/955de4aa?page=18"> f.y.iSYSTEM International Bank Blazes Trail wit</a>
<a title="February 2007 page 19" href="https://secure.viewer.zmags.com/publication/955de4aa?page=19"> When I was designing the SkyView Risk Assessor a</a>
<a title="February 2007 page 20" href="https://secure.viewer.zmags.com/publication/955de4aa?page=20"> SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE</a>
<a title="February 2007 page 21" href="https://secure.viewer.zmags.com/publication/955de4aa?page=21"> """Server Proven Are my critical applications u</a>
<a title="February 2007 page 22" href="https://secure.viewer.zmags.com/publication/955de4aa?page=22"> " v À >Ì Ê ÃÊ« ÜiÀ°Ê! ÜÊ` Ê Þ ÕÊ > </a>
<a title="February 2007 page 23" href="https://secure.viewer.zmags.com/publication/955de4aa?page=23"> INDUSTRY REPORT When Pros Become Cons: The Sys</a>
<a title="February 2007 page 24" href="https://secure.viewer.zmags.com/publication/955de4aa?page=24"> INDUSTRY REPORT they upgrade from an older gene</a>
<a title="February 2007 page 25" href="https://secure.viewer.zmags.com/publication/955de4aa?page=25"> base. It doesn't mean that another database might</a>
<a title="February 2007 page 26" href="https://secure.viewer.zmags.com/publication/955de4aa?page=26"> INDUSTRY REPORT do,” are the DBAs going to answ</a>
<a title="February 2007 page 27" href="https://secure.viewer.zmags.com/publication/955de4aa?page=27"> RVI Get on the fast track with an Docum</a>
<a title="February 2007 page 28" href="https://secure.viewer.zmags.com/publication/955de4aa?page=28"> Ready for a New Approach to Data Access? Get f</a>
<a title="February 2007 page 29" href="https://secure.viewer.zmags.com/publication/955de4aa?page=29"> PRODUCT GUY Keeping Up with Downtime Threats </a>
<a title="February 2007 page 30" href="https://secure.viewer.zmags.com/publication/955de4aa?page=30"> SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE</a>
<a title="February 2007 page 31" href="https://secure.viewer.zmags.com/publication/955de4aa?page=31"> 5250 Emulation </a>
<a title="February 2007 page 32" href="https://secure.viewer.zmags.com/publication/955de4aa?page=32"> HOT NEW PRODUCTS Systems Management Tango/04 Upd</a>
<a title="February 2007 page 33" href="https://secure.viewer.zmags.com/publication/955de4aa?page=33"> A New Era for Data Replication Databases support</a>
<a title="February 2007 page 34" href="https://secure.viewer.zmags.com/publication/955de4aa?page=34"> WHICH PIECE ARE YOU MISSING? X-ANALYSIS for sou</a>
<a title="February 2007 page 35" href="https://secure.viewer.zmags.com/publication/955de4aa?page=35"> FEB RUARY 200 7 Contents TECHNOLOGY REPORTS ProV</a>
<a title="February 2007 page 36" href="https://secure.viewer.zmags.com/publication/955de4aa?page=36"> ecov DON'T GAMBLE WITH YOUR DATA ENCRYPT IT! T</a>
<a title="February 2007 page 37" href="https://secure.viewer.zmags.com/publication/955de4aa?page=37"> Software Design Patterns Learn from the past and</a>
<a title="February 2007 page 38" href="https://secure.viewer.zmags.com/publication/955de4aa?page=38"> ■ SOFTWARE DESIGN PATTERNS a way that those who </a>
<a title="February 2007 page 39" href="https://secure.viewer.zmags.com/publication/955de4aa?page=39"> Patterns at Different Levels spectr</a>
<a title="February 2007 page 40" href="https://secure.viewer.zmags.com/publication/955de4aa?page=40"> 5 Essential Ways to Use iSeries Navigator — SQL P</a>
<a title="February 2007 page 41" href="https://secure.viewer.zmags.com/publication/955de4aa?page=41"> </a>
<a title="February 2007 page 42" href="https://secure.viewer.zmags.com/publication/955de4aa?page=42"> ■ SQL PLAN CACHE then you can ignore these logic</a>
<a title="February 2007 page 43" href="https://secure.viewer.zmags.com/publication/955de4aa?page=43"> function. A dialog appears to let you spec- ify t</a>
<a title="February 2007 page 44" href="https://secure.viewer.zmags.com/publication/955de4aa?page=44"> Encore's Extreme Makeover from the Inside</a>
<a title="February 2007 page 45" href="https://secure.viewer.zmags.com/publication/955de4aa?page=45"> same time. With the interface logic so tightly en</a>
<a title="February 2007 page 46" href="https://secure.viewer.zmags.com/publication/955de4aa?page=46"> ■ EXTREME MAKEOVER different sites, reducing adm</a>
<a title="February 2007 page 47" href="https://secure.viewer.zmags.com/publication/955de4aa?page=47"> FIGURE 5 Modern technologies and components on Sy</a>
<a title="February 2007 page 48" href="https://secure.viewer.zmags.com/publication/955de4aa?page=48"> ■ EXTREME MAKEOVER cedure wrappers.) In our case</a>
<a title="February 2007 page 49" href="https://secure.viewer.zmags.com/publication/955de4aa?page=49"> The Staff and Hardware The key to our successful </a>
<a title="February 2007 page 50" href="https://secure.viewer.zmags.com/publication/955de4aa?page=50"> SPECIAL PROMOTION Transform iSeries Reports into</a>
<a title="February 2007 page 51" href="https://secure.viewer.zmags.com/publication/955de4aa?page=51"> Pattern Recognition: Ease Modern RPG Programming </a>
<a title="February 2007 page 52" href="https://secure.viewer.zmags.com/publication/955de4aa?page=52"> ■ PATTERN RECOGNITION Figure 1 shows an exc</a>
<a title="February 2007 page 53" href="https://secure.viewer.zmags.com/publication/955de4aa?page=53"> components work. The model should not know or car</a>
<a title="February 2007 page 54" href="https://secure.viewer.zmags.com/publication/955de4aa?page=54"> ■ PATTERN RECOGNITION Figure 2 shows the rout</a>
<a title="February 2007 page 55" href="https://secure.viewer.zmags.com/publication/955de4aa?page=55"> FIGURE 4 Example getter and setter A P cust_ge</a>
<a title="February 2007 page 56" href="https://secure.viewer.zmags.com/publication/955de4aa?page=56"> ■ PATTERN RECOGNITION face generic enough that y</a>
<a title="February 2007 page 57" href="https://secure.viewer.zmags.com/publication/955de4aa?page=57"> Considerations for a Successful ILE Implementatio</a>
<a title="February 2007 page 58" href="https://secure.viewer.zmags.com/publication/955de4aa?page=58"> ■ CONSIDERATIONS FOR A SUCCESSFUL ILE IMPLEMENTAT</a>
<a title="February 2007 page 59" href="https://secure.viewer.zmags.com/publication/955de4aa?page=59"> FIGURE 3 Using the procedure wizard Activat</a>
<a title="February 2007 page 60" href="https://secure.viewer.zmags.com/publication/955de4aa?page=60"> ■ CONSIDERATIONS FOR A SUCCESSFUL ILE IMPLEM</a>
<a title="February 2007 page 61" href="https://secure.viewer.zmags.com/publication/955de4aa?page=61"> names that contain a certain word (e.g., all proc</a>
<a title="February 2007 page 62" href="https://secure.viewer.zmags.com/publication/955de4aa?page=62"> ■ CONSIDERATIONS FOR A SUCCESSFUL ILE IMPLEMENTAT</a>
<a title="February 2007 page 63" href="https://secure.viewer.zmags.com/publication/955de4aa?page=63"> gram when the service program is re-cre- ated, th</a>
<a title="February 2007 page 64" href="https://secure.viewer.zmags.com/publication/955de4aa?page=64"> Use DOM and the XML Toolkit to Process XML w</a>
<a title="February 2007 page 65" href="https://secure.viewer.zmags.com/publication/955de4aa?page=65"> FIGURE 2 DOMBUILD.CLP /***********************</a>
<a title="February 2007 page 66" href="https://secure.viewer.zmags.com/publication/955de4aa?page=66"> FIGURE 3 DOMSQL.TXT -- File : DOMS</a>
<a title="February 2007 page 67" href="https://secure.viewer.zmags.com/publication/955de4aa?page=67"> FIGURE 6 Excerpt of DOMPROC.RPGLE // Unmarsha</a>
<a title="February 2007 page 68" href="https://secure.viewer.zmags.com/publication/955de4aa?page=68"> ■ USE DOM AND THE XML TOOLKIT from SampleDa</a>
<a title="February 2007 page 69" href="https://secure.viewer.zmags.com/publication/955de4aa?page=69"> FIGURE 6 CONTINUED D bytesAvailable s </a>
<a title="February 2007 page 70" href="https://secure.viewer.zmags.com/publication/955de4aa?page=70"> Programming & Development FIGURE 8 The ADDRESS t</a>
<a title="February 2007 page 71" href="https://secure.viewer.zmags.com/publication/955de4aa?page=71"> Exploring SQL Union Combine output from two S</a>
<a title="February 2007 page 72" href="https://secure.viewer.zmags.com/publication/955de4aa?page=72"> ■ SQL UNION `history' as Source from InvHist</a>
<a title="February 2007 page 73" href="https://secure.viewer.zmags.com/publication/955de4aa?page=73"> FIGURE 2 Including multiple selection criteria in</a>
<a title="February 2007 page 74" href="https://secure.viewer.zmags.com/publication/955de4aa?page=74"> CASE STUDY: ABC Fine Wine & Spirits iTera High Av</a>
<a title="February 2007 page 75" href="https://secure.viewer.zmags.com/publication/955de4aa?page=75"> Troubleshooting TCP/IP Analyze Communication Pro</a>
<a title="February 2007 page 76" href="https://secure.viewer.zmags.com/publication/955de4aa?page=76"> ■ COMMUNICATION PROBLEMS Networking & Systems Ma</a>
<a title="February 2007 page 77" href="https://secure.viewer.zmags.com/publication/955de4aa?page=77"> </a>
<a title="February 2007 page 78" href="https://secure.viewer.zmags.com/publication/955de4aa?page=78"> ■ COMMUNICATION PROBLEMS Networking & Systems Ma</a>
<a title="February 2007 page 79" href="https://secure.viewer.zmags.com/publication/955de4aa?page=79"> </a>
<a title="February 2007 page 80" href="https://secure.viewer.zmags.com/publication/955de4aa?page=80"> ■ COMMUNICATION PROBLEMS No, because you</a>
<a title="February 2007 page 81" href="https://secure.viewer.zmags.com/publication/955de4aa?page=81"> The System i Thin Console The new console on the</a>
<a title="February 2007 page 82" href="https://secure.viewer.zmags.com/publication/955de4aa?page=82"> ■ THIN CONSOLE change if you decide to add anoth</a>
<a title="February 2007 page 83" href="https://secure.viewer.zmags.com/publication/955de4aa?page=83"> ability to connect to the control panel through a</a>
<a title="February 2007 page 84" href="https://secure.viewer.zmags.com/publication/955de4aa?page=84"> Don't let the demands of your job keep you f</a>
<a title="February 2007 page 85" href="https://secure.viewer.zmags.com/publication/955de4aa?page=85"> Tech Tips Optimizing IFS Read Speeds QI have a </a>
<a title="February 2007 page 86" href="https://secure.viewer.zmags.com/publication/955de4aa?page=86"> ■ TECH TIPS will be stored, the size of that tex</a>
<a title="February 2007 page 87" href="https://secure.viewer.zmags.com/publication/955de4aa?page=87"> FIGURE 6 Attempting to get a shared lock on GLTRA</a>
<a title="February 2007 page 88" href="https://secure.viewer.zmags.com/publication/955de4aa?page=88"> ■ Dear Doctor, We recently upgraded our Ethernet </a>
<a title="February 2007 page 89" href="https://secure.viewer.zmags.com/publication/955de4aa?page=89"> 5[ORVQOHTGGUGTXGTUECPDG CMG[UQWTEGQHXKTWU</a>
<a title="February 2007 page 90" href="https://secure.viewer.zmags.com/publication/955de4aa?page=90"> WHICH PIECE ARE YOU MISSING? X-ANALYSIS for sou</a>
<a title="February 2007 page 91" href="https://secure.viewer.zmags.com/publication/955de4aa?page=91"> COVER STORY PHP May Be for i, but Is It for M</a>
<a title="February 2007 page 92" href="https://secure.viewer.zmags.com/publication/955de4aa?page=92"> PHP FOR i for easy extensibility (with .so or .d</a>
<a title="February 2007 page 93" href="https://secure.viewer.zmags.com/publication/955de4aa?page=93"> FIGURE 2 PHP's default associative arrays Array</a>
<a title="February 2007 page 94" href="https://secure.viewer.zmags.com/publication/955de4aa?page=94"> PHP FOR i IBM’s DB2 for Windows is relativel</a>
<a title="February 2007 page 95" href="https://secure.viewer.zmags.com/publication/955de4aa?page=95"> Development Environments My three favorite PHP ID</a>
<a title="February 2007 page 96" href="https://secure.viewer.zmags.com/publication/955de4aa?page=96"> Are you awash in a sea of uncharted data? i??l?</a>
<a title="February 2007 page 97" href="https://secure.viewer.zmags.com/publication/955de4aa?page=97"> Upgrading to Vista: Is Now the Right Time? by M</a>
<a title="February 2007 page 98" href="https://secure.viewer.zmags.com/publication/955de4aa?page=98"> UPGRADING TO VISTA over the counter. The Vista U</a>
<a title="February 2007 page 99" href="https://secure.viewer.zmags.com/publication/955de4aa?page=99"> Where's Auto-ID heading? Up. Auto-ID advances</a>
<a title="February 2007 page 100" href="https://secure.viewer.zmags.com/publication/955de4aa?page=100"> Isn't this precisely what you need to do w</a>
<a title="February 2007 page 101" href="https://secure.viewer.zmags.com/publication/955de4aa?page=101"> SOLUTION SPOTLIGHT A Multifaceted Approach to</a>
<a title="February 2007 page 102" href="https://secure.viewer.zmags.com/publication/955de4aa?page=102"> ■ SOLUTION SPOTLIGHT Protection from the Inside</a>
<a title="February 2007 page 103" href="https://secure.viewer.zmags.com/publication/955de4aa?page=103"> Data in the Vault Off-site, encrypted, compressed</a>
<a title="February 2007 page 104" href="https://secure.viewer.zmags.com/publication/955de4aa?page=104"> 25TH ANNIVERSARY CELEBRATION SOLUTIONS The Mo</a>
<a title="February 2007 page 105" href="https://secure.viewer.zmags.com/publication/955de4aa?page=105"> until the company released the accounts payable m</a>
<a title="February 2007 page 106" href="https://secure.viewer.zmags.com/publication/955de4aa?page=106"> CASE STUDY NGS Offers OKI Bering a Suite SOLU</a>
<a title="February 2007 page 107" href="https://secure.viewer.zmags.com/publication/955de4aa?page=107"> Microsoft Excel, Access, Word, and other Windows </a>
<a title="February 2007 page 108" href="https://secure.viewer.zmags.com/publication/955de4aa?page=108"> Visit the System iNetwork web site for con</a>
<a title="February 2007 page 109" href="https://secure.viewer.zmags.com/publication/955de4aa?page=109"> Use this index as a one-stop source of leading </a>
<a title="February 2007 page 110" href="https://secure.viewer.zmags.com/publication/955de4aa?page=110"> Solutions Library is the ultimate resource for Sy</a>
<a title="February 2007 page 111" href="https://secure.viewer.zmags.com/publication/955de4aa?page=111"> ADVERTISEMENTADVERTISEMENT Congratulations You A</a>
<a title="February 2007 page 112" href="https://secure.viewer.zmags.com/publication/955de4aa?page=112"> 5 4 November 2006 February 2007 54 Marketpla</a>
<a title="February 2007 page 113" href="https://secure.viewer.zmags.com/publication/955de4aa?page=113"> February 2007 55 Database Maintenance </a>
<a title="February 2007 page 114" href="https://secure.viewer.zmags.com/publication/955de4aa?page=114"> HOT OR NOT? It's Getting Hot in Here SOLUTIO</a>
<a title="February 2007 page 115" href="https://secure.viewer.zmags.com/publication/955de4aa?page=115"> Control Your Job Schedule Ge</a>
<a title="February 2007 page 116" href="https://secure.viewer.zmags.com/publication/955de4aa?page=116"> WebSmart lets you Modernize iSeries Applications </a>