fhg
Volume 16, Number 01 -- January 12, 2016
Sponsored By
BUG BUSTERS SOFTWARE ENGINEERING

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:
www.bugbusters.net


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


Updated RDi Keyboard Shortcuts
by Susan Gantner

I've written tips about RSE/RDi keyboard shortcuts several times before. Readers of those tips will know that I created a downloadable list of my favorite keyboard shortcuts. I've updated the shortcut card fairly regularly and the most recent edition has recently become available. So if you have previously downloaded my shortcut card and found it useful, you may want to get the latest one here. READ MORE >

Throw Away Old Summary Query Techniques
by Ted Holt

It's a new year! Out with the old! In with the new! That exhortation applies not only to everyday life, but also to the ways we write SQL queries. Let me show you two ways we used to have to write summary queries and two new ways that are better. READ MORE >

Sponsored By
SYSTEM i DEVELOPER

Hands-On Coding Skills at the Summit!

Rise to the i can . . . can you? challenge at the RPG & DB2 Summit March 22-24 in Dallas.

Get 1-on-1 advice plus the latest in use-it-today tips & techniques on RPG IV, SQL, DB2, RPG & the Web, PHP, Web Services, RSE/RDi, mobile apps from top experts Paul Tuohy, Jon Paris, Susan Gantner, Scott Klement & Ted Holt.

Add an optional 8-hour hands-on workshop on SQL, PHP or RSE on March 21.

Check out the sessions so far and register by Feb 12 to save $300!



SQL Paging With Limit And Offset In DB2 For i
by Michael Sansoterra

LIMIT and OFFSET are two new query options that will please every developer who builds user interfaces (UI) involving potentially large result sets. Handling UI queries that return a large number of rows can be annoying as they may take too long to process, create heavy network traffic, and require a web or desktop client to cache the result set. Further, it's unlikely a user will review all the rows! But what if DB2 returns only what is needed by giving back one slice of the entire result set on demand? 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!
United Computer Group:  VAULT400 BaaS delivers secure cloud backup and DR solutions

 

The Four Hundred
Finding IBM i: A Game Of 40 Questions

2016 Predictions For IBM i: Cautious Optimism

Software Group Essentially Gone With Steve Mills Retirement

As I See It: Asking The Right Question

ARCAD Sets Out To Modernize German Midrange

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

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

December 12, 2015: Volume 17, Number 50

December 5, 2015: Volume 17, Number 49

The Platform
Cray CTO Connects The Dots On Future Interconnects

National Lab Pushes Graph Platforms to New Points

Bloomberg Trades Static Clusters For Homegrown Mesos

ARM Servers: Throwing Down The 25 Percent Share Gauntlet

A Strange State for the Russian Supercomputing Industry

An Expanding Role for FPGAs in CERN's Future

Lessons Learned, And The Year Ahead

Convergence Gets Hyper In The Datacenter

Drilling Down Into The Machine From HPE

Inside the GPU Clusters that Power Baidu's Neural Networks

Facebook To Open Up Custom Machine Learning Iron

Looking Ahead In The Datacenter With Intel


THIS ISSUE SPONSORED BY:

Bug Busters Software Engineering
WorksRight Software
System i Developer


TABLE OF CONTENTS
Updated RDi Keyboard Shortcuts

Throw Away Old Summary Query Techniques

SQL Paging With Limit And Offset 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