|
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.
|
|
|
INSERT to Overlay Positions in a Character String
by Skip Marchesani
In V5R3, IBM simplified the manipulation of character stings with the implementation of the INSERT and REPLACE functions in SQL. INSERT allows the positional insertion of one or more characters into a string and REPLACE scans for all occurrences of a target string and overlays or replaces the target string with a replace string. This article will discuss INSERT, and a future article will discuss REPLACE. READ MORE >
|
|
|
Emulate RPG's Pessimistic Locking in SQL
Hey, Mike:
I'm writing a Java program to replace several RPG programs that access unjournaled database files. The current programs all use the same logic: obtain a lock on a record, allow the user to make zero or more changes on various screens, then save the changes (potentially not changing anything). I need to make my Java program behave like the original RPG programs. 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: Porting an Image Catalog Between Power i Boxes using FTP
by Joe Hertvik
In a recent article about creating and using image catalogs in lieu of CDs and DVDs for i operating system installations and upgrades, I didn't discuss how to move image catalogs between different i/OS partitions that can be located many miles or time zones apart. To plug that hole, this issue I present two simple programs that enable you to move pre-loaded image catalogs between systems. 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
|
|
|
|
|
