fhg
Volume 7, Number 11 -- March 21, 2007
Sponsored By
PROFOUND LOGIC SOFTWARE

RPGsp - True Modernization

 

It isn't true modernization unless
it's done with RPGsp.

 

· Convert to true Web apps or Screen-scrape
· Build Web 2.0, AJAX, Dashboards, and more
· Use Visual Debugger, Designer, Wizards,
   and many other tools

 

All built into a powerful IDE.

 

Give Modernization with RPGsp a try

 

www.RPGsp.com


Sponsored By
HELP/SYSTEMS

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


iSeries Navigator Job Monitor
By Bruce Guetzkow

As the only developer in a small company, I try to find ways to make the computer work so I don't have to. We don't have an operator and no one is dedicated to monitoring the QSYSOPR message queue, so when problems happen, I need a way to be notified, wherever I am. I've tried a couple of programming solutions that captured information from the WRKACTJOB screen, but there were always conditions that I didn't anticipate and weren't captured by those methods. READ MORE >

Reader Feedback on Using the SQL SET OPTION Statement
Hey, Michael:

I just read your article about the SET OPTION statement. Here are some minor comments about the OPTION CLOSQLCSR. There is a difference between closing a SQL cursor with the SQL statements CLOSE or COMMIT and closing a cursor at either *ENDMOD or *ENDACTGRP (or the other options for non-ILE programs). 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




Changing ODBC Sign-On Pop Up Values
by Joe Hertvik

I have a new user starting, and I need to change the default user ID sign-on information that ODBC uses to connect her machine to our i5 partition. This computer was previously assigned to another user, and that user ID keeps appearing in the Signon to iSeries box whenever the computer starts an ODBC connection. How do I change the default user ID that ODBC uses for an i5 connection? 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 2007 conference, April 29 – May 3, in Anaheim, California
Databorough:  X-analysis is the world leader in AS/400 application retro-documentation
Patrick Townsend & Associates:  Alliance AES/400 - database field encryption

 

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
IBM Pays for System i5 Video Viral Marketing

System i Shops Plenty Annoyed About Missing WDSc Features

It Was Inevitable: IBM Jacks Maintenance Fees on Midrange Gear

Mad Dog 21/21: The China Spin Drone

The Linux Beacon
Red Hat Integrates and Simplifies with RHEL 5

The Feeds and Speeds of Red Hat Enterprise Linux 5

Transaction Processing Council Launches TPC-E Benchmark

Mad Dog 21/21: The China Spin Drone

Four Hundred Stuff
Vision Committed to Developing ORION

Infor Advocates Open Approach to SOA

IBM to Distribute Info Builders' iSeries BI Tools

LANSA Puts RAMP to the Test

Big Iron
Putting the z in College Degrees

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
March 17, 2007: Volume 9, Number 11

March 10, 2007: Volume 9, Number 10

March 3, 2007: Volume 9, Number 9

February 24, 2007: Volume 9, Number 8

February 17, 2007: Volume 9, Number 7

February 10, 2007: Volume 9, Number 6

The Windows Observer
Windows Server 2003 SP2 Released by Microsoft

Microsoft Unveils 'Duet'-Like Interface, New ERP Releases

Intel Delivers Low-Power, Quad-Core Xeon Chips

VoIP's Future Rosy, Microsoft Biz Chief Says

The Unix Guardian
Intel Delivers Low-Power, Quad-Core Xeon Chips

Server Makers Have $5.3 Billion Bumper Crop in Q4 in Europe

Lawson Updates ERP, Unveils SaaS Plans at User Conference

As I See It: The Digital Life

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

THIS ISSUE SPONSORED BY:

Profound Logic Software
Help/Systems
WorksRight Software



TABLE OF CONTENTS
iSeries Navigator Job Monitor

Reader Feedback on Using the SQL SET OPTION Statement

Changing ODBC Sign-On Pop Up Values

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Compiler Directives and Control Specifications

PTF for WDSC 7.0

How to collect the object authorities in a PF

VARPG on Windows Server

Window subfile with another input capable record format





 
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