Volume 16, Number 03 -- February 9, 2016
Sponsored By

RSF-HA Keeps You Going While it Saves You a Bundle


· Replicate your entire system for High Availability.
· Easy to set up. Easy to monitor.
· Full role swap support.
· Mirror libraries, IFS directories, user profiles, configuration changes, spooled files and more!


· All this, at a price that will make you smile.


Bug Busters has been providing quality software solutions for the iSeries and AS/400 since 1988.


Download a Free Thirty-Day Trial:

Sponsored By

ProData Software Suite

ProData software gives developers and super users secure access to data regardless of where that data is housed.

DBU, RDB Connect and SQL/Pro provide the functions to zero in on the data YOU need NOW.

Download today!

IBM i and .Net Connectivity With XMLSERVICE
by Richard Schoen

Many businesses are looking for ways to modernize their IBM i applications while maximizing their existing code investments in RPG or COBOL applications. Some contend that using Microsoft development technologies is a bad way to go. They think it promotes replacement of existing IBM i applications or of IBM i itself. READ MORE >

Use SQL To Change A Substring
by Ted Holt

Occasionally I need to change part of a string value in a database table. SQL has three mechanisms that let me accomplish such a thing. Do you know what those three mechanisms are and how to use them? 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

Parsing Delimited Text Data Natively In SQL, Part 2: Java To The Rescue
by Michael Sansoterra

In Part 1 of this series, I introduced ParseFileContent, a 100 percent SQL user-defined table function (UDTF) that can parse delimited text (as a CLOB or IFS file) and format the results as rows and columns. As an advantage over tools like CPYFRMIMPF, this UDTF can streamline a text based import process by allowing CASTs, JOINs, and data integrity checks to be done while the import is running. As useful as ParseFileContent is, it does suffer a few drawbacks. 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
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

COMMON:  2016 Annual Meeting & Expo, May 15 - 18, in New Orleans! Great Power Systems event!
System i Developer:  RPG & DB2 Summit - March 22-24 in Dallas. Register by Feb 12 and save $300!
BCD:  IBM i eBook: Top 10 Reasons to Choose PHP. Download now »


The Four Hundred
Where's MKS Implementer? Alive and Well At PTC

The Jobs Of The People Who Make IBM i Platforms Work

From Green Screens To Web Services: An ROI Story

App Dev Evolution Opens Doors For Midrange Dynamics

IBM Patches OpenSSH Security Flaws That Impact IBM i

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

System i PTF Guide
January 30, 2016: Volume 18, Number 5

January 23, 2016: Volume 18, Number 4

January 16, 2016: Volume 18, Number 3

January 9, 2016: Volume 18, Number 2

January 2, 2016: Volume 18, Number 1

December 26, 2015: Volume 17, Number 52

The Platform
Formula One Racing Can Drive CFD Innovation Faster

Anton Sequel Makes Stronger Case for Custom Supercomputing

Future Systems: What Will Tomorrow's Server Look Like?

IBM Traverses Deeper into Graph Territory

Aiming Object Storage At Hadoop, Hitting Core Enterprise Instead

ARM Momentum Builds for European HPC Set

Technical Debt Could Leave Machine Learning Bankrupt

How Big Banks Thread The Software Performance Needle

The Long Cycles Of Enterprise Networks

How Long Can AWS Keep Climbing Its Steep Growth Curve?

Custom Hardware Sharpens Edge for Deep Learning Future

Containerizing Engineering Simulation for Faster CFD at Trek


Bug Busters Software Engineering
ProData Computer Services
WorksRight Software

IBM i and .Net Connectivity With XMLSERVICE

Use SQL To Change A Substring

Parsing Delimited Text Data Natively In SQL, Part 2: Java To The Rescue

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

Privacy Statement