Quadrant Software



HOME    SUBSCRIBE

  Midrange Guru - OS/400 Edition

 

Editors: Ted Holt      Managing Editor: Mari Barrett
Howard Arner Technical Editor: David Morris

Topics Covered In Volume 1, Number 5:

Avoiding Output from RUNSQLSTM

Hey, Ted:

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)
RUNSQLSTM SRCFILE(mylib/SQLSRC) SRCMBR(mymbr) COMMIT(*NONE)
DLTOVR QSYSPRT

-- Ted  

 

 

Over 3,500 customers trust Quadrant Software's Electronic Document Distribution (EDD) solutions for creating professional, electronic forms for delivery to plain paper printers, fax machines and email mailboxes. Powerful in scope, but modular in design, our award-winning solutions are tightly integrated with most major application vendors and work independently or together to handle all your mission-critical document distribution needs:

* Electronic Forms--Design, manage, and distribute superior- quality forms and eliminate overhead costs associated with pre-printed forms with Formtastic. Create forms from spool file output without modifying your application programs. http://www.quadrantsoftware.com/Products_fdr/formtastic.htm

* Bar Code Labels--Generate and print professional-quality labels directly from DDS with support for over 38 bar code formats using Formtastic Labels. http://www.quadrantsoftware.com/Products_fdr/formtastic.htm

* Checks--Secure and streamline check printing operations for payroll and accounts payable checks. Use Formtastic Checks to prevent fraud and create MICR enhanced checks printed on blank check stock. http://www.quadrantsoftware.com/Products_fdr/formtastic.htm

* Fax Server--Use FastFax to manage your fax traffic throughout your organization and eliminate departmental fax machines. A high- performance fax server designed for all your sending and receiving needs, FastFax guarantees delivery, reduces transmission costs, streamlines administration, and secures your fax activity. http://www.quadrantsoftware.com/Products_fdr/fastfaxfamily.htm

* Email Gateways--Don’t just print and mail your mission-critical documents. Combine Formtastic with FastFax and eDocMail to send your professional looking documents via fax and email. eDocMail is an email gateway designed for delivering documents via email and works seamlessly with Microsoft Exchange, Lotus Domino, Novell GroupWise, or any SMTP server. http://www.quadrantsoftware.com/Products_fdr/edocmail.htm

Designed to deliver unsurpassed reliability, our document creation and distribution products offer a complete Electronic Document Distribution solution and embody the innovative engineering you expect from Quadrant Software.

For more information call 800-258-3399 or visit http://www.quadrantsoftware.com.



 

Subscription And Advertising Information

Subscription Information

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.

Advertising Information

Please contact Timothy Prickett Morgan at

Phone: 212 942 5818

Email: tpm@itjungle.com

Linux Desktop Environment for iSeries

Hey, Ted:

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.

-- Ted

 

 

Reorg While Active

Any further explanation needed?

Reorg While Active does just what its name says, reducing downtime associated with reorganizing AS/400 files to just seconds. Now, you can reclaim lost disk space without taking users down.

Reorg While Active offers advanced functionality for improved AS/400 performance and user response times. Inexpensive and easy to use, Reorg While Active features fully automated installation and operations.

ITera, Inc. helps you live the promise of 24x7 computing. Visit us today at http://www.iterainc.com for more information, or simply call us at 800-957-4511 ext. 150.



 

 

 

ATTEND COMMON IN MINNEAPOLIS OCT 21-25

Join thousands and receive the iSeries IT education you need at the COMMON User Group's Fall 2001 Conference October 21-25 in Minneapolis. Complete information is available at http://www.common.org/Conferences/conf.html

Right now, read what a $995 registration gives you:

You'll choose from over 800 session hours that cover such vital topics as Web development, Java, VPN, WebSphere, Client Access, RPG IV, and Linux. Select the exact education you need and make yourself the problem solver in your organization.

Also, because we'll only be 1 1/2 hours from Rochester, Minnesota, you'll learn more than ever before about the iSeries. More IBMers will be in attendance, and this is a golden opportunity to share ideas with them.

In addition, you'll network with top iSeries professionals and exchange e-mail addresses. This connects you with the people who can help you accomplish more for your company.

To register online and/or become a member go to http://www.common.org/Conferences/confnew.html

Most important: Take action now. Register for the COMMON IT Education Conference, because there's no faster way to increase your value to your organization.




 


Reader Feedback And Insights

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.

Contact the Editors

If you have a tough problem, our gurus can probably help. Their mailboxes are always open.

* Email Ted Holt at tholt@itjungle.com

* Email Howard Arner at harner@itjungle.com

Quadrant Software

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.