fhg
Volume 10, Number 13 -- April 14, 2010
Sponsored By
SEQUEL SOFTWARE

SEQUEL ViewPoint®--Data Access & Analysis for Power Systems™ Servers

 

 · Easy to use by IT and end users
 · Real-time data access and analysis
 · Queries, reports, pivot tables, drill-down
    analysis, kpi dashboards
 · IBM i-centric with multiplatform data access
 · Expert support and training
 · Secure data access
 · GUI, Web & green screen interface

 

SEQUEL--Fast, efficient & cost-effective data analysis

 

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


Query Control
by Paul Tuohy

Query is the system killer. The lights dim. The system slows to a crawl. It must be a user running an interactive query. READ MORE >

Update One File Based on Another File
by Ted Holt

It's not uncommon to have to update one file based on data found in another file. In fact, it's a very common requirement, due to the way that data is normalized in relational database management systems. When only one field links the two files--the file that is being updated and the file that contains the search criteria--the SQL syntax is simple. But joining on two or more fields requires more challenging syntax. READ MORE >



Sponsored By
HALCYON SOFTWARE

Do More With Less Resources

 

Discover how to use the pre-defined template features of System Operations Suite to monitor critical applications for ERP systems on the i OS platform, including Lawson M3, Misys' financial applications, various Infor products, SAP's Business Suite, Oracle's JD Edwards products, and popular i OS-based high availability solutions.

 

Learn more




Admin Alert: Some Simple Ideas for Getting the Best System i Lease
by Joe Hertvik

Buying a new Power i machine can be complicated. Not only do you have to correctly size everything for future growth, you also have to purchase the hardware, software, and maintenance at a reasonable price. And if your organization wants to lease its new machine, you may wind up scratching your head wondering just what those leasing numbers mean, or if your organization is being taken advantage of. 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: Erwin 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

BCD:  April 21 Webinar - Web enable your IBM i programs & satisfy end-users
inFORM Decisions:  Paperless saves $$$. Learn more and get FREE white papers.
COMMON:  Join us at the annual 2010 conference, May 3 - 6, in Orlando, Florida

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.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 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
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
The Possibilities for Open Access for RPG

IBM's Smartie and Pizzazz Clusters--Still i-Less

How To Match Modernization Projects and Business Strategy

As I See It: Mining in the Anthropocene Epoch

Another Smarter Planet Blitz This Week, i 7.1 Included

Four Hundred Stuff
IBM Officially Announces i/OS 7.1

Zend Server for i/OS Now Available

Information Builders Seeks to Democratize BI with WebFOCUS 8

Purchase-to-Pay Vendor Sets Up Shop in U.S.

Free iPhone App from Sentinex Connects to Infor ERP A+

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

System i PTF Guide
April 10, 2010: Volume 12, Number 15

April 3, 2010: Volume 12, Number 14

March 27, 2010: Volume 12, Number 13

March 20, 2010: Volume 12, Number 12

March 13, 2010: Volume 12, Number 11

March 6, 2010: Volume 12, Number 10

TPM at The Register
Mellanox ships rounded InfiniBand lineup

IBM debuts new Power 7 iron this week

Oracle freshens its VirtualBox

US Justice to ratchet tech no-poach probe

Super Micro goes platinum

Cisco ratchets networking for unified servers

Forrester calls time on IT downturn

Citrix buys stake in virtual desktopper

IBM raids Oracle-Sun hardware channel

IBM widens data analytics fleet

Microsoft's HPC Server 2008 R2 goes beta 2

US weather meisters buy mini Cray

THIS ISSUE SPONSORED BY:

SEQUEL Software
WorksRight Software
Halcyon Software



TABLE OF CONTENTS
Query Control

Update One File Based on Another File

Admin Alert: Some Simple Ideas for Getting the Best System i Lease

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

Privacy Statement