fhg
Volume 10, Number 15 -- May 12, 2010
Sponsored By
PRODATA COMPUTER SERVICES

Push-Pull-Synchronize Data TODAY!

 

Finally, a product that provides easy and full SQL access to remote databases from all System i high-level languages. Remote Database Connect gives you easy access to remote databases from your System i programs.

 

Share real time data across platforms NOW!

 

Use RDB Connect today.....
download a free trial NOW.

 

Order today and SAVE $$$!
800.228.6318

sales@prodatacomputer.com
www.prodatacomputer.com


Sponsored By
SEQUEL SOFTWARE

SEQUEL ViewPoint®--Data Access & Analysis for Power Systems™ Servers

 

 · Easy to use by IT and end users
 · Real-time data access and analysis
 · Queries, reports, pivot tables, drill-down
    analysis, kpi dashboards
 · IBM i-centric with multiplatform data access
 · Expert support and training
 · Secure data access
 · GUI, Web & green screen interface

 

SEQUEL--Fast, efficient & cost-effective data analysis

 

Click here for a FREE Information Kit!


Development Environments
by Paul Tuohy

It happens at every conference I speak at. Over a cup of coffee (or other liquid refreshment) someone will ask me about my development environment. READ MORE >

Two Ways to Prevent Division by Zero in SQL
by Ted Holt

Everybody above the age of 8 knows that division by zero is a no-no, or at least they should. Everybody who's used SQL for any amount of time knows that we can use a CASE expression to prevent division by zero. But do you know the other way to prevent division by zero in SQL? 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




Admin Alert: Diary of a Production System Upgrade, Part 2
by Joe Hertvik

Last issue, I began discussing a Power i/Power 6 upgrade that was recently completed in my shop. This review served as a case study for discussing some techniques and pitfalls in bringing up new hardware. I'm offering this examination to document some lessons I learned while upgrading in order to help other i/OS administrators who are installing new hardware. This week, let's continue the story. 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: Erwin 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

Help/Systems:  Robot/SCHEDULE Enterprise for UNIX, Linux, Windows & i
looksoftware:  RPG Open Access Webinar - May 18 at 10am (GMT) & May 19 at 2pm (EDT)
Essex Technology Group:  May 18-20: IBM POWER7 + COGNOS + VISION, NYC + PA + NJ

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.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 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
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
In Orlando, Optimism Returns

Open Access for RPG Grabs Attention at COMMON

Let's Take Another Stab at Power7 Blade Bang for the Buck

Mad Dog 21/21: Hot Deals and the Cool Server Nurseries

IBM Buys Integration Appliance Maker Cast Iron

Four Hundred Stuff
Maximum Availability Unveils New HA Monitor

Profound Brings RPG:OA-Like Features to V5R3 and V5R4

.NET App Modernization Tool Unveiled by looksoftware

NGS Makes OLAP Module Easier to Use

Raz-Lee Gets the Twitter Bug

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

System i PTF Guide
May 1, 2010: Volume 12, Number 18

April 24, 2010: Volume 12, Number 17

April 17, 2010: Volume 12, Number 16

April 10, 2010: Volume 12, Number 15

April 3, 2010: Volume 12, Number 14

March 27, 2010: Volume 12, Number 13

TPM at The Register
BI benchmark outs HP Superdome 2 details

Xsigo scales down server I/O virtualizer

US economy adds 290,000 jobs in April

Open source R in commercial Revolution

Teradata's 2010 starts with a bang

HP software lands ex-Microsoft Windows and Office chief

SGI chills new Altix ICE supers

SGI books big(ger) loss in Q3

Cray revenues slammed in Q1

Nvidia's Fermi hits flop-hungry challengers

Cloud.com takes on virty infrastructure

TPC starts designing server virt test

THIS ISSUE SPONSORED BY:

ProData Computer Services
SEQUEL Software
WorksRight Software



TABLE OF CONTENTS
Development Environments

Two Ways to Prevent Division by Zero in SQL

Admin Alert: Diary of a Production System Upgrade, Part 2

Four Hundred Guru

BACK ISSUES




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

Privacy Statement