Volume 15, Number 06 -- March 31, 2015
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

Exclusive IBM i Data from Users Around the World

In the first IBM i Marketplace Survey, 350 IT professionals revealed how organizations large and small use IBM i and the IT issues that concern them the most.

Find out how many organizations plan to stay on the platform, which IT projects top their to-do lists, and what this means for the future of IBM i.

Download your copy of the survey results >

Handling Constraints Revisited
by Paul Tuohy

I recently had an email from Doug, who was making use of some code I had published way back in February 2010 in my article Handling Constraint Violations in RPG. The article discussed how to trap a constraint violation caused by a WRITE/UPDATE/DELETE operation and, more importantly, how to determine the name of the constraint that caused the violation. READ MORE >

Dynamic Lists In Static SQL Queries
by Ted Holt

We have an SQL query that can take from one to 13 two-byte codes that become part of an IN clause for row selection. We have no idea which codes they will need to see beforehand; it's an interactive thing. We are using dynamic SQL. I would like to find a static solution. Any suggestions? READ MORE >

Sponsored By

IBM i: Intro to Tapeless Backups
Gaining faster, easier backups
without tape

Ever wondered how tapeless backup works?

Join us Thursday, April 9th at 2pm EST, 1 PM CST.

In this live webinar learn about using tapeless backup instead of tape for iSeries to improve backups without disrupting operations.

If you currently use tape backups, you should sign-up.

Register now >


RubyGems Are The Foundation Of Success
by Aaron Bartell

In my previous article, I discussed a RubyGem named xmlservice but didn't really dive into what Gems are, why they exist, and how we can use them to save a tremendous amount of time. That's what this article is about. But before we dive into geekdom, it is worth digressing into a perspective I've gained by observing the top open-source-language camps. 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

LaserVault:  Webinar - IBM i: Intro to Tapeless Backups. April 9
Chrono-Logic:  Deploy automatically to multiple IBM i and Windows servers with a single click!!
COMMON:  2015 Annual Meeting & Expo, April 26 - 29, at the Disneyland® Resort in Anaheim, California


The Four Hundred
OpenPower Could Take IBM i To Hyperscale And Beyond

IBM i Skills Shortage: Now You See It, Now You Don't

Tributary Flashes Backup To 60 TB Per Hour

Mad Dog 21/21: The Innovators' Droll Lemma

Reader Feedback On What's Up In The IBM i Marketplace . . . Don't Miss the IBM i Marketplace Webcast . . . COMMON Is Coming, Linux and VIOS Get Top Billing

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

System i PTF Guide
March 28, 2015: Volume 17, Number 13

March 21, 2015: Volume 17, Number 12

March 14, 2015: Volume 17, Number 11

March 7, 2015: Volume 17, Number 10

February 28, 2015: Volume 17, Number 09

February 21, 2015: Volume 17, Number 08

The Platform
Rockets Shake And Rattle, So SpaceX Rolls Homegrown CFD

Where Will Future Xeon Phi Chips Land?

Benchmarking a Burst Buffer in the Wild

Optical Processors Bring Light Touch to Genomics

More Knights Landing Xeon Phi Secrets Unveiled

FPGA Market Floats Future on the Cloud

Embedded dCache Proven at CERN Scale

Cray Details New Five Petaflop Oil and Gas Supercomputer

Inside The Rackspace OpenPower Megaserver

HPC Schedulers Snap to Docker

OpenPower Collective Opens For System Business

HPC Scales Out of Balance With CPU-Heavy Thinking


WorksRight Software

Handling Constraints Revisited

Dynamic Lists In Static SQL Queries

RubyGems Are The Foundation Of Success

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