Volume 15, Number 03 -- February 10, 2015
The next issue of Four Hundred Guru will publish on March 3.
Sponsored By

RDB Connect 4.0 - New & Improved!

RDB Connect gives developers full SQL access to remote databases from an RPG, COBOL or CL program on the IBM i.

The newest release features a menu-driven interface, improved functionality and seamless error handling. RDB Connect 4.0 is available on the ProData website and can be downloaded and used for 30 days at no charge.

Download RDB Connect 4.0 today!

Sponsored By

COMMON's 2015 Annual Meeting & Exposition is the largest gathering of the Power Systems user community, taking place April 26 - 29, 2015 at the Disneyland® Resort in Anaheim, California.

This premier event provides extensive education on Power Systems topics, including IBM i, Linux, and AIX, invaluable networking opportunities, an Exposition of nearly 80 exhibitors, and esteemed certification.

Learn more and register today: www.common.org/annualmeeting.

Create Excel Spreadsheets From DB2 Data With PHPExcel
by Bruce Guetzkow

It is amazing that so many users manually key from a report into a spreadsheet for further analysis. PHPExcel is a tool that you can use to write directly to a spreadsheet for them. Here are the steps that you need to take to install and create a simple spreadsheet from DB2 data using PHPExcel. READ MORE >

Row Value Expressions Simplify Complex Row Selection
by Ted Holt

If you like mile-long, messy, obfuscated, hard-to-read SQL, the kind that makes sane people want to cuss and spit on everybody and everything, then this tip is not for you. And please don't apply for a job in my shop. But if you have better things to do than debug SQL, then I have a simple but clever technique for you. READ MORE >

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

Git To It
by Aaron Bartell

In my last article we learned about Ruby methods and encapsulation. During the various exercises there were many code changes made and we didn't really have a simple way to keep track of how the code changed from one version to the next. That's where source change management (SCM) tools like git come into play and is what we will be diving into today. 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

Northeast User Groups Conference:  25th Annual Conference, March 30 - April 1, Framingham, MA
Profound Logic Software:  Reach Your Modernization Goals. Register for the February 25 Webinar now!
System i Developer:  Upgrade your skills at the RPG & DB2 Summit in Dallas, March 17-19


The Four Hundred
Surrounding The IBM i

German Hotel Search Engine Mashes Up Watson And IBM i

Security Risks Avoided By The Development Team

IBM's Licensing Practices Under Scrutiny

IBM Layoffs Not As Dramatic As Rumored

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

System i PTF Guide
February 7, 2015: Volume 17, Number 06

January 31, 2015: Volume 17, Number 05

January 24, 2015: Volume 17, Number 04

January 17, 2015: Volume 17, Number 03

January 10, 2015: Volume 17, Number 02

January 3, 2015: Volume 17, Number 01

TPM at EnterpriseTech
Lenovo Aims High For Systems Expansion

Facebook Opens Up OS Query Tool

Critical Apps In The Cloud And High Availability

OpenPower Systems Coming In Mid-2015

Mesosphere Wants To Run Clusters At The Global 2000

ThunderX ARM Has Datacenter Muscle

Docker Goes Enterprise As Rocket Containers Launch

Hyperscale Users, Upstart Sellers Drive Server Growth In Q3

HP Goes Hybrid With 3PAR, Adds File Persona

HP's Itanium Odyssey Ends With Superdome X Xeon Iron

Dow Seeks Chemistry Between Clusters And Cloud

Steel Mill Transformed Into Juiced Datacenter


ProData Computer Services
WorksRight Software

Create Excel Spreadsheets From DB2 Data With PHPExcel

Row Value Expressions Simplify Complex Row Selection

Git To It

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

Privacy Statement