fhg
Volume 16, Number 17 -- August 2, 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!


CHAIN vs SELECT INTO
by Chuck Luttor

The average RPG developer can quickly become proficient in replacing RPG database operation codes with their SQL equivalents when undertaking new programming. In each installment of this series, I will visit an op code or set of op codes in order to prove my contention. First up today is CHAIN. READ MORE >

Give Me Fewer (Not More!) Parameters, Please!
by Ted Holt

Today's musings fall into the 'why would anybody want to do that?' category. 'Why would anybody want to be president?' asks Barack Obama. 'Why would anybody steal a groundhog?' asks Rita in Groundhog Day. My question is, 'Why would anybody pass 16,382 parameters to a subprocedure?' There is a better way. READ MORE >

Sponsored By
SYSTEM i DEVELOPER

New Database Track at the Summit!

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.

New DB2 track features 7.3 enhancements + step-by-step Design/Build/Secure/Tune tips.

Get a sneak peek at the session grid and register by August 26 to save $300!



Using Lateral Correlation To Define Expressions In DB2 For i
by Michael Sansoterra

The SQL implementation in DB2 for i is second to none. However, one irritating thing common to various SQL dialects is the need to repeat expressions in query. As SQL matured over the years, techniques such as nested table and common table expressions became available to, among other things, reduce repetitive expressions. This tip illustrates the use of the LATERAL correlation as another way to avoid repetition. 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.
Four Hundred Monitor Calendar:  Latest info on national conferences, local events, & Webinars

 

The Four Hundred
Surviving A Change Management Migration

Townsend Ponders Future Of DB2 Modernization Tech

At The End Of The Power8 Long Tail

Mad Dog 21/21: Brexit, Pursued By A Bear Market

Systems Monitoring Made Easier, Better, GUI-er

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

System i PTF Guide
July 30, 2016: Volume 18, Number 31

July 23, 2016: Volume 18, Number 30

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

The Platform
Changing the Exascale Efficiency Narrative at Memory Start Point

First, Kill All The Servers

Mesos Reaches Milestone, Adds Native Docker

Google Fosters Another OpenStack Kubernetes Mashup

Intel Broadwell Rollout Complete With Xeon E5 Quads

MIT Research Pushes Latency Limits with Distributed Flash

A Thirst For Petabyte Scale All-Flash Arrays

Are ARM Virtualization Woes Overstated?
Datacenters, Poised To Spend, Take A Breather From Intel

Stacking Up Oracle S7 Against Intel Xeon

Systems Are The Table Stakes For IBM's Evolution

HPC Flows Into Hyperscale With Dell Triton


THIS ISSUE SPONSORED BY:

WorksRight Software
T.L. Ashford
System i Developer


TABLE OF CONTENTS
CHAIN vs SELECT INTO

Give Me Fewer (Not More!) Parameters, Please!

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

Privacy Statement