fhg
Volume 7, Number 23 -- May 23, 2007
Four Hundred Guru is taking a vacation next week and will resume publishing on June 6.
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
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



Send a Spool File from AS/400 with a Specific Subject Line and Message Body
Hey, Ted:

A while back, I was working on a project that required an e-mail to be sent with a resulting spool file as an attachment and with a specific subject line and specific message body. I had no trouble figuring out how to send the spool file as a document and how to create the message body. The hard part was customizing the subject line of the e-mail. This was important because the subject line would have provided the users a hint about the urgency of the task they need to perform. READ MORE >

Searching for Wildcard Characters
by Ted Holt

If you happen to see a bald-headed old geezer staring at a shelf at the local home-improvement warehouse (motto: you can do it; we can laugh), that's me. I don't know what I'm looking for, but I'm foolish enough to think I'll recognize it when I see it. My methodology is something like searching a database using wildcard characters, which is what today's tip is about. READ MORE >



Sponsored By
LASERVAULT

How do you know your AS/400 Backups are Secure?

 

· AES Encryption for Secure Backups
· Uses SAVLIB and SAVOBJ for easy implementation
· Meets compliance requirements
· No changes to your system
· Runs on network attached PC

 

Your offsite backups are secure no matter who has them, since they are fully encrypted.

 

Don't be the next embarrassing news story.
Secure your iSeries backups with LaserVault Backup -
www.laservaultbackup.com




Admin Alert: i5 IPL Pre-Planning and Post-Planning Checklists
by Joe Hertvik

Unlike Windows servers, which can be rebooted several times a year, i5, iSeries, and AS/400 partitions are so legendarily reliable that IPLing one can become an event. And like any good event, it takes some planning to prepare for the opportunities and risks an IPL presents. To aid you in that planning, here's my list of things to consider when you're ready to restart a partition. 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 Help/Systems:  SEQUEL is the single solution for all your business intelligence needs
LaserVault:  AES Encryption for secure AS/400 backups with no changes to your system

 

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 Tweaks i5 515 and 525 User-Based Prices

An i5 Platform: Q&A with Marlin Equity's Top Brass

The Gulf Between Buyers and Sellers Widens in IT, Says IDC

As I See It: Operating on Overload

The Linux Beacon
Microsoft Claims Linux Violates 42 of Its Patents

Red Hat, IBM Commit to Better Mainframe Linux

IBM Launches First Power6-Based Server

The Gulf Between Buyers and Sellers Widens in IT, Says IDC

Four Hundred Stuff
Rochester Alums Plan New Customer Care App for i

Lakeview Touts Customer Win at Competitor's Expense

HarrisData Serves Competitive Party Goods Maker for 14 years

ProData Goes Cross-Platform with DBU

Big Iron
Red Hat, IBM Commit to Better Mainframe Linux

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
May 19, 2007: Volume 9, Number 20

May 12, 2007: Volume 9, Number 19

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

The Windows Observer
It's Official: Windows Server 2008

Microsoft Slashes 'Viridian' Features to Meet Ship Date

Microsoft Talks Up SQL Server 'Katmai'

Microsoft Claims Linux Violates 42 of Its Patents

The Unix Guardian
HP Turns in a Solid Fiscal 2007 Second Quarter

IBM's AIX Roadmap Through 2015

Sun's Board Authorizes $3 Billion in Share Buybacks

The X Factor: Small Is Beautiful

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

THIS ISSUE SPONSORED BY:

WorksRight Software
ProData Computer Services
LaserVault



TABLE OF CONTENTS
Send a Spool File from AS/400 with a Specific Subject Line and Message Body

Searching for Wildcard Characters

Admin Alert: i5 IPL Pre-Planning and Post-Planning Checklists

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
SBMJOB

How to calculate the last day of the month

iSeries Career training ideas

Authority to IFS

User profile for webserver instances





 
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