fhg
Volume 15, Number 24 -- November 17, 2015
Sponsored By
PRODATA COMPUTER SERVICES

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!
www.DoDBU.com
800.228.6318


Sponsored By
CONNECTRIA

Need Help Managing Your IBM i?

Trust Connectria as an extension of your IT department.

Realize higher uptime and lower operating expenses. We offer:
10+ years of experience
Current management of over 175 IBM i environments
24/7 support with no overhead or sick days. . . ever
A world-class monitoring & systems administration center

Learn more.

Contact us today.


An Introduction to Processing XML with RPG, Part 4
by Jon Paris

In the first three parts of this series, I focused on the basics of using RPG's XML-INTO. In this episode I want to wrap things up by covering two of the more recent additions to this support. READ MORE >

Formatting Dates with SQL, Take 3
Hey, Ted:

Great technique shared! Function overloading is a real boon to SQL programming. Here's another way that requires less code and is less invasive (i.e., you won't have to recompile anything.) READ MORE >

Sponsored By
WORKSRIGHT SOFTWARE

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



Data Scrubbing Functions In DB2 For i
Hey, Mike:

Imagine a character database field that stores a phone number. No formatting rules are involved, so the values in the column vary such as 8370155738, 837/015-5738, 837-015.5738, etc. We'd like to write an RPG program that allows the user to enter a number, formatted or not, onto the screen and if that string of numbers is found in the table's phone column, show it to the user. Is there a way to use SQL to strip the non-numeric characters from the phone field, and select the record if the result matches the user input? 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

NGS:  Nov. 18 FREE Webinar: Migration Alternatives for Query/400 Users
United Computer Group:  VAULT400 BaaS delivers secure cloud backup and DR solutions
BCD:  IBM i Webinar with Jon Paris - RPG OA: So Misunderstood! November 18 at 1pm EST

 

The Four Hundred
What Good Is Native .NET On Power?

Technology Refreshes Go Unnoticed By Most IBM i Shops

Move Your IBM i To The Cloud On Your Own Terms

Mad Dog 21/21: Time, Like Gas, Passes; Love, Like Stardom, Fades

HelpSystems' Application Integration Begins With GUI

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

System i PTF Guide
November 14, 2015: Volume 17, Number 46

November 7, 2015: Volume 17, Number 45

October 31, 2015: Volume 17, Number 44

October 24, 2015: Volume 17, Number 43

October 17, 2015: Volume 17, Number 42

October 10, 2015: Volume 17, Number 41

The Platform
The Hardware Geek's Guide to SC15

A Clever Approach to Cultivating the HPC Stack

Inside eBay's Shift To Kubernetes And Containers Atop OpenStack

Mellanox Turns InfiniBand Switches Into MPI Accelerators

A Quantum Approach to Next Generation Nuclear Security

Evolving the HPC Software Stack with Fresh Hardware

Transactional Memory Comes To The Storage Hierarchy

Wider Net Cast Over Deep Learning on GPUs

Nvidia Brings Maxwell GPUs To Tesla Coprocessors

The Future of Quantum Computing Will be Hybrid

Doing The Math For Enterprise-Grade Object Storage

Intel Blunts ARM Assault With Expanded Xeon D


THIS ISSUE SPONSORED BY:

ProData Computer Services
Connectria
WorksRight Software


TABLE OF CONTENTS
An Introduction to Processing XML with RPG, Part 4

Formatting Dates with SQL, Take 3

Data Scrubbing Functions In DB2 For i


Four Hundred Guru

BACK ISSUES




 
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