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
 PROFOUND LOGIC SOFTWARE
|
|
Impress your users today with
RPG Smart Pages
Don't spend months building basic iSeries Web Applications!
The RPGsp Web Development Environment lets you build comprehensive data inquiries, file maintenance apps, and data forms in a matter of minutes!
And you can customize 100% of the functionality using native ILE RPG.
Download RPG Smart Pages (RPGsp) and start creating powerful browser apps today!
|
|
|
Deciphering Audit Journal Codes
Hey, David:
Our audit group determined that, based on the Sarbanes-Oxley Act of 2002, we need to start tracking IT access of production objects. We are trying to meet their requirements for an internal control structure and procedures related to financial reporting. First, we removed access to production libraries for most IT staff, then turned on object auditing for all objects in those libraries. Next, we turned on auditing for objects read and changed, along with action auditing for adds, deletes, and object management for all of IT.
READ MORE >
|
How to Call a Stored Procedure from Excel
by Howard F. Arner, Jr.
Last week I explained how to call CL programs as stored procedures. This week I will show you how to write an Excel spreadsheet macro that calls a stored procedure. This is fun stuff, and it shows the power of VBScript in harnessing the capabilities of your iSeries.
READ MORE >
|
Attention Midrange Guru Newsletter Subscribers
Some things really make you appreciate the reliability of the AS/400. Take my recent e-mail problems, for example. On about July 25, my e-mail client refused to let me send mail. I have installed a different e-mail client and everything is working again, but for about 10 days I had to use a Web-based e-mail interface to send e-mail.
I received some of my e-mail, but not all of it. If you e-mailed me between July 25 and August 7, and you still have the message in your outbox, or can remember it, please resend your e-mail to tholt@itjungle.com.
I greatly appreciate the questions, tips, insights, and feedback you send me, because your e-mail is what has made Midrange Guru successful. As always, I will try to acknowledge, respond to, and answer as much of your e-mail as I can.
--Ted Holt
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.
|
