Volume 14, Number 25 -- November 12, 2014
Four Hundred Guru is taking a hiatus next week. We will resume publishing on December 3.
Sponsored By

Still Using a 'Green Screen' Query Tool?


Discover if it's time to upgrade from Query/400, and empower your users with modern, meaningful results.


See how SEQUEL can take you beyond what your current tool offers and transform your data into insight with an easy-to-use graphical interface and single-step results to Excel and more.


Download the Is It Time to Upgrade from Query/400? white paper today. >

Sponsored By

DBU. One Tool. Multiple Platforms.


Access all your data with DBU!


Now access IBM i data and ANY data on ALL platforms using the same interface.


ProData has the tools you need to get IT done.
We're your ONE stop shop!


Download DBU today at www.DoDBU.com



TR8 DB2 For i Enhancements, Part 1
by Michael Sansoterra

IBM i 7.1 Technology refresh 8 was released on June 6, 2014, and it has another group of small database enhancements worth reviewing. IBM i 7.2 users will find that they already have these features. This tip assumes that you have IBM i 7.2 or IBM i 7.1 with Database Group PTF Level 29 or higher installed. READ MORE >

SQL Functions You Didn't Know You Had, Part 2
by Ted Holt

In SQL Functions You Didn't Know You Had, Part 1, I showed you how to make an SQL function that runs a subprocedure in a service program. What I showed you is fine up to a point, but it's not the entire story. READ MORE >

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

Flip This Job Number: Adjusting The Job Queue Control Utility For Job Number Resets
Hey, Joe:

I just read your article on creating a skeleton program for controlling IBM i job queues creating a skeleton program for controlling IBM i job queues. In your job queue physical file (WRKJOBQPF) that contains the list of jobs inside a specific job queue, you keyed that file by the six-digit job number of each job in queue. I think that's a bad idea. Here's why. . . 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

NGS:  FREE, Live Webinar: Reporting & Analytics on IBM i for Manufacturers & Distributors. Nov 18
MiNET:  Automate PDF, email, Fax, Archiving & more with ArtForm400. Try us for a FREE Redbox code!
ASNA:  Powerful IBM i apps shouldn't require a painful learning curve. Get the ASNA Wings white paper.



More IT Jungle Resources:

System i PTF Guide: Weekly PTF Updates
IBM i Events Calendar: National Conferences, Local Events, and Webinars
Breaking News: News Hot Off The Press
TPM @ EnterpriseTech: High Performance Computing Industry News From ITJ EIC Timothy Prickett Morgan

The Four Hundred
First Pass On Power8 Enterprise Performance

Dispatches From The IBM i MSP Frontier

IBM And ISVs Fight POODLE Vulnerability In SSL 3.0

Mad Dog 21/21: Pandora's Pithos

College RPG Needs A Technology Refresh

Four Hundred Stuff
Vision Gets Serious About Hosted HA with MIMIX 8

ARCAD Software Takes On Database Modernization

Homebuilder Repels the Tape Monkey with Crossroads VTL

Halcyon Tackles IBM i Security with New Products

Attachmate Emulators Run Natively on iOS and Android

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

System i PTF Guide
November 8, 2014: Volume 16, Number 45

November 1, 2014: Volume 16, Number 44

October 25, 2014: Volume 16, Number 43

October 18, 2014: Volume 16, Number 42

October 11, 2014: Volume 16, Number 41

October 4, 2014: Volume 16, Number 40

TPM at EnterpriseTech
Cramming 220 PB In A Modular Datacenter

Dell Pushes Up Server Density With FX

Google Leverages Container Expertise On Its Cloud

New Dell GM Talks System Trends

Private Clone S3 Object Storage On A Massive Scale

Benefit From Microsoft's Open Compute Hyperscale Designs

Hadoop Finds Its Place In The Enterprise

Network Filers Take To The Clouds

Inside IBM’s "Hollow Core"

Pure Storage Hints At Hyperconverged Future

Big Three Linuxes Refreshed Now That SLES 12 Enters The Field

Moonshot Scale Leveraged For Transcoding, Web Infrastructure


SEQUEL Software
ProData Computer Services
WorksRight Software

TR8 DB2 For i Enhancements, Part 1

SQL Functions You Didn't Know You Had, Part 2

Flip This Job Number: Adjusting The Job Queue Control Utility For Job Number Resets

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

Privacy Statement