MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

March 17, 2010 | Volume 9 Issue 6


TOP STORY: Using DB2 with Sed, Tail, Pipes, and Redirection from Within Qshell
FEATURED ARTICLE: The API Corner: Sending Non-Error-Related Messages from an Application Program
MORE NEWS: Publishers, Authors, and User Groups Help COMMON Africa Acquire Textbooks
ON-DEMAND WEBCAST: nuBridges Exchange i – 10 Minutes to a Whole New World of Managed File Transfer for IBM i.
FORUM: Upload TXT to Source PF
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
T.L. Ashford is “The Labeling Answer”® for the System i.

Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates.

Also, be sure to download the new white paper: Bar Code / RFID Label Printing, Don't get caught in the integration trap.


Feature Article - Programming
Using DB2 with Sed, Tail, Pipes, and Redirection from Within Qshell

Export physical files directly to the IFS with headers.

tom_snyderWritten by Tom Snyder

In my previous articles about SQL on the IBM i, I have used common commands that are available directly from the command line. In this article, I will use the db2 command in Qshell to export files directly to the IFS. And when I create the file, I will also satisfy a common need to include header information with the data.


Sponsor - CNX Corporation

Give your RPG programs a true Web 2.0 Interface!

Valence offers RPG Programmers a genuine Web 2.0 solution for the System i, combining simple ILE RPG procedures with a robust ExtJS-based browser framework.

Valence 2.1 JUST RELEASED!

Includes new multilingual features, expanded AutoCode functionality, additional RPG procedures, back-end performance improvements and much more. New flexible licensing terms too!

See video demos of Valence in action and download the community edition for FREE!


Feature Article - Programming
The API Corner: Sending Non-Error-Related Messages from an Application Program

Sometimes you want to see messages that tell you things went right instead of wrong.

bruce_viningWritten by Bruce Vining

In the previous article, "More On Sending Messages from an Application Program", the Send Program Message (QMHSNDPM) API was used to send a user error message indicating that a severe error had been encountered and, if appropriate, diagnostic messages explaining the cause of the error. But not all programs encounter problems—at least I hope not all of your programs do! In this article, the QMHSNDPM API will also be used, but now to send a variety of non-error related messages.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor




Search Sponsor