fhg
Volume 7, Number 37 -- October 24, 2007
Sponsored By
WORKSRIGHT SOFTWARE

Do you need area codes?
Do you need ZIP Codes?
Do you need ZIP+4?
Do you need city or county names?
Do you need a dealer locator system?

 

We can HELP!
We have affordable AS/400 software
and data to do all of the above.
Call us for 30 days FREE.

 

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


Sponsored By
HELP/SYSTEMS

Discover Robot/SECURITY, the i5/OS security monitoring and auditing software, from Help/Systems

 

                    · Profile Exchange
                    · Exit Point Monitoring
                    · System Authority Auditing
                    · QAUDJRN Monitoring
                    · System Security Analysis

 

Robot/SECURITY is the only security software that combines five critical System i security tools in one package.

 

Visit our Web site at http://www.helpsystems.com/400g-sec/
to learn more about Robot/SECURITY.


Good Reasons to Use Unrequired Correlation Names
by Ted Holt

Correlation names are alternate names given to tables in an SQL command. Sometimes correlation names are required. Other times they are optional, but helpful. I would go so far as to say that it is good practice to use correlation names as often as possible, even when they are not obligatory. Let me share two good reasons to do so. READ MORE >

Externally Described Database IO through Data Structures
by Ted Holt

Eons ago, IBM enhanced the RPG compiler by allowing program-described files to define data formats using data structures instead of Input and Output specs. I have taken advantage of this ability from time to time since then, and would be willing to testify in anybody's court of law that I don't miss I and O specs one little bit. It was much later, in V5R2, that IBM decided that data structures should be allowed for externally described files as well. I was not so excited about this decision until recently, when I realized that the use of data structures for externally described database files could help me improve the 'clonability' of a certain file-maintenance template that I clone on a frequent and recurring basis. But first I had to learn to use externally described data structures correctly. READ MORE >



Sponsored By
COMPUTER MEASUREMENT GROUP

CMG '07 International Conference
Enterprise Computer Performance Management
December 2-7, San Diego

 

Learn how to master today's most demanding enterprise computer performance management challenges at CMG '07-December 2-7 in San Diego. CMG '07 is the world's largest gathering of IT professionals focused on performance optimization…capacity planning…and resource management for enterprise computing systems. This 33rd annual conference is sponsored by the Computer Measurement Group (CMG), a not-for-profit worldwide association for systems management professionals.

 

Register today at www.cmg.org
Or call 800-436-7264




Admin Alert: The System i High Availability Roadmap
by Joe Hertvik

I've recently been involved in a high availability (HA) project where the goal is to be able to switch processing from a failed System i box to a Capacity Backup (CBU) machine within one hour of failure. Growing from that experience, this week's column is the first of an occasional series where I'll discuss HA concepts and how i5/OS administrators can expedite continuous availability procedures in their shop. READ MORE >


Reader Feedback and Insights

We value your feedback and insights.  Feel free to send a letter to the editor.  Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >


 
Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

 

Sponsored Links

COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
BOSaNOVA:  Download our 'Best Practices for Securing your Backup' whitepaper
NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

 

 

IT Jungle Store Top Book Picks

The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
State of the System i: First-Hand Reports from Second-Hand Dealers

System i Sales Drop Again in Q3, IBM Says Little

IBM Hit by Financial Services Slowdown in Q3

Mad Dog 21/21: Symphony for the Devil

The Linux Beacon
Ubuntu Hits Launch Target for 7.10 Linux Release

Novell Delivers Workgroup Software Bundle for SMBs

Intel Is Back on Track in Q3, AMD Is Fighting to Get There

IBM Hit by Financial Services Slowdown in Q3

Four Hundred Stuff
Talend Adds i5/OS Support to Open Source ETL Tool

VAI to Deliver Flexible Computer-Telephone Integration, Thanks to iMS

LogLogic Delivers Fine-Grained User Activity Monitoring

NGS Launches Pre-Built Data Mart for Distributors

Big Iron
IBM Hit by Financial Services Slowdown in Q3

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
October 20, 2007: Volume 9, Number 42

October 13, 2007: Volume 9, Number 41

October 6, 2007: Volume 9, Number 40

September 29, 2007: Volume 9, Number 39

September 22, 2007: Volume 9, Number 38

September 15, 2007: Volume 9, Number 37

The Windows Observer
Office Communication Server 2007 Launched by Microsoft

Will OCS 2007 Live Up to the Hype?

Zend Puts Out New Release of Commercial-Grade PHP

Growing Businesses, Upgrades Drive IT Hiring in Q4

The Unix Guardian
Sun Elaborates on its xVM Virtualization Plans

Apple's Leopard Mac OS X Server Coming October 26

IBM Hit by Financial Services Slowdown in Q3

As I See It: Great Looking Genes

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
Computer Measurement Group



TABLE OF CONTENTS
Good Reasons to Use Unrequired Correlation Names

Externally Described Database IO through Data Structures

Admin Alert: The System i High Availability Roadmap

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Finding *OUTFILE Template Files

i5/OS V5R4 Release Notes

MCH1202

Crashing processes!

SQL 'Hidden' Field





 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement