fhg
Volume 11, Number 8 -- March 2, 2011
Four Hundred Guru is taking a hiatus next week. We will resume publishing on March 16.
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
SEQUEL SOFTWARE


Need in-depth data access and analysis, but your budget is a little thin?
Try SEQUEL.

 

SEQUEL uses ad hoc queries, dashboards,
drill-down capabilities, and cross-platform database access to deliver data quickly,
at a price you can afford.

 

Join us Wednesday, March 9 for a FREE Webinar: SEQUEL on a Shoestring Budget.

 

Follow this link for more info!



Running Totals in an SQL Query
by Skip Marchesani

There are situations when running an SQL query for data analysis where I like to generate a running total based on a column in the table that is the target of the query, to assist with the data analysis. READ MORE >

Odds and Ends: The Reader is the Guru
Dear Professional:

The emails I get from you provide a sterling illustration that the readers of this august publication are the true gurus in the world of IBM i. Here are a few contributions that I hope may prove useful to some of you. READ MORE >



Sponsored By
NORTHEAST USER GROUPS CONFERENCE

21th Annual Northeast IBM i
User Groups Conference
April 11 - 13, Framingham, MA

 

i Can Do Anything!
Super Charge Developer Productivity
Enhance Professional Development
Empower User Data Access
Secure Your System

 

80+ sessions; NEW topics for 2011; top industry speakers;
in-depth labs & workshops

 

Register before March 20 and save!
$700 includes Monday lab

 

View Conference Brochure

 

www.neugc.org




Admin Alert: Corralling i/OS Storage Hogs, Part 1
by Joe Hertvik

Last year, I wrote an article on finding and expelling i/OS storage hogs. Since then, I've pinpointed some other items that illustrate how Power i system storage fills up unnecessarily, leaving you contemplating buying additional disk drives when all you really need is a good housecleaning. This week and next, I'll expand on my storage hog list to help you keep your storage problems under control. 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

System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Orlando, March 22-24
Townsend Security:  Learn how to easily and securely communicate with XML
Northeast User Groups Conference:  21th Annual Conference, April 11 - 13, Framingham, MA

 

 

IT Jungle Store Top Book Picks

BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

The iSeries Express Web Implementer's Guide: List Price, $49.95
The iSeries Pocket Database Guide: List Price, $59
The iSeries Pocket SQL Guide: List Price, $59
The iSeries Pocket WebFacing Primer: List Price, $39
Migrating to WebSphere Express for iSeries: List Price, $49
Getting Started with WebSphere Express for iSeries: List Price, $49
The All-Everything Operating System: List Price, $35
The Best Joomla! Tutorial Ever!: List Price, $19.95


 
The Four Hundred
LUG Issues Call to iASP Arms for ISVs

Mainframes Put IBM Back on Top for Servers in Q4

Social Business Ushering Changes in Content Management

Mad Dog 21/21: Talking Toklas

IT Spending Better Than Expected Last Year, And 2011 Looking Up

Four Hundred Stuff
BIRT Makes Open Source Waves in BI World

IBM i Vendors: It's Time to Rally

Raz-Lee Feeds IBM i Data into RSA SIEM

Sirius Claims Third Consecutive Beacon Award, Notes IBM i Trends

PowerTech Adds Innovatum's Monitoring Tool to Product Mix

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

System i PTF Guide
September 25, 2010: Volume 12, Number 39

September 18, 2010: Volume 12, Number 38

September 11, 2010: Volume 12, Number 37

September 4, 2010: Volume 12, Number 36

August 28, 2010: Volume 12, Number 35

August 21, 2010: Volume 12, Number 34

TPM at The Register
Nvidia revs up CUDA GPU coder toolkit

SeaMicro drops 64-bit Atom bomb server

Godson: China shuns US silicon with faux x86 superchip

Amazon automates AWS app deployment

IBM reclaims server crown from HP

Intel outs future Xeon chip porn

AMD's Bulldozer cores to push to 3.5 GHz and beyond

SGI lays off 4 per cent of workforce

Doing the math on IBM's real systems biz

HP misses Q1 sales, revises 2011 downward

Acer launches server biz in the US

Ethernet, Fibre Channel sales boom in Q4

THIS ISSUE SPONSORED BY:

WorksRight Software
SEQUEL Software
Northeast User Groups Conference



TABLE OF CONTENTS
Running Totals in an SQL Query

Odds and Ends: The Reader is the Guru

Admin Alert: Corralling i/OS Storage Hogs, Part 1

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

Privacy Statement