|
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
|
|
|
HIGH AVAILABILITY CASE STUDY:
When the tornados hit, TheBANK of Edwardsville was prepared.
Spring's balmy 70-degree weather brought several tornados to St. Claire County, Illinois. One powerful storm left dozens of businesses and residents without electricity for nearly a week.
While thousands of people were caught by surprise, TheBANK of Edwardsville was not.
Read the complete story here.
|
|
|
Developers Don't Despair: Virtualize Your PC
by Michael Sansoterra
Today's developers often wear many hats: programmer, operator, help desk, and database administrator. Furthermore, they often support software on many operating systems (various versions of Windows, Linux, Unix, and so forth) with various versions of application software (Microsoft Office 97 or 2003, ERP clients, and so on) using a variety of developer tools (Visual Studio, Visual Studio .NET, Websphere Development Studio Client, Delphi, and others). READ MORE >
|
|
|
Unusual But Logical SQL Sorting
Hey, Ted:
A physical file that I've loaded with data from another system has a department field that I would like to use for sorting. The department field contains a description, rather than a code. I need to sort the data on the description, but not in alphabetical order. That is, I want a certain department to appear first, then a certain department to appear next, and so on. The only way I know to pull this off is to create a little table that lists the departments and the order each one appears in the sort, but I do not like to clutter up the database with little one-use files. Do you have another idea? READ MORE >
|
|
|
Alliance AES/400 Database Field Encryption
· Encrypt credit card, social security, pin numbers and other sensitive data.
· Easy to use with RPG or COBOL - sample code included.
· Get compliant - SOX, Privacy notification, GLBA, Etc.
· Free 30 day trial. Fully functional software - Not a demo.
Find out more at www.patownsend.com
Visit us for 30-day trial
Deploy. Run. Manage. Succeed.
|

|
|
|
Admin Alert: One Common Cure for SQL0901 Package Errors
by Joe Hertvik
The SQL0901 error is an incredibly frustrating error that occurs with i5 ODBC, OLE DB, and JDBC connections. Because SQL0901 is a general SQL error, it can be difficult to diagnose and harder to solve. This week I will look at one specific SQL0901 scenario, where the failure occurs inside SQL's extended dynamic package support, and I will show you how to deal with this error in an i5 environment. 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
|
September 9, 2006: Volume 8, Number 34
September 2, 2006: Volume 8, Number 33
August 26, 2006: Volume 8, Number 32
August 19, 2006: Volume 8, Number 31
August 12, 2006: Volume 8, Number 30
August 5, 2006: Volume 8, Number 29
July 29, 2006: Volume 8, Number 28
|
|