|Editors:||Ted Holt||Managing Editor:||Mari Barrett|
|Howard Arner||Technical Editor:||David Morris|
I have recently started using Run SQL Statement (RUNSQLSTM) and have saved myself a lot of time. Instead of taking hours to develop an RPG program, I can whip up a functionally equivalent SQL statement in a few minutes. However, I have one slight problem. RUNSQLSTM produces a status report that prints out on the users' printers. They are annoyed, and it's a waste of paper. How can I keep these reports from printing?
You would probably benefit from creating an output queue, say QUSRSYS/GARBAGE, to which you could direct unwanted output. You can add a job schedule entry (ADDJOBSCDE) to clear the queue automatically each day.
To direct the output of RUNSQLSTM to the new garbage queue, issue the Override with Printer File (OVRPRTF) command for file QSYSPRT, as the following CL code illustrates:
OVRPRTF QSYSPRT OUTQ(QUSRSYS/GARBAGE)
To unsubscribe, change your email address, or sign up for any of Guild Companies, Inc's free email newsletters, visit http://www.itjungle.com. Hit the SUBSCRIBE button on the homepage and it will lead you to our online subscription system.
When you sign up for one of our e-newsletters, you can be assured that your e-mail address will NEVER be sold to an outside company.
Please contact Timothy Prickett Morgan at
Phone: 212 942 5818
I want to dump Microsoft Windows entirely, but I still need good client connectivity. Is there a Linux desktop configuration well-suited for the iSeries and AS/400?
The two most prevalent desktop environments for Linux are GNOME (http://www.gnome.org) and KDE (http://www.kde.org). Of the two, GNOME is truly open source; whereas KDE is only partially open-source, but still free. KDE is a good option for those who want a desktop that has a look and feel similar to Windows.
As for connectivity, Linux has the latest and greatest--the various protocols that are at the heart of Unix. These protocols and the programs that use them are what the early Internet was built on and over the past decade they have been adopted for every relevant operating system in the world, including OS/400.
For a 5250 emulator, you can pick from several open source, shareware, and commercial emulation products. MochaSoft (http://www.mochasoft.dk) sells a popular shareware emulator. If you prefer an open source Linux solution, search for one on http://www.freshmeat.net. I'm currently using an open source emulator I found there.
One of the great things about the OS/400 community is that it is indeed a community. We may be all working from our cubicles, but we are all connected and trying to figure out how to best employ the computer technology at our disposal. There are more than a few ways to skin any cat, and if you have a clever and unique answer to a problem that one of our Midrange Gurus has solved, we'd love to hear from you. This newsletter is an open dialog, and we value your input as well as your readership.
It goes without saying--but we'll say it anyway--that your hard technical questions pertaining to real world problems are equally valuable as a foundation for this newsletter as are your programming insights. We hope you find all the editions of Midrange Guru valuable, and we are going to work hard to make sure that they are.
If you have a tough problem, our gurus can probably help. Their mailboxes are always open.
* Email Ted Holt at email@example.com
* Email Howard Arner at firstname.lastname@example.org
Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved. This document may be redistributed freely and enthusiastically by email, but only in its unedited form. Thanks for your cooperation. Midrange Guru is a registered trademark of Guild Companies, Inc. IBM, AS/400, iSeries, OS/400, and eServer registered trademarks of International Business Machines Corp. All other product names are trademarked or copyrighted by their respective holders.