fhg
Volume 8, Number 15 -- April 16, 2008
Sponsored By
HELP/SYSTEMS



Camp Help/Systems

 

               · Exclusively for System i users
               · Automated Operations
               · Business Intelligence
               · Hands-on pre-camp workshops
               · Learn from the experts
               · Learn from other users
               · Maximize your ROI

 


Click Here




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


More about SQL and Logical Files
by Ted Holt

Last week I advised you to avoid referencing logical files in SQL queries. This week I have a little more information for you regarding SQL and its love-hate relationship with logical files. READ MORE >

Performance Advice from a Mysterious Friend, Part 5
by Ted Holt

Here's yet another performance tip from a fellow subscriber and System i consultant. Thanks for the feedback on previous tips. READ MORE >



Sponsored By
TWIN DATA

Full system console control for multiple AS/400s and LPARs from anywhere on your LAN, WAN, VPN, even over the Internet!

 

Perform certain System Maintenance and Configuration Procedures while in "Restricted State." Execute certain types of System Backups (SAVSYS) and respond to "System Console Only" messages.

 

Call for details about this
IP Console Solution:
800-597-2525
www.twindata.com




Admin Alert: V6R1 Changes for the i5/OS Administrator, Part 2
by Joe Hertvik

Last week, I started making a list of some of the more memorable V6R1 operating system enhancements for the i5/OS administrator. This week, I continue the list and point out some other V6R1 functions that you should be on the lookout for. 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 Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
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

LANSA:  It's Time for 4 days of education at the LANSA User Conference, May 4 – 7, in Orlando
MoshiMoshi:  An Interactive Experience for the System i Community. See Episode 1 now!
Vision Solutions:  A Rewind Button for i5 Data? Read the Whitepaper

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
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
The 64-Core Power6-Based Power 595 Starts to Roll in May

And Then There Was One: The New and Improved Power 570

Sundry Power Systems Announcements

As I See It: Goldilocks and the Zen of IT

Albert Simon Barsa, Jr., 1953-2008

The Linux Beacon
Oracle Touts Unbreakable Linux, Adds Clusterware Support

Ubuntu 6.10 Comes to the End of the Line

IBM Merges System p and System i Server Lines

IBM Launches Dual-Core Power6 JS12 Blade Server

Most CIOs Say 2008 IT Budgets Are Stable, So Far

Four Hundred Stuff
i-Based SCS500 Internet Phone System Now Available

Raz-Lee Flushes Out Fraud with Application Security Tool

ARCAD Looks to Aid Application Modernization Projects with Updated Software

BOSaNOVA Goes Semi-Rugged with New Thin Client

Quadrant Updates IntelliChief with Web Forms

Big Iron
HP Goes Visual with Application Modernization Tools

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

System i PTF Guide
April 12, 2008: Volume 10, Number 15

April 5, 2008: Volume 10, Number 14

March 29, 2008: Volume 10, Number 13

March 22, 2008: Volume 10, Number 12

March 15, 2008: Volume 10, Number 11

March 8, 2008: Volume 10, Number 10

The Windows Observer
New Batch of Windows Flaws Give Hackers a Roadmap to Riches

Yahoo Rebuffs Microsoft's Threat of a Hostile Takeover

AMD to Slash 10 Percent of Workforce Amid Sales Shortfall

Options to Microsoft's Hosted E-Mail Abound

Oracle to Support 10g on Windows Server 2008 by July

The Unix Guardian
The 64-Core Power6-Based Power 595 Starts to Roll in May

HP Rejiggers HP-UX 11i Packaging as Update 2 Ships

Sun Gangs Up Sparc T2+ Chips with Maramba Servers

The Power 575: Grandfather of the Multi-Teraflops Power7 Monster

Most CIOs Say 2008 IT Budgets Are Stable, So Far

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

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Twin Data



TABLE OF CONTENTS
More about SQL and Logical Files

Performance Advice from a Mysterious Friend, Part 5

Admin Alert: V6R1 Changes for the i5/OS Administrator, Part 2

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
Al Barsa passed away

Copying recs from a subfile to a file and keeping highlights

Imbedded SQL

CPYFRMSTMF problem

CPYTOIMPF problem

Table Transferfrom OS400 to Windows





 
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