fhg
Volume 9, Number 22 -- July 8, 2009
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
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!



Microsoft Virtualization for the i Guys, Revisited
by Michael Sansoterra

Some time ago, in an article entitled Developers Don't Despair: Virtualize Your PC, I listed the benefits of using PC emulation software such as Microsoft's Virtual PC or VMware's VMware Workstation. READ MORE >

Subqueries vs. Joins
Hey, Ted:

Please settle a disagreement. Another developer claims that it is bad to use an SQL subquery if the same results can be achieved with a join. He says that database management systems can optimize joins better than they can optimize subqueries, which means that joins run faster than subqueries. Is this true? I seem to have heard somewhere that the query engine converts a subquery to a join when possible. READ MORE >



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




Admin Alert: Fine Tuning User Access with Application Administration
by Joe Hertvik

Being a robust system developed over several decades, i5/OS has several valuable features that you may not be aware of. For example, the Application Administration function allows you to provide and deny access to many sensitive system functions. This week, I'll look at Application Administration and demonstrate how it can help you obtain better control over what your users can and cannot do on the 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: 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

ARCAD Software:  FREE Webinar, July 15, Efficient and Secure Critical Data Change Management
10ZiG Technology:  BOSaNOVA, Inc. is now 10ZiG Technology
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
Midrange Shops Shift Priorities This Year

The Best of Times for IBM to Support All Its i Customers

What We Can Learn from iManifest

As I See It: Oh the Jobs They Are a-Changin'

Storage Hardware and Software Take Their Lumps in Q1

Four Hundred Stuff
Infor Sheds More Light on 'Flex' Upgrade and Migration Programs

Thales Key Manager Lowers Barriers to Encryption

iSecurity Experts: New Name, Familiar Face, Services a Priority

iBridge Traverses System i-Windows Divide for ACOM

IBM Lotus Brings Connections to the Cloud

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

System i PTF Guide
July 4, 2009: Volume 11, Number 27

June 27, 2009: Volume 11, Number 26

June 20, 2009: Volume 11, Number 25

June 13, 2009: Volume 11, Number 24

June 6, 2009: Volume 11, Number 23

May 30, 2009: Volume 11, Number 22

TPM at The Register
IBM finances vSphere-x64 server bundles

Niagara Falls to power next Yahoo! data centre

Dell cracks open EMEA PC services

US employers cut 467,000 jobs in June

Unisys to build its own stealthy cloud

Oracle slips notes to Wall Street

Canonical offers tech support for clouds

Sun's VirtualBox 3.0 exits betaland

Forrester re-slashes 2009 IT spending forecast

Cisco cuddles all clouds but one

Red Hat inks cloud partnership with Amazon

Sun hardens OpenSolaris for EC2

US IT staff salaries and benefits shrink

Bull waves red flag at HPC with blade supers

THIS ISSUE SPONSORED BY:

ProData Computer Services
Help/Systems
WorksRight Software



TABLE OF CONTENTS
Microsoft Virtualization for the i Guys, Revisited

Subqueries vs. Joins

Admin Alert: Fine Tuning User Access with Application Administration

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
PHP CLI Call

Perl, PHP, and/or ZendCore

batch printing PDF files from RPG program

Using db2_connect in PHP on iSeries

How to return value from CL program?

ADO.NET/IBM.Data.DB2.iSeries/ iDB2Connection

Order by alias names




 
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