For years, i5 shops have been using the old Query/400 tool as well as the myriad third-party application generators and report writers. The IBM Query products (I'm not sure what those IBM product names are anymore, but I'm sure they have the word "Query" in them) seem to be relegated to the end-user community.
Many AR and AP departments as well as other end-user departments use IBM's Query products or one of the more powerful and pervasive third-party options such as mrc's Productivity Series or BCD's ProGen Plus.
(Editor's note: For a list of query tools and report generators, click on the link to the MC Showcase Buyer's Guide. Look for Query Tools under Product Categories.)
What I'm wondering is why IBM doesn't offer a native, integrated interface that does simple Query-style reports that are output to the Web browser rather than to the green-screen. I could probably write it for them in a few weeks or months if prompted.
Today, creating a spool file as the output media for a report seems somewhat passé. Most the third-party tools, particularly those I mentioned, added Web output years ago, yet Query/400 (or whatever its called today) still has the same interface and output capabilities I first saw nearly 20 years ago. This type of limitation today is like limiting Query/400 to reading 80-column punch cards, which was the case when IBM first introduced the AS/400 back in the late 1980s.
OK, I just looked it up. I can say IBM has updated Query/400. They've done to it what they do best; they changed its name. It is now known as Query for i5/OS. Yippee!
I'm fortunate enough to have access to a third-party tool, mrc Productivity Series, on my i5, so I didn't realize Query/400 was so many decades behind the rest of the universe. Certainly, with hundreds of thousands of i5 shops out there, this product, BCD's product, or one of the other third-party tools should be offered as a standard-install feature with the operating system—displacing Query/400 (I mean Query for i5/OS), or IBM needs to spend a few dollars supporting a small team of a few developers to design and develop Query/2007.
Bob Cozzi is host of iSeriesTV.com, an audio and video podcast/netcast Web site dedicated to the iSeries/System i world. Bob is also the author of several books, including The Modern RPG IV Language and RPG TNT: 101 Tips 'n Techniques for RPG IV. He is also the producer of RPG World, an annual conference for RPG IV programmers.
Bob Cozzi is a programmer/consultant, writer/author, and software developer. His popular RPG xTools add-on subprocedure library for RPG IV is fast becoming a standard with RPG developers. His book The Modern RPG Language has been the most widely used RPG programming book for more than a decade. He, along with others, speaks at and produces the highly popular RPG World conference for RPG programmers.
MC Press books written by Robert Cozzi available now on the MC Press Bookstore.
 |
||
 |
|
RPG TnT Get this jam-packed resource of quick, easy-to-implement RPG tips! List Price $65.00 Now On Sale
|
|
||
 |
|
The Modern RPG IV Language Cozzi on everything RPG! What more could you want? List Price $99.95
Now On Sale
|
More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.
TRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now! Request Now.
Forms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.
Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online