Newsletters   Subscriptions  Forums  Store   Career  Media Kit  About Us  Contact  Search   Home 
fhg
Volume 5, Number 44 -- November 30, 2005

Editing Numbers in CL, Take Two


Hey, Ted:


I just read Cletus' tip on the editing of numbers in CL procedures, called Editing Numbers in CL. I will add these techniques to my tool kit. As always, thanks for the great stuff. Here's another method I've used to remove leading blanks from numbers in CL.

--Russ


Russ's method uses a message description that has a four-byte binary variable. Here's how it works. (This following code is mine, not his, so any mistakes are also mine.)

Let's use the example from the previous article. Variable &CustOrders contains the number of orders that have been added to a database file. Our job is to load the number of orders, without leading blanks, into the &AlphaNum variable.

First, a few variable declarations.




dcl  &CustOrders   *dec      10 
dcl  &AlphaNum     *char     10 
dcl  &BinVar       *char      4 

Second, a message description that defines a four-byte binary variable.

CrtMsgf    Msgf(Qtemp/TempMsg)      
MonMsg     MsgID(CPF2112)           
AddMsgd    MsgID(TMP1001) Msgf(QTEMP/TEMPMsg) Msg('&1') +  Fmt((*BIN 4)) 
MonMsg     MsgID(CPF2412) 

The MONMSG message commands keep the CL procedure from erroring out during a rerun.


As before, variable &CustOrders has the number of orders. Convert the number of orders to binary format.

RtvMbrd    File(ORDERS) NbrCurRcd(&CustOrders)  
ChgVar     Var(%BIN(&BinVar)) Value(&CustOrders) 

Now, retrieve the message description into a CL variable. In the process, the system applies the number of orders to the message.

 RtvMsg     MsgID(TMP1001) Msgf(Qtemp/TempMsg) + 
             MsgDta(&BinVar) Msg(&AlphaNum)

At this point, &AlphaNum contains the number of records in the ORDERS file, left-adjusted.

Thanks to Russ for submitting this editing technique.

--Ted


RELATED STORY

Editing Numbers in CL

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


Technical Editors: Howard Arner, Joe Hertvik, Ted Holt,
Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, 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.


THIS ISSUE
SPONSORED BY:

Advanced Systems Concepts
WorksRight Software
Guild Companies


Four Hundred Guru

BACK ISSUES

TABLE OF
CONTENTS
Everything You Ever Wanted to Know About Converting Dates

Editing Numbers in CL, Take Two

Selectively Deleting OS/400 Spool Files


The Four Hundred
Domino on the iSeries: The Empire Can Strike Back

The Once and Future OS/400 Ecosystem

International Business Server, International Business Desktop

Mad Dog 21/21: Hasta La Vista, Budget

Four Hundred Stuff
QlikTech Targets iSeries Base with Business Intelligence App

Bytware Adds Disk Monitoring to MessengerPlus

Kisco Maintains Session Integrity, Security with ScreenSafer/400

Ipedo Seeks to Bridge Web Services with Business Intelligence

Four Hundred Monitor


Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc. (formerly Midrange Server), 50 Park Terrace East, Suite 8F, New York, NY 10034
Privacy Statement