fhg
Volume 7, Number 3 -- January 24, 2007
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


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


Using the SQL SET OPTION Statement
by Michael Sansoterra

SQL's SET OPTION statement is a powerful way to control the parameters of the DB2 execution environment in which an SQL program runs. Using it properly will allow SQL code to execute consistently between different environments--including those thorny differences that often arise between green screen and client/server environments. Read on to find out why this statement is essential to embedded SQL programs and persistent stored modules (SQL based triggers, procedures and functions). READ MORE >

Legible PATH and CLASSPATH
by Ted Holt

One of the things I don't like about the Integrated File System (IFS) is its directory-based structure of untyped files. I consider the library system of strongly typed objects a much more robust architecture. Nevertheless, the IFS is reality and I have to deal with it. Here's a short and simple tip for reading those ugly, almost indecipherable PATH and CLASSPATH variables we have to put up with. READ MORE >



Sponsored By
VAULT400

            ·Off-Site, Encrypted, Compressed
            · Archived, Safe, Automated
            · Instant Back-Up, 24x7 Recovery
            · Starting at 100GB for less than
              $ 295 p/month

 

You will relax knowing your data on your System i (and other platforms) is securely archived with VAULT400 - knowing you saved a ton on your budget - knowing you can recover at anytime.

 

Request a Pricing Proposal and / or
Sign Up for a Free On-Line Briefing at
www.vault400.com/itj




Admin Alert: Updating Your System i5 for Daylight Saving Time Changes
by Joe Hertvik

In the Energy Policy Act of 2005, Congress changed Daylight Saving Time (DST) in the United States so that starting this year (2007) DST begins three weeks earlier than it did last year, on the second Sunday of March. Conversely, 2007 will also see Daylight Saving Time end one week later than last year, on the first Sunday in November. This week, I'll talk about how this change affects i5 shops. 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

Computer Keyes:  Rapidly convert *SCS printer files into black and white or full color PDF documents
Databorough:  X-analysis is the world leader in AS/400 application retro-documentation
COMMON:  Join us at the 2007 conference, April 29 – May 3, in Anaheim, California

 

The Four Hundred
Big Blue Readies Revamped Storage for the System i

IBM Closes Out 2006 With a Strong Fourth Quarter

Zend Describes Multiple Instances on i5/OS, Previews RPG Wrapper

Ask TPM: The Economics of Open Source Software

The Linux Beacon
OSDL and Free Standards Group Merge into the Linux Foundation

Sun, Intel Form Alliance for Xeon Servers and Workstations

IDC Says Global IT Spending Will Kiss $1.5 Trillion By 2010

The X Factor: Solaris Versus Linux Support Pricing

Four Hundred Stuff
IBM Lotus Adds Handles to Information Overload

Applied Logic Launches OS/400 Encryption Utility

BOSaNOVA Launches Four Thin Clients

GT Software Gives Web Service Smarts to Web-Enabled Apps

Big Iron
IBM Closes Out 2006 With a Strong Fourth Quarter

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
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

December 23, 2006: Volume 8, Number 49

December 16, 2006: Volume 8, Number 48

The Windows Observer
Microsoft Partners Begin Testing for Dynamics CRM 'Titan'

Aras Delivers Open Source PLM Software for Windows

Intel Delivers More Quad-Core Server and PC Chips

SGI and Microsoft Partner on Windows Supercomputer Clusters

The Unix Guardian
Sun Tapes Out Rock Sparc Chip, Gooses Clocks on Niagara Sparc T1

Sun Finally Gets Solaris 10 11/06 Update Out the Door

Unisys Broadens Oasis Open Source Software Stacks for Linux

Why the Number of Women in IT Is Decreasing

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

THIS ISSUE SPONSORED BY:

SEQUEL
WorksRight Software
VAULT400



TABLE OF CONTENTS
Using the SQL SET OPTION Statement

Legible PATH and CLASSPATH

Admin Alert: Updating Your System i5 for Daylight Saving Time Changes

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Scheduling a job to run in PASE

FTP from IFS folder

Populate fields with file

Compare source and object timestamps

Tracking spool file printing--pages printed, where printed





 
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