If you are visually impaired or blind, you can visit the PDF version by Pressing CONTROL + ALT + 4
You need a JavaScript-enabled browser to view this Publication
Please follow these steps to view the Publication:
Enable JavaScript in your browser
Refresh this page
Best regards
Zmags
THE #1 RESOURCE FOR AS/400, iSERIES, & i 5 ^>?? SYSTEMiNETWORK.COM
It
A Penton Publication
iNEWS
JANUARY 2007
6Disaster Recovery
rtual Tape: The "Real" Deal A Disaster Recovery on a Shoestring
^H AIPL from External Storage: HA Nirvana?
jelcl Guidetothe
??J AX Ecosystem
^
\JAX
*t
PLUS!
??? 25 Years of NEWS:
Predictions from the Past
??? Workplace Implementation Tricks & Traps
??? Blueprint for Mergers & Acquisitions
??? Opinion: Do's & Don'ts for 2007
Server Technologies
??? Industry Report:
Explore System i's Excess Power
??? Products: 2006's Most Interesting
System i Products, Roundup of
System i Help Desk Apps
??? And More!
EXPANDED EDITION
??? S Essential Ways to Use Navigator
'??? Ajax in Action
??? UDTFs-The Unsung DB2 Function
??? Collect and Anal
THE #1 RESOURCE FOR AS/400, iSERIES, & i 5 ^>??
Look what i can do Web Development on the Sy
HIGH AVAILABILITY AND DISASTER RECOVERY HIGH AVAI
Data in the Vault Off-site, encrypted, compressed
Contents JANUARY 2007 COVER STO
B&fe Bsafe/Enterprise Security for System i and
Part of the System i Network Group Publisher/Edi
Providing Essential Education for System i Profes
E-LEARNING Sign up for invaluable instruction on
FROM THE TRENCHES The Do's and Don'ts for 200
u Mobile devices become fully- functional iSer
Ready for a New Approach to Data Access? Get
25TH ANNIVERSARY CELEBRATION Turns of Fortune
True high availability provides an exact duplicat
To iearn more call + 1.801.799.0300, + 1.800.957
25TH ANNIVERSARY CELEBRATION most phone systems
nant language in use — but not for new applicatio
SOLUTIONS STRATEGIC DIRECTIONS INDUSTRY WATCH VIE
"=6616/.7=:,1..-:-6<78-:)<16/;A;<-5;;=887:<16/ 8-
7.7:80)6,)<)<:)6;)+<176)416.7:5)<176)6,,)<) =8,)<
+7551<<-,=8<7<0-575-6<7.;A;<-547;; ->-4;7. "=;=)
16?01+0)4467,-;5)16<)16<0-1:7?6,)<):-841+); 6 <01
$01;51::7:-,15)/-16+4=,-;)44<0-=;-:,)<);A;<-5 ,)<
(1+, %+ *-#!& '%(&1,1+(& -&&!& /!, (1+, %+&
*'(!& +!&'& +'*, ,+ '&%'', ! *,!'&/!,
&, *(*!+ ,'* '!&+('*,+-* +'* +-$!,1
'! + $ * '*!+!'&'$-,!'&+ ! .!$!$
A62@6;09B12*6@6<;@=.A2;A21F0960.9&21B;1.;0F5208
# .! / &'$' 1 & -!0,* &&'., +- ++/!,
f.y.iSYSTEM iTera, Vision Solutions Merge In th
f.y.iSYSTEM Study Shows Elevated Cancer Deaths
Certifications, Smertifications IT workforce be
TG/fK In today's constantly changing world, cont
this service ceased on October 31, and support wi
Isn't this precisely what you need to do w
INDUSTRY REPORT Exploring System i's Excess Po
INDUSTRY REPORT EnterpriseOne, is that IBM has
.INFRASTRUCTURE LOG _DAY 22: We've taken "add an
PRODUCT GUY Rounding the Post Again SOLUTIONS
*??? / have control. I have a System /.??? Sy
HOT NEW PRODUCTS Security Counterpane Extends
HOT NEW PRODUCTS Prog
THE BEST JUST GOT BETTER!
X-ANALYSIS · Drill-Down, Multi-Level Cross Refe
-
How do you load relational XML data into your iSe
* /:.
,9* /:.@809?!9.0D:@A04>:7,?0/?30/,?,
Need to generate XML for your iSeries? Need to p
JANUARY 2007 Con
T tf Do you encrypt your tape backups and dat
Virtual Tape: The Real Deal Save to DASD without
■ VIRTUAL TAPE: THE REAL DEAL 3. Create virtua
FIGURE 2 Media used with the save commands Medi
■ VIRTUAL TAPE: THE REAL DEAL restore operations.
5 Essential Ways to Use iSeries Navigator — Vi
Technology Reports ■ VISUAL EXPLAIN 2. Check t
FIGURE 5 Object info in right pane of Visual Expl
WebSmart® lets you Modernize System i apps Easier
Ajax in Action Use Ajax to create exciting, dyn
■ AJAX IN ACTION Programming & Development exce
application, you would need to handle the error,
■ AJAX IN ACTION which you must implement. In t
UDTFs: The Unsung DB2 Function
■ UDTFs Programming & Development by an SQL vie
FIGURE 6 Syntax diagram detailing table function
■ UDTFs Programming & Development parameters to
FIGURE 10 RPG program F-specs fDEPMAST
■ UDTFs Programming & Development The done-p
FIGURE 18 Input specs coded to match record layou
■ UDTFs execute logic to return the data for all
■ LOAD 'N' GO Give Users Flexible Parameters
■ LOAD 'N' GO Standard System i screens are u
FIGURE 5 Parameter components and subparameters
■ LOAD 'N' GO Save File Upload SystemiNetwork.com
To Err Is Human, to Error Trap Is Divine U
■ ERROR TRAP sented by a negative one, or the c
E FIGURE 1 continued If aRate < VALIDRAT
HIGH AVAILABILITY AND DISASTER RECOVERY HIGH AVAI
Business Continuity with External Storage Choose
■ BUSINESS CONTINUITY Networking & Systems Manag
450 400
■ BUSINESS CONTINUITY 140 Networking & Systems
Disaster Recovery on a Shoestring Use periodic d
■ DISASTER RECOVERY ON A SHOESTRING Netw
FIGURE 3A Saving a copy of the remote journal rec
■ DISASTER RECOVERY ON A SHOESTRING Networ
resulting APYJRNCHGX operation struggles to keep
Troubleshooting TCP/IP Identify Network Proble
FIGURE 1 Communications stack layers
■ COMMUNICATIONS TRACE mine which line or lines
packets sent and received from a particular remot
■ COMMUNICATIONS TRACE and port numbers
FIGURE 6 PRTCMNTRC command output F
■ COMMUNICATIONS TRACE Networking & Syst
Let Your System i Call Home over the Web
■ SYSTEM i CALL HOME 5. Figure 1 lists the
FIGURE 1 V5R3 CRTSRVCFG connection profile names
TRY IT FOR YOURSELF – search System iPortal today
Tech Tips Initialize an Automatic Batch FTP Tra
■ TECH TIPS FROM QATOCSTART WHERE SERVERTYPE
FAQs: System i Access Family by Linda Hirsch
■ Dear Doctor, We have upgraded several of our de
5[ORVQOHTGGUGTXGTUECPDG CMG[UQWTEGQHXKTWU
Modernize RPG to Model View Controller
COVER STORY AJAX FIELD GUIDE Understand the Ajax
AJAX FIELD GUIDE 20524 at SystemiNetwork.com), i
next section. Prototype (sergiopereira.com/art
AJAX FIELD GUIDE iteratively develop code, rapi
side code and SQL in the server-side code, and it
I A USERS GROUP ??0MMU ' More Education Optio
Blueprint for Mergers and Acquisitions Collect a
MERGERS AND ACQUISITIONS roles, because brain d
When I was designing the SkyView Risk Assessor a
Attention PATHFINDER/400 Users: foHhetBM 1 Netw
MERGERS AND ACQUISITIONS If your company is
MERGERS AND ACQUISITIONS addressed? A help desk
An Integration Primer Because every organization
Are you awash in a sea of uncharted data? Vil
PRODUCT ROUNDUP System i IT Help Desk Applicat
PRODUCT ROUNDUP System i IT Help GS/HelpDesk Gr
MIMIX. #1 in High Availability. “MIMIX is th
iVÌ }Ê`>Ì> Ã Ê ÌÊÜ À ÃÊv ÀÊÞ Õ° >
Workplace Implementation: Tricks and Traps In th
WORKPLACE IMPLEMENTATION Remember that, except f
and you shouldn't be surprised if people start to
WORKPLACE IMPLEMENTATION This wizard saves hours
Compliance Made Simple!
TWJ/J5J Dm an N<@X CONTROLLER - TODAY'S S
WORKPLACE IMPLEMENTATION Performance Tuning In W
WORKPLACE IMPLEMENTATION If you have Domino
CN CO <* 0) 8 x ro n oo co in co o c
interactive presentation and demonstration with
Use this index as a one-stop source of leading
Solutions Library
January 2007 63 FORMagic/400 eForms Software Q
HOT OR NOT? Survival of the Fittest? SOLUTIO
E ersio 1 .0! N W V n 1 Encrypt You
Barcode pplication Examples EPC carton labels