|
FREE Webinar: April 27, 9 a.m. CT
"Track Key Business Metrics at a Glance"
Join us for a live, one-hour demonstration of SEQUEL, the leading data access and analysis solution for IBM i servers.
We'll show you how easy it is to create graphical executive dashboards to track the Key Performance Indicators that managers and other executives can use to make fast, effective business decisions based on the latest information.
Follow this link to find out more.
|
|
|
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
|
|
|
A View of a View of a View
by Ted Holt
One of the traits of a good database is that users are not forced to perceive the structure of the data as it is stored in the tables, but are free to perceive the data in ways that are meaningful to them. Today I share an SQL technique that achieves that goal. (No, you can't do this with logical files.) READ MORE >
|
|
|
SQL Bar Charts
Hey, Ted:
A while back I had a problem that appears to be quite common, but just rare enough that it's a little challenging when it hits you. Often in our roles as database administrators we need to determine various figures, such as how many key values in a table are used up in case we need to extend the field. Or sometimes we just to provide a statistical representation of data. What I needed was to produce a histogram using SQL. READ MORE >
|
|
|
COMMON's 2011 Annual Meeting & Exposition will take place May 1 - 4, 2011, in Minneapolis, Minnesota.
This premier event provides extensive education on Power Systems topics, invaluable networking opportunities, an Exposition of nearly 80 leading exhibitors, and a chance to gain a COMMON Certification.
It continues to be the most cost-effective conference of 2011.
Learn more and register at www.common.org/annualmeeting
|
|
|
|
Admin Alert: The Four Faces of Software Vendors During a Hardware Upgrade
by Joe Hertvik
For an upcoming hardware upgrade, I recently contacted all of our third-party software vendors to determine if they were going to increase our fees for running their software on a different machine. My mission was to determine: 1) Whether each vendor would charge us for changing hardware; and 2) Would there be an increase in their yearly software maintenance fees? The results were intriguing and an interesting window on the i/OS software world. 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
|
|
|
|
|
