|
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
|
|
|
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
|
|
|
Properly Placed Procedures
Hey, Ted:
I like your IIF function. As you stated, it would be nice to replace five lines of code with one. However, I don't want to include all the subprocedure code in every program that uses IIF. Can you give instructions on how to make this a real function or service program? READ MORE >
|
|
|
V5R3 SQL Insert Improvement
by Ted Holt
SQL's INSERT command adds records to a table (physical file) or view (logical file). There are three forms of INSERT. The VALUES form allows you to create a record from constants. For example, assume a table PLANT with two columns (fields)--ID and NAME. 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 1
by Joe Hertvik
i5, iSeries, and AS/400 machines have always featured best-in-class security. But that security doesn't mean much if users can add, update, and delete records at will or if a user can execute a program he should be restricted from running. To prevent these kinds of security violations, it's worth examining how i5/OS provides default library and object access to public users (*PUBLIC) and the problems those defaults present. These problems include undermining system security and the risk of exposing sensitive data and programs to unwanted access. 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, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
Four Hundred Guru
|
|
