fhg
Volume 7, Number 4 -- January 31, 2007
Sponsored By
PROFOUND LOGIC SOFTWARE

RPGsp - The Best of Both Worlds
The most comprehensive iSeries Web Development Environment for both building new Web apps and converting green-screens.

 

That's right! Use RPGsp to instantly convert any existing RPG/CL programs to a great-looking CGI application.

 

Or point RPGsp to your database files and instantly build new Inquiries, Drill-downs, File Maintenances, and other types of new Web applications.

 

Click here to download RPGsp.
Click to see videos of RPGsp in action!

Call 1-877-224-7768 or visit www.RPGsp.com


Sponsored By
IBS


Simplify the business of doing business

 

IBS INTEGRATOR opens up a world of
business possibilities. It's an IT solution that
can connect your company with
information from anywhere, in any format,
from legacy systems to new
business partners across the globe.

 

· More than 250 powerful functions and features.
· Supply chain integration with flexibility.
· Powerful integration for all businesses.

 

Visit www.ibsus.com to learn more!



Finding the Last Transaction for a Customer
Hey, Howard:

I've been studying your book, SQL at Work. I was hoping you would answer a question for me. We have a historical transaction file sorted on a descending date field. I'd like to only select the latest record for a specific ID with the most current date. I don't know the value of this date and I don't want it to return any other records. Is this possible? Thanks! READ MORE >

Sorting Arrays and Subfiles with a User Index
Hey, Ted:

I'd like to suggest another method Jennifer can use for sorting arrays. Why not use a user index? I use user indexes so the user may sort subfiles umpteen different ways. Using a user index eliminates the need to be concerned with size (unless you have more than 4 GB of data). Maybe size would not be an issue in Jennifer's daily run shipping application. READ MORE >



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




When Fix Central Won't Let You Download PTFs
Hey, Joe:

When I went to IBM's Fix Central Web site to download some i5 PTFs, the site wouldn't let me complete my order after I entered my contact and shipping information. Fix Central wouldn't let me advance past the contact screen, and I couldn't download the PTFs I wanted. Is there something wrong with my browser settings or do I need to adjust something else on my system? 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 2007 conference, April 29 – May 3, in Anaheim, California
New Generation Software:  Leading provider of iSeries BI and financial management software
Twin Data:  System console control for AS/400s and LPARs from a LAN, WAN, VPN, or via Internet

 

Books on Sale at the IT Jungle Store: 30 Percent Off for 30 Days

The System i Pocket RPG & RPG IV Guide: List Price, $69.95; Sale Price, $49.00
The iSeries Pocket Database Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket Developers' Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket SQL Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket Query Guide: List Price, $49.00; Sale Price, $34.00
The iSeries Pocket WebFacing Primer: List Price, $39.00; Sale Price, $27.00
Migrating to WebSphere Express for iSeries: List Price, $49.00; Sale Price, $34.00
iSeries Express Web Implementer's Guide: List Price, $59.00; Sale Price, $41.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95; Sale Price, $56.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00; Sale Price, $62.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00; Sale Price, $34.00
WebFacing Application Design and Development Guide: List Price, $55.00; Sale Price, $38.00
Can the AS/400 Survive IBM?: List Price, $49.00; Sale Price, $34.00
The All-Everything Machine: List Price, $29.95; Sale Price, $21.00
Chip Wars: List Price, $29.95; Sale Price, $21.00

 

The Four Hundred
The Vanishing IT Woman--System i Women Respond

IBM Sells Printing Division to Ricoh for $725 Million

IT Salaries Rise by 5.2 in 2006, Dice Survey Says

As I See It: Measuring What Counts

The Linux Beacon
Novell Says SLED Is Better Than Windows Vista

AMD: Native Quad Core Opteron Will Best Intel Quasi Quads

IT Salaries Rise by 5.2 in 2006, Dice Survey Says

Ask TPM: The Economics of Open Source Software

Four Hundred Stuff
Idiom Translates Globalization Software into Strong Growth

PowerTech Looks to OpenService for Cross-Platform Security

Notes-Domino 8 Beta On Deck, Mid-Year GA Still on Schedule

mrc Hits the Throttle with Development Tools

Big Iron
IBM Buys Softek to Bolster Data Migration Offerings

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
January 27, 2007: Volume 9, Number 4

January 20, 2007: Volume 9, Number 3

January 13, 2007: Volume 9, Number 2

January 6, 2007: Volume 9, Number 1

December 30, 2006: Volume 8, Number 50

December 23, 2006: Volume 8, Number 49

The Windows Observer
Microsoft Keeps the Pressure on IBM's Notes, Domino

IBM Lotus Adds Handles to Information Overload

Symantec Expands Performance Management Software

Salesforce.com Reports AppExchange Milestone

The Unix Guardian
Sun Profits in Fiscal Q2, Gets $700 Million Equity Injection from KKR

Sun, Intel Form Alliance for Xeon Servers and Workstations

IBM Closes Out 2006 With a Strong Fourth Quarter

The X Factor: Solaris Versus Linux Support Pricing

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

THIS ISSUE SPONSORED BY:

Profound Logic Software
IBS
WorksRight Software



TABLE OF CONTENTS
Finding the Last Transaction for a Customer

Sorting Arrays and Subfiles with a User Index

When Fix Central Won't Let You Download PTFs

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Populate fields with file

Alert emails from iSeries

READC SUBFILE

CL Question on Overrides

Self referencing trigger





 
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