fhg
Volume 7, Number 25 -- July 11, 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

SEQUEL can be used for
virtually ALL business intelligence functions
on the System i, including:

 

            · Executive Dashboards
            · Graphical Query & Reporting
            · Drill-Down Data Analysis
            · Multi-Platform Database Support
            · E-Mail Report and File Distribution
            · Secure Web Access

 

SEQUEL is the single solution for all
your business intelligence needs.

 

www.helpsystems.com


Comment Your Binder Language
Hey, Ted:

Because of Sarbanes-Oxley, we have a new requirement in our shop that all source members must include comments that tell the usual stuff--who did what, when and why they did it, etc. While we have always done that sort of thing (well, most of the time), there are certain types of source members we never bothered to comment. A good example is ILE binder language. I've looked for, but never found, a document that tells how to comment binder language. Do you know? READ MORE >

Load a Spreadsheet from a DB2/400 Database: Part 2
by Michael Sansoterra

Ted Holt's tip on loading database data into Excel was great. I'd like to offer a few potential enhancements to the VBA code that was offered in the tip. READ MORE >



Sponsored By
COMMON

COMMON Focus 2007 will be our first annual workshop conference event, featuring three days of intense, focused education. It will be held October 14 - October 17, 2007 in Columbus, Ohio.

 

This smaller, more intimate event will feature 15 in-depth, all-day workshops in both lab and lecture-style formats, offering a wide range of topics, and will also include a tabletop-style exhibition area.

 

Learn more at www.common.org/focus




Admin Alert: More Info on SAVSYSINF, Green-Screen Printing, Performance PTFs, and Batteries
by Joe Hertvik

When writing a weekly column like Admin Alert, mistakes can inadvertently sneak into the final copy. Fortunately, I have alert readers (pun intended) who correct me on any errors that I may have made, providing me with additional information on many topics in the process. So in the spirit of setting the record straight, here are some reader-provided corrections and additions to material that I published in earlier columns. 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

Bsafe:  Enterprise security for System i and Linux systems
New Generation Software:  Leading provider of iSeries BI and financial management software COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee

 

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
Small Form Factor Disks Go Mainstream, the System i Has Gone Fishin'

Project Costs Tell the VoIP Story

IBM to Break Petaflops Barrier with Blue Gene/P

As I See It: The All-American Exhausting Vacation

The Linux Beacon
Red Hat Starts Fiscal 2008 with Modest Profit, Big Revenue Growth

Top 500 Supers: Moore's Law Is Alive and Well

IBM to Break Petaflops Barrier with Blue Gene/P

As I See It: The All-American Exhausting Vacation

Four Hundred Stuff
InfoManager Provides Another Option for System i OLAP

Robot/LPAR Streamlines Tape Backups of Partitioned i5/OS Servers

ROBObak Delivers Online Backups for Remote Offices

Lotus Quickr Now Available from IBM

Big Iron
For Some Users, Multiprise and VSE May Have a Bright Past Ahead

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
July 7, 2007: Volume 9, Number 27

June 30, 2007: Volume 9, Number 26

June 23, 2007: Volume 9, Number 25

June 16, 2007: Volume 9, Number 24

June 9, 2007: Volume 9, Number 23

June 2, 2007: Volume 9, Number 22

The Windows Observer
Microsoft Back on the Top 500 List of Biggest HPC Systems

Is Windows Vista Really More Secure Than Linux or OS X?

Mandriva, Ubuntu Not Interested in Microsoft Deals

Microsoft Concedes to Google, Will Scale Back Search with Vista SP1

The Unix Guardian
Sun Gets Serious (Finally) About Supercomputing

Top 500 Supers: Moore's Law Is Alive and Well

HP Promotes Transitive Tool to Port Solaris Apps to Integrity Servers

As I See It: Dare to Be Rich

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

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
COMMON



TABLE OF CONTENTS
Comment Your Binder Language

Load a Spreadsheet from a DB2/400 Database: Part 2

Admin Alert: More Info on SAVSYSINF, Green-Screen Printing, Performance PTFs, and Batteries

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Urgent Help Needed--Limit the result Set in SQL Stored Proc

FNDSTRPDM Output Member Name to *OUTFILE

Stuck in the Dark Ages

Referencing the key of current record

Brother HL 6050 printing '$' instead of '£' symbol





 
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