fhg
Volume 16, Number 15 -- July 12, 2016
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


Sponsored By
VALENCE FRAMEWORK FOR IBM i

Valence 5: User Experience First!
Create web and mobile apps on IBM i that deliver the best user interface possible! Using RPG and a popular HTML5 Framework, Valence empowers developers to quickly create stunning applications that run entirely on IBM i.

 

Just released: Valence 5!
New features include a completely redesigned web portal and updated tools that allow developers and super users alike to create highly useful apps with little or no programming. You can produce a fully functional dashboard, inquiry or file maintenance app within minutes of installing Valence!

 

Download Valence Free!


A Generic Character Editing Routine
by Jon Paris

Recently I was asked if I knew of a way to edit character strings. For example, take a character string representing a product code such as AX12345Q and edit it to produce AX-123-45 Q. My initial reaction was to reach for an edit word, but sadly they only work for numerics, for some strange reason. READ MORE >

Formatting Dates With SQL, Take 3
by Ted Holt

I love it when someone improves something I've produced. In this case, that someone was Barry Arnold, an A-1COBOL programmer with whom I had the privilege to work once upon a time. Barry improved my FMTDATE SQL function for use in his shop. Maybe his enhancement will help you, too. READ MORE >

Sponsored By
SYSTEM i DEVELOPER

RPG & DB2 Summit + Hands-On Workshops

Rise to the i can . . . can you? challenge at the RPG & DB2 Summit October 4-6 in Chicago.

Get the latest tips & techniques on 7.3, RPG, Free Form, SQL, DB2, ILE, Web Services, RSE/RDi, web & mobile apps plus 1-on-1 advice from top experts Jon Paris, Paul Tuohy, Susan Gantner, Scott Klement & Ted Holt.

Add an 8-hour Hands-On Workshop--SQL, RSE, Service Programs or PHP--on Oct. 3.

Get a sneak peek at the session grid and register today to save $300!



New OLAP Aggregate Functions In DB2 for i, Part 1
by Michael Sansoterra

In my last tips about the new OLAP features in DB2 for i 7.3, I discussed the OLAP Aggregation Specification and the new LAG and LEAD OLAP functions. In this article and the next one, I continue the discussion of new OLAP features by highlighting four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE, and RATIO_TO_REPORT. The value of these functions is that they can reference data from other rows in a query result set relative to the current row. 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

System i Developer:  RPG & DB2 Summit - October 4-6 2016 in Chicago. Register now!
COMMON:  Open Source and Systems Management at the COMMON Forum. August 24-25 in Chicago.
OCEAN:  3 days of inspiration! 2016 IBM i Technical Conference, July 21-23, Costa Mesa, California

 

The Four Hundred
What Price Power (Eight And Maybe Nine)?

IBM i Skills Shortage A Barrier To Digital Transformation

IBM i Open Sourcerers

Cloud-Based Email Migrations Keep IBM i Vendor Busy

Maxava Opens Up Bidding For iFoundation Grants

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

System i PTF Guide
July 9, 2016: Volume 18, Number 28

July 2, 2016: Volume 18, Number 27

June 25, 2016: Volume 18, Number 26

June 18, 2016: Volume 18, Number 25

June 11, 2016: Volume 18, Number 24

June 4, 2016: Volume 18, Number 23

The Platform
Supercomputing's Scramble to Keep Thinking in Parallel

When HPC Becomes Normal

Stretching Software Across Future Exascale Systems

Dreaming Of 100 Exaflops In 2030

OpenPower Developers Primed for Big Wins at IBM Hackathon

In Situ Analysis to Push Supercomputing Efficiency

Inside Look at Key Applications on China's New Top Supercomputer

Oracle Takes On Xeons With Sparc S7

System Software, Orchestration Gets an OpenHPC Boost

Emerging "Universal" FPGA, GPU Platform for Deep Learning

Lenovo HPC Bounces Back After IBM Spinoff

Novel Architectures on the Far Horizon for Weather Prediction


THIS ISSUE SPONSORED BY:

WorksRight Software
Valence Framework for IBM i
System i Developer


TABLE OF CONTENTS
A Generic Character Editing Routine

Formatting Dates With SQL, Take 3

New OLAP Aggregate Functions In DB2 for i, Part 1


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

Privacy Statement