|
Demand DBU
and get it for $10 a day!
When you need to get to your data NOW,
use DBU-on-demand and activate for
one day or for any number of days.
This is great for those "seldom touched"
systems without a database utility and a lifesaver in emergency database situations.
Use DBU for $10 a day anytime, anywhere!
Do it with DBU.
It's Server Proven and on IBM’s Roadmap!
Call us today to access DBU-on-Demand.
800.228.6318
www.DoDBU.com
|
|
|
SEQUEL can be used for virtually ALL data access functions on the iSeries.
A Windows-based user interface makes it easy to design queries and reports.
SEQUEL offers executive dashboards, drill-down data analysis and run-time prompts to deliver important iSeries data to managers and other non-technical users.
E-mail and FTP delivery let you deliver information to remote users and servers.
www.asc-iseries.com
|
|
|
Alternate SQL Row-Selection Criteria, Take 3
by Ted Holt
Two previous issues of this newsletter have presented ways to put two or more record-selection alternatives into one SQL query. I use these techniques often because they reduce or eliminate the need to clone programs. I recently learned another way to implement alternate record-selection criteria and would like to share it with you today. READ MORE >
|
|
|
Indicate Negative Numbers with Parentheses
Hey, Ted:
Thank you for a newsletter with information that is always interesting and useful. I enjoyed reading about your IIF function. Here is a function I wrote a few years back on V5R1. It returns a numeric value edited for displaying or printing that includes parenthesis when the value is negative. Our accountants prefer that negative numbers appear within parenthesis. The value returned contains two decimals, as this function is primarily used for monetary amounts. READ MORE >
|
|
|
COMMON Spring 2006
IT Education Conference & Expo
Minneapolis, Minnesota
March 26-30, 2006
Register Now!
Attendees can choose from a multitude of sessions and hands-on labs focusing on business strategy, networking, development and systems management with a featured educational focus on Services Oriented Architecture. Explore the latest technologies in the industry's largest iSeries-related Expo and network with peers at COMMON social events.
www.common.org
|
|
|
|
Admin Alert: Limiting *PUBLIC Access to i5/OS Objects, Part 2
by Joe Hertvik
In last week's column, I discussed how the default security settings in i5/OS allow *PUBLIC users to automatically modify data and run programs on an i5, iSeries, or AS/400 machine. Left unchanged, these settings can undermine system security and expose sensitive data and programs to unwanted access. This week, I'll look at some of the cures for this problem and their potential pitfalls. 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
|
|
