fhg
Volume 10, Number 26 -- September 8, 2010

Avoid an Unnecessary CPYF Error

Published: September 8, 2010

by Ted Holt

Hey, IBM i Professional:

I've heard it said that it's the little things that kill you. Maybe so. I am certain that little errors in computer programs can ruin a good night's sleep. Today's tip is an easy one that I've published before, but not in this newsletter. I'm running it today because an FHG reader recently told me that this simple, easily avoided error had occurred in the shop where she works. Everyone who writes CL programs needs to know this one.

The malfunctioning program had a Copy File (CPYF) command that looked like this:

CPYF FROMFILE(AAA) TOFILE(BBB) MBROPT(*REPLACE)

This command is an accident waiting to happen. A command like this might run perfectly for years, but one day something changes (maybe it's a change to the way the organization does business), and the command fails. Everybody is shocked, amazed, and astounded that software that worked well for so long suddenly doesn't work anymore.

The CPYF works fine as long as AAA is not empty. The contents of AAA replace BBB. But when the day finally comes that AAA contains no data, the CPYF command fails, sending two messages in the process:

  1. Diagnostic message CPF2869--Empty member AAA in file AAA in library SOMELIB is not copied.
  2. Escape CPF2817--Copy command ended because of error.

Here are two simple ways to avoid this error:

1. Clear the receiving file and use MBROPT(*ADD).

CLRPFM  FILE(BBB)
CPYF    FROMFILE(AAA) TOFILE(BBB) MBROPT(*ADD)

2. Monitor for the escape message and clear the receiving file.

CPYF    FROMFILE(AAA) TOFILE(BBB) MBROPT(*REPLACE)
MONMSG  MSGID(CPF2817) EXEC(CLRPFM BBB)  /* AAA IS EMPTY */

Both methods ensure that BBB looks just like AAA after the copy. Both methods ensure that this CPYF won't get you out of bed at 3 a.m. if AAA turns up empty some day.

I should make one last comment. I assume that the programmer's intention is to create a duplicate of a file. That is, if the From file is empty, then the To file should also end up empty.

But an empty From file may or may not be an error. For example, if the From file contains inventory adjustment transactions, and we didn't have any inventory adjustments that day, then clearing the To file is appropriate.

But suppose the From file is the customer master file. If that file is empty, it may mean that someone accidentally cleared the file. The CL program needs to raise an alert. This tip is not applicable when the From file is not supposed to be empty.




                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
WORKSRIGHT SOFTWARE

Do you need area code information?
Do you need ZIP Code information?
Do you need ZIP+4 information?
Do you need city name information?
Do you need county information?
Do you need a nearest dealer locator system?

We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

Just call us and we'll arrange for 30 days FREE use of either
ZIP/CITY or PER/ZIP4.

WorksRight Software, Inc.
Phone: 601-856-8337
Fax: 601-856-9432
E-mail: software@worksright.com
Web site: www.worksright.com


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

PowerTech:  FREE Webinar! Protect IBM i Data from FTP, ODBC, & Remote Command. Sept 15, 10 am CT
looksoftware:  RPG OA & Beyond Webinar. Sept 28 & 29. Enter to win an Amazon Kindle™
COMMON:  Join us at the Fall 2010 Conference & Expo, Oct. 4 - 6, in San Antonio, Texas


 

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
Entry IBM i Server Deals Greased With License Discounts

Prices Jacked on Power Systems Tape Drives and Expansion Drawers

The Server Racket Strengthens in Q2, But Will It Hold?

Mad Dog 21/21: Craft Nouveau

IDC Raises Global IT Spending Projections for 2010

Four Hundred Stuff
MKS Offers Full Support for IBM i 7.1 in ALM Tool

Vanguard Adds Graphical Workflow Features to IBM i Imaging Solution

Valid and TGS Gang Up on Buddy Punchers

Quantum Adds Fibre Channel to Midrange De-dupe Boxes

CCSS Cracks Down on IBM i Jobs with Excessive I/O

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

System i PTF Guide
September 4, 2010: Volume 12, Number 36

August 28, 2010: Volume 12, Number 35

August 21, 2010: Volume 12, Number 34

August 14, 2010: Volume 12, Number 33

August 7, 2010: Volume 12, Number 32

July 31, 2010: Volume 12, Number 31

TPM at The Register
IT workers getting back to work - sort of

Semi biz starts to cool off

HyTrust takes auditing, monitoring to the clouds

MokaFive outs bare-metal PC hypervisor

Cray and SGI push upgrades to latest supers

Gartner chops PC shipment forecasts for 2010

SGI bleeds less than expected

Xsigo rejiggers virtual I/O director for Ethernet

Big Blue finally punts an Opteron 6100 server

Project Horizon: VMware's plan to restitch the desktop

Retired joint chiefs chairman dons a Red Hat

Citrix eats VMLogix for self-service clouds

THIS ISSUE SPONSORED BY:

SEQUEL Software
WorksRight Software
inFORM Decisions


Printer Friendly Version


TABLE OF CONTENTS
Get Thee to the Web, Part 1

Avoid an Unnecessary CPYF Error

Admin Alert: Placing Additional Restrictions on i/OS Passwords

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

Privacy Statement