Volume 16, Number 02 -- January 26, 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!

Run VisualAge RPG Applications On 64-bit Windows 7, 8, And 10 Over The LAN
by Dan Devoe

With assurance of continued support from IBM, we used VisualAge RPG (VARPG) to develop modern business applications. Then IBM pulled the plug on VARPG. Nevertheless, we've kept our applications working, and have even managed to find a way to run them under 64-bit Windows from our LAN. Here's how we did it. READ MORE >

Upsert One Row From A Data Structure
Hey, Ted:

I'm attempting to use the SQL MERGE statement to write an upsert that stores the data to be inserted or updated in an externally described data structure. Is that possible? Any insight into this would be helpful. 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 1
by Michael Sansoterra

A common task for database developers is to accept a delimited text file, parse it, and dump it into a database table. This tip demonstrates a user-defined table function (UDTF) that can accomplish this task based on delimited text data stored in a CLOB or in an IFS file. 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

Townsend Security:  IBM Security QRadar, IBM i and Townsend Security - Better Together
System i Developer:  RPG & DB2 Summit - March 22-24 in Dallas. Register by Feb 12 and save $300!
Fresche Legacy:  Optimize IBM i apps; Improve business processes; Deliver modernization success


The Four Hundred
Power Systems Turns In A Full Year Of Growth

What To Do With All Those Spare CPWs

Web Portal Not An IBM i Modernization Bit Player

Mad Dog 21/21: Pythia And The Two-Legged Pig

Baseline Data Boss Predicts Steady Stream Of Outsourced Production Environments

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

System i PTF Guide
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

December 19, 2015: Volume 17, Number 51

The Platform
Baidu Looks to Next Generation Deep Learning Accelerators

Light at the End of the Silicon Photonics Tunnel

French Nuclear Agency Bolstering Supercomputing I/O Might

A Deep Dive Into IBM's Real Systems Business

Disaggregation Busts Open Switch Operating Systems

The Next Wave Of All-Flash Arrays Will Run Lean

A New Object of Supercomputing Storage Interest

What The IT Spending Forecasts Don't Tell You

IBM Doubles Up Memory, Adds Power8 CPUs For Big Iron

Weaving Together The Machine's Fabric Memory

The Glass House Is Still Intel's Piggy Bank

Clever Ethernet Switching Rises From Calxeda ARM Ashes


Bug Busters Software Engineering
ProData Computer Services
WorksRight Software

Run VisualAge RPG Applications On 64-bit Windows 7, 8, And 10 Over The LAN

Upsert One Row From A Data Structure

Parsing Delimited Text Data Natively in SQL, Part 1

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