fhg
Volume 7, Number 5 -- February 7, 2007
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
SEQUEL

SEQUEL can be used for
virtually ALL business intelligence functions
on the System i, including:

 

            · Executive Dashboards
            · Graphical Query & Reporting
            · Drill-Down Data Analysis
            · Multi-Platform Database Support
            · E-Mail Report and File Distribution
            · Secure Web Access

 

SEQUEL is the single solution for all
your business intelligence needs.

 

www.helpsystems.com


Opportunities, Not Problems!
by Ted Holt

One of my former bosses would often greet me with the phrase, "We have an opportunity." I suppose he didn't like the word problem. A recent problem I faced turned out to be a great opportunity. The utility I developed has turned out to be handy, and I thought you might like to have it in your toolbox. READ MORE >

SQL Cross Platform Interoperability: The Proper Function
by Michael Sansoterra

This tip has one very easy point: There's lot of reusable SQL code out there, and System i (AS/400) DB2 developers can take advantage of it. Even though SQL's promise of cross platform independence has never materialized, there are still enough similarities to make conversion between platforms worthwhile. All it takes is a little practice. READ MORE >



Sponsored By
RPG & DB2 Summit

Take it to the Summit

 

Advance your RPG & DB2 skills to
new heights! Join leading gurus
Paris, Gantner, Tuohy, Marchesani
and more for three days of intensive
learning and inspiration at the new
RPG & DB2 Summit in Las Vegas.

 

Hear the latest on ILE, SQL, RPG, &
RSE - practical information you will
use on your first day back to work.

 

The Early Bird rate of $950 expires
2/10/07 so register today!

 

SystemiDeveloper.com




Admin Alert: Selectively Sending Break Messages to Active Users
by Joe Hertvik

In a recent column, I discussed how to use the i5/OS Send Break Message command (SNDBRKMSG) to send messages that will immediately display on all 5250 terminals. Unfortunately, SNDBRKMSG has some issues in that it sends break messages to all defined user terminal message queues, not just the terminals of currently signed on users. In this issue, I'll discuss my utility to send break messages only to signed-on users. 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 Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
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

Aldon:  ALM solutions to accelerate your application development
COMMON:  Join us at the 2007 conference, April 29 – May 3, in Anaheim, California
Maximum Availabilty:  Secure, cost-effect, real-time iSeries replication software

 

Books on Sale at the IT Jungle Store: 30 Percent Off for 30 Days

The System i Pocket RPG & RPG IV Guide: List Price, $69.95; Sale Price, $49.00
The iSeries Pocket Database Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket Developers' Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket SQL Guide: List Price, $59.00; Sale Price, $41.00
The iSeries Pocket Query Guide: List Price, $49.00; Sale Price, $34.00
The iSeries Pocket WebFacing Primer: List Price, $39.00; Sale Price, $27.00
Migrating to WebSphere Express for iSeries: List Price, $49.00; Sale Price, $34.00
iSeries Express Web Implementer's Guide: List Price, $59.00; Sale Price, $41.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95; Sale Price, $56.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00; Sale Price, $62.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00; Sale Price, $34.00
WebFacing Application Design and Development Guide: List Price, $55.00; Sale Price, $38.00
Can the AS/400 Survive IBM?: List Price, $49.00; Sale Price, $34.00
The All-Everything Machine: List Price, $29.95; Sale Price, $21.00
Chip Wars: List Price, $29.95; Sale Price, $21.00

 

The Four Hundred
IBM Upgrades System i5 Disk Controllers, Adds Enclosures

IBM and ISVs Launch VIP Program to Reinvigorate System i5 Sales

Sundry Other System i5 Announcements

The X Factor: One Socket to Rule Them All

The Linux Beacon
PA Semi Samples Homegrown Dual-Core Power Chip

Intel, AMD Push and Pull for X64 Market Share

VMware, XenSource Launch Virtualization Bundles

The X Factor: One Socket to Rule Them All

Four Hundred Stuff
RevSoft Pushes 'Lights On' Approach to Systems Automation

Oracle Cools on Fusion, Focuses on Current ERP

LogLogic Aims to Ease Log Data Crunch

Halcyon Updates Systems Management Tools

Big Iron
IBM Buys Softek to Bolster Data Migration Offerings

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
February 3, 2007: Volume 9, Number 5

January 27, 2007: Volume 9, Number 4

January 20, 2007: Volume 9, Number 3

January 13, 2007: Volume 9, Number 2

January 6, 2007: Volume 9, Number 1

December 30, 2006: Volume 8, Number 50

The Windows Observer
Windows Vista: It's All About the Security

Gates, Ballmer Wow NYC with Vista Windows, Office 2007 Shindig

Microsoft Profit Sinks 28 Percent in Vista's Shadow

AMD: Native Quad Core Opteron Will Best Intel Quasi Quads

The Unix Guardian
AMD: Native Quad Core Opteron Will Best Intel Quasi Quads

IT Salaries Rise by 5.2 Percent in 2006, Dice Survey Says

IBM Bags System p5 Super Deals, But Is Power6 Slipping?

Ask TPM: The Economics of Open Source Software

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

THIS ISSUE SPONSORED BY:

WorksRight Software
SEQUEL
RPG & DB2 Summit



TABLE OF CONTENTS
Opportunities, Not Problems!

SQL Cross Platform Interoperability: The Proper Function

Admin Alert: Selectively Sending Break Messages to Active Users

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Julian Date file

Interesting resource and apparently free!

Alert emails from the iSeries

CL Question on Overrides

Entry parms getting overlayed--RPG





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

Privacy Statement