fhg
Volume 10, Number 19 -- June 16, 2010
Four Hundred Guru is taking a hiatus next week. We will resume publishing on June 30.
Sponsored By
PRODATA COMPUTER SERVICES

Push-Pull-Synchronize Data TODAY!

 

Finally, a product that provides easy and full SQL access to remote databases from all System i high-level languages. Remote Database Connect gives you easy access to remote databases from your System i programs.

 

Share real time data across platforms NOW!

 

Use RDB Connect today.....
download a free trial NOW.

 

Order today and SAVE $$$!
800.228.6318

sales@prodatacomputer.com
www.prodatacomputer.com


Sponsored By
SYSTEM i DEVELOPER

Take it to the Summit!

 

Rise to the i can ... can you? challenge at the next RPG & DB2 Summit this October 12-14. Upgrade your skills - and your career - with the latest on RPG IV, embedded SQL, RPG & the Web, PHP, RDi, DB2, SQL tuning, more!
      Learn practical, use-it-today tips and techniques from top experts Susan Gantner, Jon Paris, Skip Marchesani, Paul Tuohy, Scott Klement & others in a highly interactive, invigorating, fun environment. YOU have the power to keep the IBM i - and your skills - vital to your company.

 

Click to see the sessions.
Register by July 30 for just $1095!


Client/Server Performance, Part 1: Blocking
by Michael Sansoterra

It is no secret that read performance can generally be improved by the age-old blocking mechanism whereby many rows are fetched at once in preparation for a program to process them. So how is blocking done in the client/server world? Assuming that the good old IBM i will be the server, the following code samples (C#, Java, VBA, and DRDA) show an example of how to increase the amount of data that can be transferred from the server to the client. READ MORE >

SQL Performance: IN vs. EXISTS
Hey, Ted:

Concerning your article Update One File Based on Another File, I would agree that the IN is more intuitive than the EXISTS. When looking at the volume of data, possible number of rows to update, and the rows returned for the IN, is there a preferred method if considering performance? Does the IN or EXISTS result in better performance under certain conditions? READ MORE >



Sponsored By
TWIN DATA CORPORATION

Use all your existing Twinax Terminals and Printers on new System i i5 Power6 & Power5 systems now, and the Power7 when it's introduced.

 

No need to replace your current devices. Just connect the Xip Twinax Controller to Ethernet and your Twinax devices to it, and you will be able to use them with the new Power6 in a pure TCP/IP environment. With the choice of multiple protocols, you can choose what's best for your environment.

 

Perfect for Local or Remote locations.

 

Call us for details on the Xip and a 30-day trial:
1-800-597-2525 Domestic
1-908-855-8100 International

 

www.twindata.com




How Do I Tell These Partitions Apart?
Hey, Joe:

My organization has five different i/OS partitions. Yesterday, I thought I was working on a test partition green screen and it turned out that I was signed on to a production system. Worse, I deleted a production file and it caused a lot of problems. Can you think of any good way I can stop that from happening in the future? 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

looksoftware:  Recreate your IBM i applications with re:new! Free Webinar!
Shield Advanced Solutions:  Receiver Apply Program ~ affordable availability for the IBM i
COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas

 

 

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
Two Top i Concerns and a Bunch of Little Ones

IBM Puts More Power7 Iron Through the Java Test Paces

Open Source EGL Means an RPG Generator Is Possible

Mad Dog 21/21: Market Cap and Propeller Beanies

Which Way to HA? Hardware, Software, or Both?

Four Hundred Stuff
Synergivity Brings i/OS Change Management to US Market

Shield Unveils New DR Solution for i/OS

Centerfield Makes SQL Tuning Easier with HomeRun 7.0

Linoma Beefs Up MFT Offering

VAI Unveils New SaaS Option

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

System i PTF Guide
May 29, 2010: Volume 12, Number 22

May 22, 2010: Volume 12, Number 21

May 15, 2010: Volume 12, Number 20

May 8, 2010: Volume 12, Number 19

May 1, 2010: Volume 12, Number 18

April 24, 2010: Volume 12, Number 17

TPM at The Register
Jamcracker herds SaaS, private cloud users

China, India steady on server sales

Mystery startup uncloaks 512-core server

VMware inks OEM deal with Novell for SUSE Linux

Hardware spending drives IT growth in 2010

HP preps (more) Opteron 6100 racks and blades

Red Hat notches up another KVM cloud win

Dell kicks out new blades and racks

IBM tunes math on Power/AIX boxes

Novell wants a piece of Sun Oracle

Unix in the UK: Mission critical!

VM6 Software punts Hyper-V wrangler

THIS ISSUE SPONSORED BY:

ProData Computer Services
System i Developer
Twin Data Corporation



TABLE OF CONTENTS
Client/Server Performance, Part 1: Blocking

SQL Performance: IN vs. EXISTS

How Do I Tell These Partitions Apart?

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