fhg
Volume 7, Number 18 -- May 9, 2007
Sponsored By
PRODATA COMPUTER SERVICES


Remote Database Access!

 

DBU RDB allows you to connect to your
MySQL, SQL, DB2 and Oracle databases remotely from your System i!

 

Team it up with DBU Audit to capture all adds, changes and deletes made with DBU.

 

Contact us today at 800.228.6318 or sales@prodatacomputer.com
for your FREE 30-day licensed copy.

 

www.prodatacomputer.com



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


WHERE Versus HAVING
Hey, Ted:

What is the purpose of SQL's HAVING operator? It seems to me to be unnecessary, since the WHERE operator can choose which records are to be included in the query. What am I missing? READ MORE >

Error-Checking Email Addresses, for Intelligent People
by Ted Holt

I've been less than impressed with the results of keying invalid email addresses into database files, mainly because I've had to deal with some of that undeliverable email. I recently wrote a little RPG routine that checks for glaring errors in an email address. The people for whom I wrote it liked it and thought that you might find it helpful too. READ MORE >



Sponsored By
GUILD COMPANIES

Top Titles Available at IT Jungle Bookstore

 

Our most popular titles are available for immediate order
now at the IT Jungle Bookstore.

 

Browse through our top book picks including
the iSeries Pocket and WebSphere series, and
other books by Brian Kelly.

 

Visit the IT Jungle bookstore today!
store.itjstore.com/os400.html




Admin Alert: The i5 Battery Checking Process
by Joe Hertvik

What you can't see can slow down i5 disk performance, particularly when you're dealing with the lithium ion batteries that i5 I/O adapters use to provide hard disk drive caching. Fortunately, the system i5 will warn you about aging batteries but if you ignore its warnings, failed batteries can adversely affect disk drive performance. The good news is that it's easy for IBM service to replace old batteries but there are a few tricks in determining when replacement is necessary. 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

Quadrant Software:  Become more efficient, productive, & profitable with paperless accounts payable
COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
Help/Systems:  SEQUEL is the single solution for all your business intelligence needs

 

IT Jungle Store Top Book Picks

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
IBM Focusing on i5 Account Sales, Not i5 Sales

Dr. Frank Soltis at COMMON: A Show Worth Watching

i5/OS Curriculum Contingent on Job Prospects, Business Community

As I See It: Education--the Other Dysfunction

The Linux Beacon
Brazilian Game Site Chooses Hybrid Mainframe-Cell Platform

Q&A with HP's Paul Miller: The X64 Server Biz

How To Build a Green Data Center

As I See It: Induced Labor

Four Hundred Stuff
Arcad Positions for Growth in Change Management

Profound Releases Genie, Lauded for Disney Work

iMessaging Adopts SIP for Call Center Software

ABL Unveils Strategi SOA

Big Iron
Brazilian Game Site Chooses Hybrid Mainframe-Cell Platform

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
May 5, 2007: Volume 9, Number 18

April 28, 2007: Volume 9, Number 17

April 21, 2007: Volume 9, Number 16

April 14, 2007: Volume 9, Number 15

April 7, 2007: Volume 9, Number 14

March 31, 2007: Volume 9, Number 13

The Windows Observer
Microsoft Releases First Public Beta of 'Longhorn' Server

How To Build a Green Data Center

Strong Office 2007 Sales Push Microsoft to Record Profit

Startup 3Leaf Systems Looks to Shake Up Server Virtualization

The Unix Guardian
More Details Emerge on IBM's Upcoming Power6 Server Launch

Sun Boots Solaris 10 on "Rock" Sparc Processors

Startup 3Leaf Systems Looks to Shake Up Server Virtualization

Mad Dog 21/21: Hearts and Minds

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

THIS ISSUE SPONSORED BY:

ProData Computer Services
WorksRight Software
Guild Companies



TABLE OF CONTENTS
WHERE Versus HAVING

Error-Checking Email Addresses, for Intelligent People

Admin Alert: The i5 Battery Checking Process

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Position: iSeries System Engineer

Encoded Vector Index (EVI)--throw some light

User profile for webserver instances

Can a program be written to pull data from the network?

Command line question





 
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