fhg
Volume 11, Number 7 -- February 23, 2011
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


Sponsored By
BOTZ & ASSOCIATES, INC.

Free 1-Hour Security Consultation
with Patrick Botz

 

Need advice you can trust on security audits, PCI, HIPAA or SOX requirements, 3rd party software, rational password management, public authority or Security Level 40?

 

Spend an hour with Patrick Botz - FREE - and get actionable info and tips to get you started. Custom, 100% independent advice from the guy who helped architect Power Systems / IBM i security.

 

Click to set up your free session with Pat. World-class security expertise is no longer just for the big guys!


Secure DB2 for i Database Server Access by IP Address
Hey, Mike:

I am trying to secure external access to our iSeries DB (ODBC, JDBC, et al). From a security point of view, I want to allow database access if it comes from specific IPs or servers. But I cannot find a way to identify the source (i.e., remote IP address) from the QIBM_QZDA_SQL2 exit point. I only find the user ID. Is there a way to obtain the source of the remote client attempting to connect to DB2? READ MORE >

Avoid Division by Zero in Query/400
Hey, Ted:

I want to build a temporary database file to send to a user, but records with a zero divisor do not get written to the output file. Can I prevent Query for i from dividing by zero? READ MORE >



Sponsored By
SYSTEM i DEVELOPER

Meet Dr. Soltis at the Summit!

 

Rise to the i can ... can you? challenge at the RPG & DB2 Summit this March in Orlando.

 

Join Dr. Frank Soltis for a discussion on ways to keep the IBM i central to your IT organization. Then upgrade your skills with the latest on RPG IV, embedded SQL, RPG & the Web, PHP, RDi, DB2, SQL tuning and more with top experts Susan Gantner, Jon Paris, Skip Marchesani, Paul Tuohy, Scott Klement & others in a highly interactive, invigorating, fun environment.

 

Click to see the Session Grid & register today!




Image Catalogs: Another Timesaving Method for Upgrade or Installs
Hey, Joe:

Great article on six tips for preventing Power i upgrades from slowing down. One tip that you missed is using Image Catalogs for your upgrades. They really help with installing software and PTFs. Also PTFs should be downloaded via FTP using IBM procedures from their Web site. CDs and DVDs are nice, but image catalogs are significantly better! 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

PowerTech:  FREE Webinar! An Auditor's View: Assessing IBM i Security Risks in 15 minutes. March 2
RJS Software Systems:  Integrate RPG, SQL and Excel for maximum ROI with RPG2SQL Integrator
Northeast User Groups Conference:  21th Annual Conference, April 11 - 13, Framingham, MA

 

 

IT Jungle Store Top Book Picks

BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

The iSeries Express Web Implementer's Guide: List Price, $49.95
The iSeries Pocket Database Guide: List Price, $59
The iSeries Pocket SQL Guide: List Price, $59
The iSeries Pocket WebFacing Primer: List Price, $39
Migrating to WebSphere Express for iSeries: List Price, $49
Getting Started with WebSphere Express for iSeries: List Price, $49
The All-Everything Operating System: List Price, $35
The Best Joomla! Tutorial Ever!: List Price, $19.95


 
The Four Hundred
New Power Systems VP Talks IBM i Strategy, Roadmaps

Humans Fight, But Watson's Chips Beat Quiz Champs

Lotus on IBM i: A Chat with Some Users

As I See It: The Digital Uprising

Zend Gently Nudges Customers to New PHP Runtime

Four Hundred Stuff
Infor Has High Hopes for New S&OP Application

At mindSHIFT, IBM i Hosting Options Abound

nuBridges Unveils TaaS, a Hosted Data Tokenization Service

Qualys Launches Open Source Web App Firewall Project

IBM Delivers Super Fast IPS

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

System i PTF Guide
September 25, 2010: Volume 12, Number 39

September 18, 2010: Volume 12, Number 38

September 11, 2010: Volume 12, Number 37

September 4, 2010: Volume 12, Number 36

August 28, 2010: Volume 12, Number 35

August 21, 2010: Volume 12, Number 34

TPM at The Register
Oracle debuts carrier-grade Sparc T3 servers

How to build your own Watson Jeopardy! supermachine

Intel sends 'Poulson' Itaniums to the shrink

Swiss boffins go nuts for Cray supers

HP reinvents self as data center designer

Novell shareholders approve Attachmate buyout

Cray wraps 2010 on high note

IBM answer machine makes chumps of trivia chimps

Nvidia's Q4 padded with Intel cash

IBM tweaks blade and network gear

Dell to buy AMD?

Humans shamed in round two of Jeopardy! showdown

THIS ISSUE SPONSORED BY:

WorksRight Software
Botz & Associates, Inc.
System i Developer



TABLE OF CONTENTS
Secure DB2 for i Database Server Access by IP Address

Avoid Division by Zero in Query/400

Image Catalogs: Another Timesaving Method for Upgrade or Installs

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

Privacy Statement