fhg
Volume 7, Number 43 -- December 12, 2007
Four Hundred Guru is going on holiday and will resume publishing on January 9.
Sponsored By
HELP/SYSTEMS

Discover Robot/SECURITY, the i5/OS security monitoring and auditing software, from Help/Systems

 

                    · Profile Exchange
                    · Exit Point Monitoring
                    · System Authority Auditing
                    · QAUDJRN Monitoring
                    · System Security Analysis

 

Robot/SECURITY is the only security software that combines five critical System i security tools in one package.

 

Visit our Web site at http://www.helpsystems.com/400g-sec/
to learn more about Robot/SECURITY.


Sponsored By
PRODATA COMPUTER SERVICES

Push-Pull-Synchronize Data TODAY!

 

RDB Connect gives you easy access to remote databases from your System i programs.

 

Share real time data across platforms NOW!

 

Use Remote Database Connect today.....download a free trial today.

 

Order today and SAVE $$$!

 

800.228.6318

 

sales@prodatacomputer.com

 

www.prodatacomputer.com


Use SQL User-Defined Functions to Avoid Data Repetition Problems
by Michael Sansoterra

By now, most System i and AS/400 developers know they can enhance the SQL language in DB2 for i5/OS by creating their own user-defined functions (UDFs). In this tip I'd like to focus on one common problem encountered when writing queries and how a simple UDF template can often solve this problem. READ MORE >

Stuff I Didn't Publish This Year
by Ted Holt

My wife and I recently visited our local Cracker Barrel, which is one of our favorite restaurants. While we were waiting for our food, I picked up the peg game that unfailingly occupies patrons at the tables of that establishment and, for the umpteenth time, failed to solve it. READ MORE >



Sponsored By
DRV TECHNOLOGIES

How Much Time Would You Save Automatically Converting and Distributing Your AS/400 Reports?

 

SpoolFlex automatically converts spooled files to PDF and Excel, E-mails from your AS/400, and saves copies to your network server. Search, view and re-send original reports without generating them again. Start saving time today!

 

Visit www.drvtech.com or
call 866 378-3366 for a demonstration.

 

Download your FREE Trial




Admin Alert: Getting Started with Trial Capacity on Demand, Part 2
by Joe Hertvik

In Part 1 of this article, Getting Started with Trial Capacity on Demand, Part 1, I described how I recently approached the decision to activate additional trial processors on a client's System i 550 box. This week I'm completing the process by reviewing the activation process steps and the various published and unpublished steps you need to take to add temporary processing power to your 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

looksoftware:  Present your core System i applications in Outlook, Google and Notes
COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

 

 

IT Jungle Store Top Book Picks

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
Database Tool Maker Joins the System i Market

State of the System i: Other Software Makers Weigh In

IDC Says Server Buyers Weigh Economy and Power in Q3

As I See It: What's Past Is Prologue

The Linux Beacon
AMD Stalled by a Bug in Barcelona Opterons

Red Hat Goes Grid and Real Time with Enterprise MRG Distro

IDC Says Server Buyers Weigh Economy and Power in Q3

As I See It: What's Past Is Prologue

Four Hundred Stuff
Above Security Takes i5/OS Log Aggregation to Heart

Shield's Remote Journal-Based DR Solution Matures at V2R1

Putting the 'i' Back Into PCI

Pat Townsend and BalaBit Pair Up to Cover System i Logs

Big Iron
Sine Nomine Shows Off Solaris on System z

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
December 8, 2007: Volume 9, Number 49

December 1, 2007: Volume 9, Number 48

November 24, 2007: Volume 9, Number 47

November 17, 2007: Volume 9, Number 46

November 10, 2007: Volume 9, Number 45

November 3, 2007: Volume 9, Number 44

The Windows Observer
Windows Anti-Piracy Program Gets Stronger, Weaker with Vista SP1

Exchange Server 2007 SP1 Goes RTM

SAP-Microsoft Mega-Merger Rumor Surfaces, Then Dies

Be My Guest

The Unix Guardian
Sine Nomine Shows Off Solaris on System z

Q&A with Jim Herring: The View from the Top

Sun to Release xVM Virtualization Under GPL v3 License

Be My Guest

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

THIS ISSUE SPONSORED BY:

Help/Systems
ProData Computer Services
DRV Technologies



TABLE OF CONTENTS
Use SQL User-Defined Functions to Avoid Data Repetition Problems

Stuff I Didn't Publish This Year

Admin Alert: Getting Started with Trial Capacity on Demand, Part 2

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Choose Logical File Format with SQL

IBM 6400 on LPT1 prints junk

Reallocate disk space from one LPAR to another

How to retrieve a workstation ID

Finding *OUTFILE Template Files





 
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