Sponsored By
 ADVANCED SYSTEMS CONCEPTS
|
|
Quoted from an experienced programmer
new to the iSeries (AS/400):
"The best thing about working on the AS/400 is using ASC's SEQUEL product."
If you're tired of the limitations imposed by Query/400 or ODBC-based query and reporting tools, you need SEQUEL. Discover how thousands of sites around the world have improved access to iSeries data using SEQUEL's Windows- and Web-interfaces. It's the one tool you can rely on for virtually all your iSeries data access needs.
FREE trial available.
Read More about SEQUEL
|
|
Sponsored By
 WORKSRIGHT SOFTWARE
|
|
600 Billion
That's how much a recent independent study estimated U.S. businesses spend on dirty data. How much of that 600 billion is spent by your company?
Cleanse your dirty ZIP Codes and mailing addresses with our software and save big bucks.
WorksRight Software, Inc.
Phone: 601-856-8337
E-mail: software@worksright.com
Web site: www.worksright.com
|
|
|
Calling CL Programs as Stored Procedures
Hey, Howard:
I have an Excel spreadsheet running a SQL statement that is retrieving data from an AS/400. Works great. But I need to cleanse the data before putting it in the spreadsheet. I have a CL program running on the AS/400; if you supply it with two dates (in MMDDYY format), it will filter the records, massage some data, and create a file called OQTD02PF. Once this file is created I want the SQL statement in Excel to run. Can I run a CL program passing parameters from the Excel spreadsheet? The spreadsheet has the dates on it already, in cells A1 and A2 on a sheet called source data.
READ MORE >
|
Guarantee Unique Key Values
Hey, Ted:
I agree that using surrogate keys causes more problems than it solves ["Pros and Cons of Surrogate Keys"]. Besides obscuring the key values, you need to have an application that creates the surrogate key, to ensure uniqueness among all of the related files.
READ MORE >
|
Reader Feedback and Insights: Soft-Coded Library Lists
Hey, Ted:
This regards adding library lists at runtime ["Hard-Coded Library List Woes"]. I would like to suggest a technique that we implemented in a project I worked on.
READ MORE >
WANTED: Sales Manager
Strong, profitable iSeries ISV is looking for an experienced, energetic Sales Manager to support sales strategy in North America and mentor our sales team to help them achieve greater success. Reporting to the CEO, you will also be part of the management team evolving our future sales strategy.
Qualified candidates must have a minimum of five years of software sales experience, ideally selling complex software, with at least two years in a managerial capacity. Working knowledge of iSeries and software management tools an added advantage. Excellent speaking, presentation and writing skills required, as well as the ability to motivate your sales team. Attractive salary and benefits package, commensurate with skills and background. Please respond with resume to jobs@softlanding.com .
AS/400 Security: Enemies at the Gate
The iSeries and AS/400 may have a rock solid reputation for security, but, trust us, that isn't the end of the story. Vulnerabilities exist, and the OS/400 fortress is not impenetrable. Watch for the Guild Companies Special Report on AS/400 Security coming August 19. Articles by iSeries security experts such as Pat Botz, Jim Fey, John Earl, Dan Riehl, and Mike Grant--each is presenting security topics at the Fall COMMON Conference and Expo--will give you access to the latest and most useful information on this vital topic. Don't miss our special report and visit the COMMON Web site for information on the security educational focus and registration information for the upcoming conference in Orlando, Florida, September 7-11.
|
