fhg
Volume 9, Number 5 -- February 4, 2009
Four Hundred Guru is taking a hiatus next week. We will resume publishing on February 18.
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
     IBM® System i® Data Access Made Easy

 


  · Complete management access to critical data
  · Easy to use by IT and end users
  · Automated data access and display
  · Comprehensive BI package: reports, tables,
     key performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Expert support and training

 


Click here for a FREE Information Kit!



A Bevy of BIFs: Look Up to %LookUp
by Susan Gantner

The %LookUp built-in function is more than just a simple replacement for the LOOKUP operation code to allow use in /Free format logic. It offers the option of supercharging the performance of an array search operation. READ MORE >

Treasury Of New DB2 6.1 Features, Part 1: Query Enhancements
by Michael Sansoterra

Once again I am happy to report that IBM has provided us with a wealth of enhancements to DB2 in this monumental V6R1 release. Incidentally, in case you haven't heard, IBM is now calling our favorite database by the name DB2 for i (formerly known as DB2/400 and DB2 UDB for iSeries) and our favorite OS is called IBM i version 6.1. Now without further ado, I'll start to rattle off some query enhancements offered in this release. READ MORE >



Sponsored By
SYSTEM i DEVELOPER

Take it to the Summit!

 

Come to the RPG & DB2 Summit in Orlando, April 15-17, for three full days of intense education focused on RPG IV, SQL, DB2, ILE, V6R1, RSE/WDSC/RDi, the Web & more.

 

Learn the latest in practical, usable tips and techniques from top gurus Susan Gantner, Skip Marchesani, Jon Paris, Paul Tuohy, Scott Klement and others in a highly interactive, fun, invigorating environment. You'll leave the Summit re-energized and eager to use all your new skills and ideas.

 

Register today and save up to $400!
$995 registration ends February 20.




Admin Alert: Time Gobbling Tasks for a System Upgrade
by Joe Hertvik

Last week, I discussed four critical things to beware of during an i5/OS system upgrade. This week, let's look at a fifth critical item: upgrade time. I'll examine a few necessary and optional procedures that can add extra time to your upgrade process, and I'll explain the benefits that each procedure can bring you. 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

PowerTech:  Ensure your IBM i data is secure. Join a complimentary Webinar now!
Vision Solutions:  Journaling for System i resilience. Learn more.
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada

 

 

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
Hogging the Ground Day

IBM Sunsets i5/OS V5R4, Kills Older 595 Iron

MaxAva Gets Inventive With Subscription Model for HA

IBM Rejiggers Power Systems, System i and p Prices

Deconstructing and Rebuilding IBM's Q4 Server Sales

Four Hundred Stuff
i OS Vendors Take Different Approaches to Poor Economy

RPG Gets Mixed Up in EGL Jam

Vault400 Debuts Tiered DR and Managed HA Services

Zend's PHP to be Preloaded Onto IBM i OS

Bring Your IT Ideas to Life, mrc Says

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

System i PTF Guide
January 31, 2009: Volume 11, Number 5

January 24, 2009: Volume 11, Number 4

January 17, 2009: Volume 11, Number 3

January 10, 2009: Volume 11, Number 2

January 3, 2009: Volume 11, Number 1

December 27, 2008: Volume 10, Number 52

TPM at The Register
Sun taps ex-Merrill, ex-Fannie Mae exec for board

Intel to spill Nehalem secrets

Novell cuts 1000 100 workers

Ex-IntelCrayAkamai startup rejiggers virtualization

T3 girds loins for IBM legal fight

HP gives SMBs zero per cent financing

Citrix ejects 10 per cent of staff

US House OKs Obama's IT stimulus

Exploding core counts: Heading for the buffers

GeoCluster - Windows from here to Timbuktu

Sun will Rock in 2009

Big Sparc crunches Sun's Q2

Sun goes eco-friendly with data center compression

IBM whittles x64 iron prices

THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
System i Developer



TABLE OF CONTENTS
A Bevy of BIFs: Look Up to %LookUp

Treasury Of New DB2 6.1 Features, Part 1: Query Enhancements

Admin Alert: Time Gobbling Tasks for a System Upgrade

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Insert via Java

iSeries Access for Web

Mimix installation and configuration docs

EDI Inovis Programmer - Heavy Duty Problem Solver - Anytime

Data Queues vs. MQ Series: Performance

Removing blanks from a CL Variable

XML




 
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-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement