|
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
|
|
|
HIGH AVAILABILITY CASE STUDY:
When the tornados hit,
TheBANK of Edwardsville was prepared.
Spring's balmy 70-degree weather brought several tornados to St. Claire County, Illinois. One powerful storm left dozens of businesses and residents without electricity for nearly a week.
While thousands of people were caught by surprise, TheBANK of Edwardsville was not.
Read the complete story here.
|
|
|
Kevin Juenemann's Quick Query Utility
Hey, Ted:
Your QF command works great when you want to see the raw data, but sometimes you need only some of the columns, or need to join files to get usable data rather than codes. Many of our customers don't have interactive SQL installed on their systems, so I created this utility and sent it to all our customers for those times a one-off report is needed quickly. READ MORE >
|
|
|
Remove Blank Lines from a Stream File
Hey, Ted:
Working with IFS files, especially those we get from other systems, greatly increases my appreciation of physical files. Opening a stream file is like opening a Christmas present--we never know what we'll get. Anyway, one source typically sends us stream files that often have blank lines in them, which messes up our process. Is there any way to delete those blank lines? READ MORE >
|
|
|
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.
|
|
|
|
Admin Alert: Changing Physical File Characteristics on the Fly
by Joe Hertvik
Many people don't realize that they can use the Change Physical File command to alter the field and key definitions of a physical file without having to recompile that file or to save and restore their data. This command can enlarge or shrink existing file fields, add new fields, delete old fields, or change file keys. This week, I'll explore this hidden feature of CHGPF, and discuss its advantages and its disadvantages. 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
|
September 30, 2006: Volume 8, Number 37
September 23, 2006: Volume 8, Number 36
September 16, 2006: Volume 8, Number 35
September 9, 2006: Volume 8, Number 34
September 2, 2006: Volume 8, Number 33
August 26, 2006: Volume 8, Number 32
August 19, 2006: Volume 8, Number 31
|
|
