|
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
|
|
|
If you're like most businesses, you're in a race for fast, easy access to information. That includes information from multiple databases, like DB2, Microsoft SQL Server, Oracle, and MySQL.
The white paper, The Race To Access Enterprise Data, describes the goals you need to achieve and the hurdles you'll face.
And, it reveals how quickly and easily SEQUEL can deliver the data you need, in the format you prefer, anywhere.
Follow this link to download.
|
|
|
REPLACE to Replace Characters in a String
by Skip Marchesani
In V5R3, IBM simplified the manipulation of character strings with the implementation of the INSERT and REPLACE functions in SQL. INSERT allows the positional insertion of one or more characters in a string and REPLACE scans for all occurrences of a target string and overlays or replaces the target string with a replace string. INSERT was discussed in my previous article, and now I will discuss REPLACE. READ MORE >
|
|
|
|
Join the Gurus at the Summit!
Rise to the i can . . . can you? challenge at the RPG & DB2 Summit this Oct 17-19 in St. Louis.
Upgrade your skills - and your career - with the latest on SQL, RPG & the Web, RPG IV, PHP, mobile apps, DB2 for i, SQL tuning, modern tools and more! Learn practical, use-it-today tips and techniques from top experts Susan Gantner, Jon Paris, Paul Tuohy, Skip Marchesani, Scott Klement, Mike Cain, Kent Milligan in a highly interactive, fun environment.
Click for sessions. Register by August 26 for just $1095 - save $300!
|
|
|
|
Admin Alert: A Starter Program to Find Damaged Objects in i OS 6.1.1
by Joe Hertvik
After a damaged object prevented a full system production backup in my shop, I was asked to devise a technique for detecting damaged objects on the system. This week, I'm presenting my starter CL program that looks for damaged objects as a template for approaching the issue, in the hopes that others can add to and expand on this code. 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
September 25, 2010: Volume 12, Number 39
September 18, 2010: Volume 12, Number 38
September 11, 2010: Volume 12, Number 37
September 4, 2010: Volume 12, Number 36
August 28, 2010: Volume 12, Number 35
August 21, 2010: Volume 12, Number 34
|
|
|
|
|
