Volume 13, Number 22 -- November 20, 2013
The next issue of Four Hundred Guru will publish on December 4.
Sponsored By

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

You've Got Mail!


Convert Spool File to Email (Splf2EML) allows you to convert your simple spooled output to a PDF file and automatically email it to a list of up to 15 recipients.


Pick one spool file or multiple spool files to be merged into one PDF document.


Contact us today at sales@prodatacomputer.com for pricing and to get your copy of Splf2EML!



Allow Repeated Change With SQL Triggers
by Paul Tuohy

In my previous article, I described how an RPG program as a before trigger, could be used to synchronize two columns in a table. There is an alternative. Instead of using an RPG trigger, we could have used an SQL trigger. An SQL trigger allows us to be more specific about when the trigger is activated and also has the advantage of portability to other database management systems. READ MORE >

Alan's Easy Method For Building A CSV File From A Report
by Ted Holt

I love simple solutions to common problems, and boy, have I got a good one for you today! Clever and faithful reader Alan Urtubia recently told me how he turned a report into a CSV file and I was impressed. Alan kindly allowed me to pass this tip along to you. READ MORE >

Sponsored By

ASNA Mobile RPG®


Mobile RPG brings mobile programming
to your RPG team-targeting
smartphones and tablets
with plain ol' RPG programs.
There is nothing else to learn! RPG does it all.


Learn more about
ASNA Mobile RPG® at our

Free Webcast Thu, Nov 21, 1pm CST or at

Minimizing IPL Surprises With The IPL Startup Kit
by Joe Hertvik

Unlike a Windows server that can be rebooted several times a year, an IBM i machine is so reliable that it can run for a year or more without being IPLed. But infrequent IPLs can cause their own problems, as functions that should be restarted after an IPL may not necessarily actually restart after an IPL. That's where it comes in handy to have an IPL startup kit available. 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

Abacus Solutions:  IBM i Performance Assessment. Upgrade with Confidence!
Shield Advanced Solutions:  HA4i ~ High Availablity for the IBM i. FREE 30-day trial
ASNA:  RPG Goes Mobile! Free Webcast! Thursday, November 21.



More IT Jungle Resources:

System i PTF Guide: Weekly PTF Updates
IBM i Events Calendar: National Conferences, Local Events, and Webinars
Breaking News: News Hot Off The Press
TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

The Four Hundred
Power8 Offers Big Blue And IBM i A Clean Slate

IBM i Developers Sound Off On JavaScript Frameworks

The Risk Of Doing Nothing With Modern RPG And DB2

As I See It: Permissionless Neutrality

In The Shadow Of Database Hype

Four Hundred Stuff
Hey iDoctor, Can i Get a Walker?

Free Format RPG Is Here with TR7, Context Checking Still to Come

BCD Bolsters Nexus Portal with Authentication and CMS Functions

Go Ahead And Test It, Midrange Dynamics Says

ExaGrid Unveils New High-End Backup Appliance

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

System i PTF Guide
November 16, 2013: Volume 15, Number 46

November 9, 2013: Volume 15, Number 45

November 2, 2013: Volume 15, Number 44

October 19, 2013: Volume 15, Number 42

October 12, 2013: Volume 15, Number 41

October 5, 2013: Volume 15, Number 40

TPM at EnterpriseTech
Microsoft to Drive RDMA Into Datacenters and Clouds

IBM Embraces Nvidia GPUs for Acceleration

Hedge Fund Scraps DIY Lustre Cluster for Terascala

Fujitsu Demos Silicon Photonics Server Links

Cisco Converged System Sales Still Booming

Fat and Fast C3 Server Slices Unveiled for AWS Cloud

Amazon SVP Says Outlook for Enterprise Datacenters Is Cloudy

Prototype Open Compute Switches Revealed

Regional Datacenter Bracing for 40GbE Demand

Rackspace Profits Squeezed by Cloud Competition

Invisible OpenCL and APU Chips Drive Acceleration

Nokia Dev Cloud Will Swell to 100K Cores


WorksRight Software
ProData Computer Services

Allow Repeated Change With SQL Triggers

Alan's Easy Method For Building A CSV File From A Report

Minimizing IPL Surprises With The IPL Startup Kit

Four Hundred Guru


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

Privacy Statement