fhg
Volume 16, Number 16 -- July 19, 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
T.L. ASHFORD

Convert your IBM i spool files into full-color, professional forms!

#1 Easy Design
Graphical Designer. True type fonts. MICR font. Bar codes including PDF-417, QR Code. Images.
#2 No Programming
As soon as your form is designed, it's automatically integrated with your application.
#3 One Low Price
Output as PDF. Archive to IFS. Print to any printer. Email.
#4 Return on Investment
#5 Outstanding Customer Support

Download a Free Trial!


A Second Look At SQL Descriptors
by Paul Tuohy

My previous article, A First Look at SQL Descriptors, looked at how SQL descriptors can be used in constructing and processing dynamic SQL statements. This article examines how SQL descriptors can be used in processing the information returned through a dynamic SQL statement. READ MORE >

Side-By-Side Lists
Hey, Ted:

An end user has asked me to provide him a spreadsheet with two independent lists, one beside the other. Can I use SQL to satisfy his request? READ MORE >

Sponsored By
LASERVAULT

WIN A $500
DJI PHANTOM
VIDEO DRONE!

Sign-up for the live webcast on Wednesday, July 27th at 2p.m. EST and learn how to simplify your IBM i backup and recovery process.

Space is limited. Reserve your spot now and secure your chance to win a video drone!

Register here >

LaserVault.com



New OLAP Aggregate Functions In DB2 For i, Part 2
by Michael Sansoterra

In my last article, I promised to tell you about four new OLAP aggregate functions: FIRST_VALUE, LAST_VALUE, nTH_VALUE and RATIO_TO_REPORT. These valuable functions can reference data from other rows in a query result set relative to the current row. This tip covers the fourth function in the list, RATIO_TO_REPORT. 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.
LaserVault:  Webinar → Simplify IBM i backup and recovery. July 27, 2pm EST. Enter to win a drone!

 

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 16, 2016: Volume 18, Number 29

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

The Platform
Knights Landing Will Waterfall Down From On High

Optimization Tests Confirm Knights Landing Performance Projections

China's Triple Play For Pre-Exascale Systems

Competition Heats Up In Cluster Interconnects

Startup Takes a Risk on RISC-V Custom Silicon

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


THIS ISSUE SPONSORED BY:

WorksRight Software
T.L. Ashford
LaserVault


TABLE OF CONTENTS
A Second Look At SQL Descriptors

Side-By-Side Lists

New OLAP Aggregate Functions In DB2 For i, Part 2


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