fhg
Volume 7, Number 33 -- September 26, 2007
Sponsored By
HELP/SYSTEMS

Discover Robot/SECURITY, the i5/OS security monitoring and auditing software, from Help/Systems

 

                    · Profile Exchange
                    · Exit Point Monitoring
                    · System Authority Auditing
                    · QAUDJRN Monitoring
                    · System Security Analysis

 

Robot/SECURITY is the only security software that combines five critical System i security tools in one package.

 

Visit our Web site at http://www.helpsystems.com/400g-sec/
to learn more about Robot/SECURITY.


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


Weird SQL UNION Results
Hey, Ted:

I was intrigued by your article "Have Your Cake and Eat It, Too." I decided to try your tip with some of my own data. The resulting data set had an anomaly in it. The system omitted a row of input, yet the total was still correct. Why? READ MORE >

A Snippet Above the Rest
by Paul Tuohy

You all know that a lot of code consists of similar patterns. In my previous article "Be Content with Content Assist," I explained how Content Assist could be used to insert a standard piece of code. This is well and good, but it only applies to free form RPG or COBOL. What about fixed form specs or code that need some alteration? READ MORE >



Sponsored By
COMMON

COMMON Focus 2007 will be our first annual workshop conference event, featuring three days of intense, focused education. It will be held October 14 - October 17, 2007 in Columbus, Ohio.

 

This smaller, more intimate event will feature 15 in-depth, all-day workshops in both lab and lecture-style formats, offering a wide range of topics, and will also include a tabletop-style exhibition area.

 

Learn more at www.common.org/focus




Admin Alert: What Vendors Want to Know (and How to Get It)
by Joe Hertvik

When purchasing i5/OS third-party software, vendors may request system control information for the partition their products will be installed in. This information is used to create unique licensing keys that must be installed with the product for piracy prevention. Unfortunately, IBM doesn't have one screen to find vendor-required system information. To remedy that fault, this week I provide a roadmap for locating common vendor information. 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

COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
looksoftware:  Stop recoding with end-to-end modernization solutions
NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

 

 

IT Jungle Store Top Book Picks

The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' 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
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
SAP Plants Its Flag in Mid-Market Territory with SaaS Apps

A1S Is to Applications What AS/400 Was to Systems

EGL: At Least It's Not Java, But It Ain't RPG, Either

As I See It: Shocking

The Linux Beacon
Canonical, VMware Create Skinny Linux for Virtual Appliances

HP Engineers New Blade Server Box for SMB Shops

SCO Files for Bankruptcy Protection

Transitive Rejiggers Emulation Software, Adds Partners

Four Hundred Stuff
Windows Vista Poses Challenges to Emulation Vendors

NetCustomer Capitalizes on Dissatisfaction with Oracle

Infor Provides Details on SOA Roadmap

Microsoft Ships BizTalk Server R2

Big Iron
Leverage

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
September 15, 2007: Volume 9, Number 37

September 8, 2007: Volume 9, Number 36

September 1, 2007: Volume 9, Number 35

August 25, 2007: Volume 9, Number 34

August 18, 2007: Volume 9, Number 33

August 11, 2007: Volume 9, Number 32

The Windows Observer
Microsoft Loses Antitrust Appeal in European Court

In Search Of a More Secure Internet

Sun and Microsoft Go All the Way with Windows

HP Engineers New Blade Server Box for SMB Shops

The Unix Guardian
SCO Files for Bankruptcy Protection

Sun and Microsoft Go All the Way with Windows

SAP Plants Its Flag in Mid-Market Territory with SaaS Apps

As I See It: The Dons of Dialogue

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

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
COMMON



TABLE OF CONTENTS
Weird SQL UNION Results

A Snippet Above the Rest

Admin Alert: What Vendors Want to Know (and How to Get It)

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
What's coalesce good for?

Duplicated printer files

Urgent Help Needed--Limit the result set in SQL stored procedure

Problem with "cpyfrmimpf"

FNDSTRPDM Output Member Name to *OUTFILE





 
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