fhg
Volume 9, Number 27 -- September 2, 2009
Four Hundred Guru is taking a hiatus next week. We will resume publishing on September 16.
Sponsored By
PRODATA COMPUTER SERVICES

Simplify your iT!

 

DBU - super easy to use. The leading data access tool on the market.

 

DBU RDB - does the work for you. Analyze data on all your servers. MySQL, Microsoft SQL Server, Oracle, DB2 databases and others.

 

RDB Connect - programmatic access to remote data! Full SQL access to remote databases from all System i high-level languages.

 

Download your free trials NOW.
Order today and SAVE $$$!
www.prodatacomputer.com
800.228.6318


Sponsored By
EAST COAST COMPUTER

Remember the good old days?
Everything ran in the datacenter and users had dumb terminals.

 

Citrix end-to-end desktop delivery is proven, flexible (compatible with VMWare and Hyper-V), and easy to deploy and manage.
· Centralize Windows environment management
· Reduce desktop TCO up to 40%
· Increase data security
· Enhance user experience

 

Citrix XenDesktop delivers desktops as a service to users anywhere.

 

Contact East Coast Computer at 800-829-6163
or learn more at www.ecc400.com


Use the Dup Key in Subfiles
Hey, Ted:

I hope you don't mind another question about the 'old' stuff. How do I program for the Dup key in a data entry subfile? READ MORE >

An Overview of User-Defined Types in DB2 for i
by Michael Sansoterra

UDTs or User-Defined Types (also known as distinct types) allow SQL developers to implement their own data types. For example, if a database contains many tables that each have one or more columns representing a general ledger account number defined as VARCHAR(30), a suitable UDT can be defined as follows: READ MORE >



Sponsored By
MANTA TECHNOLOGIES

BIG SAVINGS on IBM i TRAINING COURSES

 

Whether you're looking to improve your skills or learn something new, Manta's training library is filled with courses for all levels of i users. Courses are self-contained, interactive sessions that can be completed over the Internet or on CD.

 

Browse our catalog and take advantage of SALE pricing!

 

Order by October 15 and SAVE 25%

 

To order, visit www.mantatech.com

 

Manta is your complete source for IBM i training.




Admin Alert: The Road to Live CBU Fail Over, Part 1
by Joe Hertvik

One of the companies I work with performed its first live Capacity BackUp (CBU) switch test last month, where they switched over and used their CBU system as their live production system for several days. In the next few issues, I'll use their experience in prepping for a live switch as a possible guide for others trying to ensure that their CBU can substitute for a live system. 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

Maximum Availability:  Upgrade to *noMAX - save 20% on current fees
ARCAD Software:  Start 5250 emulation sessions from your RDi workspace - download freeware!
COMMON:  Celebrate our 50th anniversary at annual conference, May 2 - 6, 2010, in Orlando

 

 

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
CIOs Say Power Systems Are the Most Reliable

A Closer Look at IBM's Q2 Server Sales

Has IBM Given Up on the i?

Mad Dog 21/21: Terms and Conditions

Jack Henry Lays Out $17 Million for Goldleaf After Good 4Q

Four Hundred Stuff
Managed File Transfer: A New Product Category That's Here to Stay

IBM to Formally Announce EGL Community Edition Today

Linoma Introduces MFT Software for External Exchanges

SEQUEL Updates i OS Time and Date Override Software

Cosyn Augments BPCS Accounting with AP Minder

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

System i PTF Guide
August 29, 2009: Volume 11, Number 35

August 22, 2009: Volume 11, Number 34

August 15, 2009: Volume 11, Number 33

August 8, 2009: Volume 11, Number 32

August 1, 2009: Volume 11, Number 31

July 25, 2009: Volume 11, Number 30

July 18, 2009: Volume 11, Number 29

TPM at The Register
VMware vSphere gets more gadgets

Semiconductor sales rise 5.3% in July

Sun sales plummet 30.6% in Q4

AMD plays it cool with low-volt Istanbuls

Xen packages build-your-own-cloud kit

OpSource floats VMware cloud

Intel boosts Q3 guidance

Novell profits even as sales slide

VMware goes into hyper-drive with vSphere 4.0

Cray nabs PathScale compilers from SiCortex

Tibco snaps up DataSynapse for $28m

Sun goes over Rainbow Falls

Amazon does virtual private clouds

Big chip for big boxes: IBM cracks open lid on Power7

THIS ISSUE SPONSORED BY:

ProData Computer Services
East Coast Computer
Manta Technologies



TABLE OF CONTENTS
Use the Dup Key in Subfiles

An Overview of User-Defined Types in DB2 for i

Admin Alert: The Road to Live CBU Fail Over, Part 1

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

Privacy Statement