fhg
Volume 10, Number 17 -- May 26, 2010
Four Hundred Guru is taking a hiatus next week. We will resume publishing on June 9.
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

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!


Five Steps To Monitoring Your Server Log on IBM i
by Pi Guang Ming

In today's Web application environment, notices and error messages that appear in a Web server's logging files can be easily lost or missed. This exposes you to missing important information that you may need to know. READ MORE >

Distinctly Speeding Up DISTINCT
by Ted Holt

The DISTINCT keyword is a great example of the power of the SQL SELECT statement. Add this powerful word to any SELECT command and voilą! Duplicate rows magically disappear. Comments from readers have alerted me to the fact that some people find use of this feature confusing. Here are a brief discussion of DISTINCT and a performance tip. READ MORE >



Sponsored By
BOTZ & ASSOCIATES, INC.

~ ASK PAT ~
Free Security Advice from Patrick Botz

 

Need advice you can trust on security audits, PCI, HIPAA or SOX requirements, 3rd party software, rational password management, public authority or Security Level 40?

 

Spend an hour with Patrick Botz - FREE - and get actionable info and tips to get you started. Custom, 100% independent advice from the guy who helped architect Power Systems / IBM i security.

 

Click to set up your free session with Pat. World-class security expertise is no longer just for the big guys!




Hey! What Happened To My Last Used Dates
Hey, Joe:

After we upgraded our production system to new Power i hardware, the Last used date on all our system objects was reset to zeros. While this isn't a major problem, it does mean that we are no longer able to identify obsolete objects and files on our system. If we can't identify them, then we can't remove them. Is there any way to get this information back? 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

IBS:  Free e-book: The Six Margin Killers in Wholesale Distribution
WorksRight Software:  ZIP codes, area codes, Canadian postal codes, CASS certification, and more
COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas

 

 

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
Power7 Blades Plus i Versus X64 Blades Plus Windows

Transitions Push Systems and Technology Group into the Red

AS/400 LUG Shares Chief i Architect's "Why i?" Arguments

Creativity Is the New Business Kool-Aid, IBM CEO Study Finds

IBM Emphasizes 'Deeper Skills' in New Business Partner Program

Four Hundred Stuff
Security and Auditing Breakthrough Gives Cilasoft Compliance Advantage

DBU Now Accessible Over the Web

PowerTech Delivers Object-Based Control Over Exit Points

IBM Considers Offering Trials of RPG OA

Databorough Targets CA 2E Apps for Migration

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

System i PTF Guide
May 22, 2010: Volume 12, Number 21

May 15, 2010: Volume 12, Number 20

May 8, 2010: Volume 12, Number 19

May 1, 2010: Volume 12, Number 18

April 24, 2010: Volume 12, Number 17

April 17, 2010: Volume 12, Number 16

TPM at The Register
Cray-1 resurfaces in pieces on eBay

Novell puts Identity Management into beta

BMC reveals 'free money' mainframe and DB2 tools

Oracle shows off M9000s for data warehousing

Server rebound, Perot services boost Dell

NOAA goes to Cray for climate super

Cisco shells out $99m for CoreOptics

Oracle punts first VirtualBox x64 hypervisor

Novell seeks rich suitors

Oracle sneaks out carrier grade Sparc blade, Xeon rack

SUSE Linux 11 gets first service pack

IBM punts commercial Hadoop distro

THIS ISSUE SPONSORED BY:

WorksRight Software
SEQUEL Software
Botz & Associates, Inc.



TABLE OF CONTENTS
Five Steps To Monitoring Your Server Log on IBM i

Distinctly Speeding Up DISTINCT

Hey! What Happened To My Last Used Dates

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