fhg
Volume 7, Number 38 -- October 10, 2007
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.


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


Controlling System i Shutdown Activities Using an Intelligent Power-Handling Program, Part I
Hey Brian:

It happened. We had our system about a year and we had a power crash over the weekend. Yes, we have a UPS, but that does not mean that when the system was starved for power it did not come crashing down, and things got worse after that. When we got the UPS, the boss decided that we would get the version that kept the system up for eight minutes instead of getting the extra battery for 37 minutes. We set the delay timer (QUPSDLYTIM) at two minutes. How is it that we crashed so hard? READ MORE >

Programmatically Import Excel Worksheets Using IBM's ActiveX Object Library
by Michael Sansoterra

Everybody likes to export DB2 data to an Excel spreadsheet. It's quick and easy, and there are plenty of ways to do it. On the other hand, I'm often asked by people, including fellow developers, to assist them with importing an Excel worksheet into a DB2 table. In fact, what developer hasn't had the experience of a bean counter asking for assistance in uploading a spreadsheet into an ERP system? READ MORE >



Sponsored By
DRV TECHNOLOGIES

How Much Time Would You Save Automatically Converting and Distributing Your AS/400 Reports?

 

SpoolFlex automatically converts spooled files to PDF and Excel, E-mails from your AS/400, and saves copies to your network server. Search, view and re-send original reports without generating them again. Start saving time today!

 

Visit www.drvtech.com or
call 866 378-3366 for a demonstration.

 

Download your FREE Trial




Admin Alert: Remotely Accessing an HMC System Console, Part 2
by Joe Hertvik

Last week, I began demonstrating a technique to allow a remote 5250 session to attach to and run an i5/OS system console located on a Hardware Management Console (HMC). In part 1, I provided details on configuring the HMC to accept remote 5250 sessions. This week, I'll examine the PC side and look at configuring an iSeries Access for Windows session to access the system console on the HMC. 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

SafeData:  The iSeries HA Solution that’s Guaranteed
COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
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
IBM Offers System i Blade Deal, Nixes i5 550 in Upgrade Deal

IBM Tweaks BladeCenter S for the Office, Preps Power6 Blades

Growing Businesses, Upgrades Drive IT Hiring in Q4

As I See It: Great Looking Genes

The Linux Beacon
Novell Delivers openSUSE 10.3 Linux Development Release

IBM Tweaks BladeCenter S for the Office, Preps Power6 Blades

Novell Actually Ships Open Enterprise Server 2

Growing Businesses, Upgrades Drive IT Hiring in Q4

Four Hundred Stuff
looksoftware's Modernization Suite Resembling a Full IDE

Pat Townsend Normalizes i5/OS Log Data for Security Analyses

Linoma Boosts Surveyor/400's SQL Functionality

PowerTech Updates Compliance Manager

Big Iron
Leasing and Financing Are Important IT Tools, Says IDC

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
October 6, 2007: Volume 10, Number 40

September 29, 2007: Volume 9, Number 39

September 22, 2007: Volume 9, Number 38

September 15, 2007: Volume 9, Number 37

September 8, 2007: Volume 9, Number 36

September 1, 2007: Volume 9, Number 35

The Windows Observer
Windows XP Sales Get a Reprieve

Businesses Targeted by Microsoft's New 'Online' SaaS Offering

An Update from the X64 Server Battlefields

Oracle on Windows: A Strong Combination, Ovum Says

The Unix Guardian
HP Updates HP-UX 11i v3, No Plans for X64 Port

Sun Merges Storage Back into Systems Group

BrandZ Containers, xVM Partitions to Host Legacy Solaris Applications

An Update from the X64 Server Battlefields

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

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
DRV Technologies



TABLE OF CONTENTS
Controlling System i Shutdown Activities Using an Intelligent Power-Handling Program, Part I

Programmatically Import Excel Worksheets Using IBM's ActiveX Object Library

Admin Alert: Remotely Accessing an HMC System Console, Part 2

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Crashing processes!

SQL 'Hidden' Field

What's coalesce good for?

How do I transfer output from a query to Excel?

Copying record of join logical file mutiple times





 
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