fhg
Volume 9, Number 24 -- July 22, 2009
Four Hundred Guru is taking a hiatus next week. We will resume publishing on August 5.
Sponsored By
HELP/SYSTEMS


     SEQUEL
     IBM® System i® Data Access Made Easy

 


  · Complete management access to critical data
  · Easy to use by IT and end users
  · Automated data access and display
  · Comprehensive BI package: reports, tables,
     key performance indicators, and dashboards
  · System i-centric for real-time data analysis
  · Expert support and training


 

Click here for a FREE Information Kit!



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


Circumventing Two Limitations of CPYTOIMPF
by Ted Holt

I deem it grand of IBM to give us great tools that relieve us of the need to write programs to accomplish mundane, quotidian tasks. The Copy to Import File (CPYTOIMPF) command is such an animal. However, nothing's perfect on this planet, and CPYTOIMPF is no exception. Here are two annoyances or problems (depending on your point of view), and how to get around them.. READ MORE >

Comparing RPG and SQL Functionality
Hey, Mike:

Is there a book on how RPG operation codes and built-in functions translate to SQL? I'm trying to leverage my RPG coding skills to write logic in a DB2 stored procedure. That is, I know exactly what to do in RPG, but I don't know the SQL equivalent. READ MORE >





Admin Alert: Treating IFS Objects Like Stream File Objects
by Joe Hertvik

Even though AS/400 Integrated File System (AS/400 IFS) folders can contain the same type of stream file data as network file servers do, many administrators still don't understand how to perform basic file functions such as checking out and checking in files, and changing properties for an AS/400 IFS Root (/) file object. This week, let's review some basic but important functions you can perform on IFS stream file objects. 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: Erwin 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

Profound Logic Software:  Tune in to Profound Logic TV for FREE educational videos and tips
Maximum Availability:  *noMAX - Subscription edition now available (US & UK)
COMMON:  Celebrate our 50th anniversary at annual conference, May 2 - 6, 2010, in Orlando

 

 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.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 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
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95


 
The Four Hundred
Sundry Power Systems i Storage Announcements

Servers Slammed in IBM's Second Quarter

IBM Sunsets More Power Systems Features

As I See It: Injured Wing

Fincham Rides Point for iManifest EMEA

Four Hundred Stuff
IBM Kills Secure Perspectives Tool

Bicycle Seller Rolls with Electronic Vaulting Backup and DR from UCG

JDA Shares Plans for E3 Fulfillment Products

Quadrant Adds a Slew of Updates to Forms Software

Kisco Gives i OS Auditing Tool a Web Makeover

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

System i PTF Guide
July 18, 2009: Volume 11, Number 29

July 11, 2009: Volume 11, Number 28

July 4, 2009: Volume 11, Number 27

June 27, 2009: Volume 11, Number 26

June 20, 2009: Volume 11, Number 25

June 13, 2009: Volume 11, Number 24

TPM at The Register
Intel slashes prices on desktop, server chips

Dell partner CIT dodges bankruptcy

IBM peddles FCoE switches from Brocade and, yes, Cisco

HP chases Sun Oracle server shops

IBM: Revenues down, profits up in Q2

Sun shareholders approve Oracle deal

PCs do better than expected in Q2

The curious case of Sun's hardware biz

Bull to do homegrown Nehalem EX chipset

Nehalem and Atom save Intel's Q2 cookies

Microsoft hosts Feynman lecture series

Supers get greener

IBM drops Istanbuls into big Opteron box

Sun: Q4 sales to drop by a third, sees deeper losses

THIS ISSUE SPONSORED BY:

Help/Systems
WorksRight Software
Guild Companies



TABLE OF CONTENTS
Circumventing Two Limitations of CPYTOIMPF

Comparing RPG and SQL Functionality

Admin Alert: Treating IFS Objects Like Stream File Objects

Four Hundred Guru

BACK ISSUES




 
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-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement