fhg
Volume 9, Number 1 -- January 7, 2009
Sponsored By
HELP/SYSTEMS


     SEQUEL
     IBM® System i® Data Access Made Easy

 


  · Complete management access to critical data
  · Easy to use by IT and end users
  · Automated data access and display
  · Comprehensive BI package: reports, tables,
     key performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Expert support and training

 


Click here for a FREE Information Kit!



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


Bypassing a Locked Record, Take Two
Hey, Ted:

I have a slightly different solution to the locked record problem your friends tackled in Bypassing a Locked Record. Like them, I have RPG programs that sequentially read a file and update some of the records. When a program tries to read a record that another job has locked, I sometimes bypass the locked record. Here's how. READ MORE >

Be Specific When Updating With SQL Cursors
by Ted Holt

To update a table (physical file) through an SQL cursor, use the FOR UPDATE OF clause in your UPDATE command. (I have written about FOR UPDATE OF before.) When you update through an SQL cursor, avoid two mistakes that can cause a performance problem. READ MORE >



Sponsored By
MKS

Are you using WDSC today?
Moving to RDi tomorrow?

 

MKS offers a plug-in that enables developers to work more efficiently, and gives managers the process control and audit trail needed to meet compliance demands. See tasks, update issues, run queries, check out code and deploy directly from within your IDE!

 

Free white paper:
From WDSC to RDi - Making Software Change Easier with MKS Integrity for IBM i.




Admin Alert: Looking for i5/OS Trouble, Part I
by Joe Hertvik

I love stories with Cassandra characters, the slightly crazed player who accurately foresees oncoming doom, only to be mocked or ignored. Like Cassandra, i5/OS systems can also see events that portend system problems, clear omens that can easily be missed or ignored. This week and next, I'll discuss avoiding doom by monitoring several i5/OS situations that should be checked early and often. Ignore these warning at your own peril!!! 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

New Generation Software:  Run IBM Query/400 from your Windows desktop!
Bug Busters Software Engineering:  High availability software that won't break the bank
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
Now What?

IT Doing Better Than Other Careers in 2009

Strengthening Dollar Whacks Oracle's Second Fiscal Quarter

As I See It: The Rhythm of Things Unseen

Uncle Sam to Stop Buying Used IT Gear?

Four Hundred Stuff
Safestone Gives i Security Officers Greater Control

SPSS to Update ShowCase OLAP Server Technology

Rand McNally Keeps Truckers On the Go and In the Know

The Who's and What's of ESBs and eSBs

Mohawk Slashes Report Delivery Times, Thanks to Centerfield

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

System i PTF Guide
December 27, 2008: Volume 10, Number 52

December 20, 2008: Volume 10, Number 51

December 13, 2008: Volume 10, Number 50

December 6, 2008: Volume 10, Number 49

November 29, 2008: Volume 10, Number 48

November 22, 2008: Volume 10, Number 47

TPM at The Register
VCs still pump dough into green tech, renewable energy

Companies burying themselves in IT gear

Linux: this year's silver lining?

Server racket to slow in 2009?

Big Blue urged to open Notes and Domino

Data center budgets to stay course in 2009?

New Unisys CEO tightens the belt

Sun boosts OpenSolaris on Atom

VMware piles up next virtual stack for servers

Supermicro does micro server for SOHOs

Red Hat shakes off economic meltdown

UBS says IT spending in Europe, US to drop 2 per cent in 2009

Visionman launches Nehalem Core i7 servers

American IT staffing will not tank in Q1

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
MKS



TABLE OF CONTENTS
Bypassing a Locked Record, Take Two

Be Specific When Updating With SQL Cursors

Admin Alert: Looking for i5/OS Trouble, Part I

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Insert via Java

iSeries Access for Web

Mimix installation and configuration docs

EDI Inovis Programmer - Heavy Duty Problem Solver - Anytime

Data Queues vs. MQ Series: Performance

Removing blanks from a CL Variable

XML




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

Privacy Statement