Volume 15, Number 11 -- June 2, 2015
Sponsored By

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

Ready to move beyond that green screen query tool?

Build customized, powerful reports quickly and deliver data in a format that works for every business level--including dashboards and outputting data in XLS, XLSX, PDF, RTF, and HTML.

Full-featured, easy to set up, and backed by world-class support, SEQUEL delivers data fast and clearly while helping to reduce the IT backlog.

Download the checklist to see how SEQUEL can take you beyond Query/400.

Paging Cursors And Position To
by Paul Tuohy

I had a reader email in relation to my article Paging Cursors. The article described a method for paging large lists using embedded SQL in RPG, and the reader was wondering if there was a way to position the list at a certain value. Of course there is! READ MORE >

Beware The Temporary Table
Hey, Ted:

I am writing in response to your article Dynamic Lists in Static SQL Queries. At a recent NEUSG meeting, Tom McKinley of IBM warned us to avoid temporary tables, especially query chains of temporary tables, as they have no history for the optimizer. I like dynamic SQL. I would have left it alone. READ MORE >

Sponsored By

UCG's VAULT400 BaaS Delivers Secure Cloud Backup and DR Solutions

IBM Power8 Servers
IBM i Solution Edition for VAULT400
Supports all platforms and databases
Secure data centers nationwide
Data encrypted and available 24/7
Support excellence, disaster readiness, technology that scales with your business

For a complimentary risk assessment, click here or call UCG at 800.211.8798!

VAULT400 BaaS Intro

EIM Identifier Naming
by Patrick Botz

Enterprise Identity Mapping (EIM) is the technology that allows the IBM i to determine which user profile should be used to establish a connection for a person who has authenticated to an IBM i interface using non-IBM i credentials. EIM is easy to set up, but there is one thing you can do that will save you time and effort later. 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

The Omni User:  Chicago's OMNI Technical Conference, June 4-5, Palos Hills, Illinois
ASNA:  Create great IBM i-driven smartphone and tablet mobile apps with nothing but plain ol' RPG.
LaserVault:  FREE ON-DEMAND WEBINAR: Understanding Tapeless Backups. Watch it now >


The Four Hundred
Power8 Iron Gets New I/O Options

Thoughts On The Power E850 And I/O Contraction

For OpenLegacy, Modernization Is All About the APIs

Maxava Builds On IBM i Sustainability Efforts

SQL Query And Report Tool Gets The ProData Treatment

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

System i PTF Guide
May 30, 2015: Volume 17, Number 22

May 23, 2015: Volume 17, Number 21

May 16, 2015: Volume 17, Number 20

May 9, 2015: Volume 17, Number 19

May 2, 2015: Volume 17, Number 18

April 25, 2015: Volume 17, Number 17

The Platform
Avago-Broadcom To Take On Intel In The Datacenter

The Other Cray Launches CPU-FPGA Hybrids

Steep Uphill Climb For GPU Computing To Hyperscale

Datacenter, Colo, Or Cloud--How Do You Decide?

Rescale's Political Stance Boosts Cloud Based Supercomputing

EMC Grabs A Bigger Piece Of The Cloud

What The HP Breakup Means For Enterprises

Intel Lets Slip Broadwell, Skylake Xeon Chip Specs

The Future Of Flash Is Massive Scale

Next Generation Supercomputing Developments Swarm Around Cities

Reworking the Schedule for Green Datacenters

Drill Mines Diverse Data Sets, Google Style


WorksRight Software
SEQUEL Software
United Computer Group, Inc.

Paging Cursors And Position To

Beware The Temporary Table

EIM Identifier Naming

Four Hundred Guru


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