fhg
Volume 7, Number 15 -- April 18, 2007
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


Sponsored By
PATRICK TOWNSEND & ASSOCIATES

Alliance AES/400
Database Field Encryption

 

· Encrypt credit card, social security,
   pin numbers and other sensitive data.
· Easy to use with RPG or COBOL - sample code
   included.
· Get compliant - SOX, Privacy notification,
   GLBA, Etc.
· Free 30 day trial. Fully functional software -
   Not a demo.

 

Find out more at www.patownsend.com
Visit us for 30-day trial
Deploy. Run. Manage. Succeed.


Calling SQL Functions Directly From a High Level Language Program
Hey, Mike:

The Create SQL Function from the article SQL Cross Platform Interoperability: The Proper Function creates a CLE *srvpgm on the iSeries. Can this be accessed from an RPGLE program? If so, what would the prototype look like? I am not familiar with C and cannot get this to work, so far, on my own. READ MORE >

My Favorite Keyboard Shortcuts for RSE
by Susan Gantner

When using RSE for editing my CL, DDS, RPG or COBOL code, I find that I can save a lot of time by using keyboard shortcuts for functions that would otherwise require that I take my hands off the keyboard to use the mouse. So I thought I would share a few of my favorites. Many of the shortcuts I use are standard for other Windows-based applications that I also use for email, spreadsheets or text editing. READ MORE >



Sponsored By
COMMON

Customize your System i education
in 2007 with COMMON's
2007 Annual Conference & Expo,
April 29 - May 3, 2007,
in Anaheim, California.

 

This premier System i education and networking event provides invaluable learning and networking opportunities. It will offer over 500 sessions, more in-depth education, user-driven sessions, a greater emphasis on networking, and an extensive Expo.

 

Don't miss it!
www.common.org




Two Ways to Audit Your Backup Strategy
Hey, Joe:

Nice article on five things that kill backups. In regards to auditing backup results, however, I find it a little tedious to check joblogs as you recommended. I prefer to use the Display Log command for reviewing the system history log to check backup results. It's easy to spot missed objects from this display. I also like to use the Display Backup List command (DSPBCKUPL) for Sarbanes-Oxley compliance. 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
COMMON:  Join us at the 2007 conference, April 29 – May 3, in Anaheim, California
VAULT400:  Securely archive data with Instant Back-Up & 24x7 Recovery

 

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 Goes After Windows with User-Priced System i Servers

IBM Upgrades High-End System i5 Servers

Wheeling and Dealing to Move System i Iron

System i and the Web: Where We've Been and Where We're Going

The Linux Beacon
Canonical Updates Ubuntu Linux with 7.04 Release

Intel Details Future 45 Nanometer Chip Plans from Beijing

Dell, IBM Push Power-Saving Servers

As I See It: The Legacy

Four Hundred Stuff
Oracle Declares a 'Renaissance' for J.D. Edwards World

Shield Launches 'DR for the Masses'

IBM Addresses Object-Level Security with New Tool

More Details Emerge on Query/400's Java-Based Replacement

Big Iron
CA Tweaks Job Schedulers, Positions Them as Workload Automation

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
April 14, 2007: Volume 9, Number 15

April 7, 2007: Volume 9, Number 14

March 31, 2007: Volume 9, Number 13

March 24, 2007: Volume 9, Number 12

March 17, 2007: Volume 9, Number 11

March 10, 2007: Volume 9, Number 10

The Windows Observer
Vista's Security Honeymoon Is Over

'Longhorn' Nears the Gate

AMD Pushes Opteron Clocks to 3 GHz, Will Miss Q1 Revenue Targets

X4 Chipset from IBM Tuned for Tigerton Quad Core Xeon MPs

The Unix Guardian
Yen Explains Sun's Chip Strategy

Hello, New York? Buy IBM

Schwartz Blogs a Bit About the Dud Rock Chip on His Desk

As I See It: The Legacy

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

THIS ISSUE SPONSORED BY:

Help/Systems
Patrick Townsend & Associates
COMMON



TABLE OF CONTENTS
Calling SQL Functions Directly From a High Level Language Program

My Favorite Keyboard Shortcuts for RSE

Two Ways to Audit Your Backup Strategy

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
PASE application terminates when session is closed

Compare 2 PF values

Performance-Tuning SQL Views

Need 5 senior as/400 RPG positions for 12 month contract

iSeries Career training ideas





 
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