fhg
Volume 7, Number 21 -- June 6, 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


Special Files Can Do It All, Part 2
Hey, Ted:

I just wanted to tell you how much I appreciate your real world ideas and examples. They are the kinds of ideas that can really help smaller shops do the practical, bulletproof kinds of jobs we need to do. I have used your special files technique to replace some old System/36 #GSORT sales analysis programs. I know, it takes us a long time to convert, but some of these programs have not changed in 15 years. READ MORE >

Load a Spreadsheet from a DB2/400 Database
Hey, Ted:

I know from my reading that it is possible to make an Excel spreadsheet read from an iSeries database. I've been an RPG programmer for years, and I don't know where to start. Can you point me in the right direction? 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: Weird i5 User Profile Sign-On Secrets
by Joe Hertvik

i5/OS can be a little quirky when it comes to user profiles. There are little-known facets to System i profile management (some call them loopholes) that allow users to perform system sign-on tricks that are technically not allowed by the operating system. This week, I'll focus on a few i5 quirks you may not have known about and how they can affect your user sign-ons. 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

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
LASERTEC USA:  Fully integrate MICR check printing with your existing application

 

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's Rumored System i Power6 Server Plans

IBM Tries Online Discounts to Move Server, Storage Gear

The Market for Servers in Europe Is Hot

Mad Dog 21/21: Missing Inaction

The Linux Beacon
Red Hat Puts Out Fedora 7 Community Release

Novell Posts Another Loss in the Second Quarter

Microsoft-Novell Deal Has Escape Clause

As I See It: Operating on Overload

Four Hundred Stuff
Maximum Availability Shakes Up Business Plan

SEA Delivers Web and Mobile Consoles for absMessage

Aldon Boosts Identity Tracking in ALM Tool

Quadrant Bolsters FastFax with Dynamic Line Allocation

Big Iron
Virtualization, Consolidation Drive Server Sales in Q1

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
June 2, 2007: Volume 9, Number 22

May 26, 2007: Volume 9, Number 21

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

The Windows Observer
All Your IT Dollars Are Belong to Microsoft

Microsoft-Novell Deal Has Escape Clause

Virtualization, Consolidation Drive Server Sales in Q1

As I See It: Operating on Overload

The Unix Guardian
The Persistence of Unix

HP Pursues Telcos with New Entry NonStop Server

The Market for Servers in Europe Is Hot

As I See It: Operating on Overload

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

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
Guild Companies



TABLE OF CONTENTS
Special Files Can Do It All, Part 2

Load a Spreadsheet from a DB2/400 Database

Admin Alert: Weird i5 User Profile Sign-On Secrets

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Keeping a trace of each CL

Problem with "cpyfrmimpf"

FTP a library to a server

Uploading data from Excel to the iSeries

How to calculate the last day of the month





 
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