fhg
Volume 8, Number 29 -- August 13, 2008
Four Hundred Guru is taking a hiatus next week. We will resume publishing on August 27.
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

SEQUEL™ is the leading business intelligence solution for the IBM® System i™.

 

  · Executive Dashboards with Gauges for
      Critical Business Metrics
  · Graphical Query and Reporting
  · Drill-Down Data Analysis
  · Multi-Platform Database Access
  · Powerful Scripting with CL-like Programming
  · Secure Web Access

 

SEQUEL meets all your System i data access and analysis requirements.

 

Learn more now.



Serving Up Spreadsheets
by Paul Tuohy

Our users are always looking for information in different formats. They want to see it on a screen, in a report, in a PDF document, in an email, or in a spreadsheet. There are many ways of achieving all of these but most require third-party products or quite a bit of study to master a new programming technique. READ MORE >

V6R1 Enhancements for Run SQL Scripts
by Skip Marchesani

Among the many enhancements that V6R1 provided for System i and i5/OS are several for Run SQL Scripts, which improve its function and broaden its usability. Run SQL Scripts is part of the Database function in System i Navigator. READ MORE >



Sponsored By
GROUP8 SECURITY

The most effective way to improve security is by making the right business decisions--not just the right technical decisions. At the heart is the security equation: security=ƒ(cost, risk). Simply put, security is as much about business decisions (cost) as it is about mitigating risk. Technology alone cannot solve all of your problems.

 

If you're ready to take a new approach to security, learn more about Group8 and how our approach is designed to put you in control. We'll be your partner throughout the process and beyond, always there to make sure your security is the right fit for you.

 

Learn more. Call 775.852.8887 today.




Admin Alert: Common Mistakes When Failing Over to a CBU
by Joe Hertvik

My shop ran its first high availability failover test in 2007. We've since run many more tests where we configured two different System i 550 Capacity BackUp (CBU) units to impersonate other systems. We've also made many mistakes in the process. Today, I'm focusing on common CBU failover problems and how to avoid them. Hopefully, this information will help make your failover process run smoothly. 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 Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
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

looksoftware:  snap the best back-end into the coolest front-end
Computer Measurement Group:  CMG '08 International Conference, December 7-12, Las Vegas
COMMON:  Join us at the Focus 2008 workshop conference, October 5 - 8, in San Francisco, California

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
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
Why Blade Servers Still Don't Cut It, and How They Might

Power Systems Memory Prices Slashed to Promote Virtualization

Database Modernization Still Unknown Territory

As I See It: God Bless Technology

Virtualization Adoption Skyrockets on Power Systems Iron

The Linux Beacon
What the Heck Is the Midrange, Anyway?

Intel Talks Up Larrabee X64-Based Graphics Engine

IBM's Q2 Server Sales: Let's Do Some Math

As I See It: Babes in Broadband

Gartner Is Projecting a Decline in IT Hiring This Year

Four Hundred Stuff
Paperless System Brings Unexpected Benefits to Power Company

LogRhythm Partners with PowerTech to Support i OS Log Data

Profound Debuts Graphical Admin Interface for Web-Enabled Apps

Correction: WebFacing Lives On, in HIS and HATS

RJS' WebDocs Gets Google-ized

Big Iron
Unisys: Crunch for the Last of the BUNCH

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
August 2, 2008: Volume 10, Number 31

July 26, 2008: Volume 10, Number 30

July 19, 2008: Volume 10, Number 29

July 12, 2008: Volume 10, Number 28

July 5, 2008: Volume 10, Number 27

June 28, 2008: Volume 10, Number 26

The Windows Observer
What Art Thou, Midori?

Microsoft Works to Put the Clamps on 'Exploit Wednesday'

Yahoo Shareholder Meeting Anti-Climactic

Gartner Is Projecting a Decline in IT Hiring This Year

Microsoft to Buy DATAllegro for Data Warehouse Appliances

The Unix Guardian
Sun Carbon Copies Another Q4 and Fiscal Year

Q&A with IBM's Ross Mauri: Talking Power Systems and Power7

Sun Delivers AMP Stack for Solaris and Linux, Windows Coming

As I See It: Babes in Broadband

SAP Profits Under Pressure in Q2, Software Prices Get Jacked

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

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
Group8 Security



TABLE OF CONTENTS
Serving Up Spreadsheets

V6R1 Enhancements for Run SQL Scripts

Admin Alert: Common Mistakes When Failing Over to a CBU

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
IFF ACTIVE Equivalent in CL

Printer Problem

Capture Sort File and Copy to Database File

SNMP Traps on i5OS

Java Messages

Copying recs from a subfile to a file and keeping highlights





 
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