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

December 3, 2010 | Volume 7 Issue 47


TOP STORY: TechTip: Understanding Your SQL Output Options
FEATURED ARTICLE: Why Waste Money and Kill Trees When Using Spool File Management Best Practices Preserves Both?
ADVERTORIAL: Partner TechTip: Gain Control over Development Through Better IBM i Documentation
NEWS HIGHLIGHT: RJS Updates SignHere Digital Signature Capture Product
FORUM: Do CREATE Commands Move Objects Differently Than MOVOBJ?
EVENT: UNIT4 CODA: Best of Class Financial Apps for the i ...
BLOG: System i Management Tips

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 - TechTip
TechTip: Understanding Your SQL Output Options

Find out how to transform and extract data and learn the options for saving the output.

kent_milligan_117x117Written by Kent Milligan

As the numbers of applications systems and interfaces continues to grow, many IBM i developers face the challenge of getting their DB2 for i data into the right format to meet the requirements of these new interfaces. The format types range can from XML to comma-separated values (CSV) to fixed-file formats.


SQL is a great language to use in these situations.


Feature Article - Analysis
Why Waste Money and Kill Trees When Using Spool File Management Best Practices Preserves Both?

Save money on printing, but for a limited time, save on BCD's 2010 year-end promotion.

chris_smithWritten by Chris Smith

We don't have detailed demographics on all our MC Press Online readers, but my guess is there aren't too many who were working on computers in the early 1960s when IBM coined the term "spool file." The acronym stands for Simultaneous Peripheral Operation On-Line (SPOOL), but folklore has it that the name actually was conceived after the term "spool" came into widespread use, since a spool is what is used to wind magnetic tape.


Before multitasking was invented, computers could run only one job at a time. So if you wanted to print a job, it would consume the computer's full time until the printing finished.


Advertorial - Help/Systems
Partner TechTip: Gain Control over Development Through Better IBM i Documentation

Lots of development and no controls?

floyd_delmuroWritten by Floyd Del Muro

One benefit of developing software for IBM i is that it's relatively transparent in terms of understanding application architecture. It's always been fairly easy to hire RPG or COBOL programmers to pick up a project where another developer left it. Of course, there's some ramp-up time while the new programmer learns the program and database schemas, but the architecture of most IBM i applications is similar enough to make this a nonissue. Therefore, organizations typically hire, retain, and eliminate many developers over the life of their IBM i applications. The penalty for using this approach has been extremely minor, given the relative stability enjoyed by applications that may have multiple versions lying around.


MC Industry Events Calendar

December 7th:

09:00 - 17:00 COMMON: DB2 Web Query Virtual Lab (Repeat) Webcast / Webinar

13:00 - 14:00 UNIT4 CODA: Best of Class Financial Apps for the i ... Webcast / Webinar


December 9th:

12:00 - 13:00 See what's new in Presto 2.4 Webcast / Webinar

16:00 - 19:00 WMCPA Dinner Meeting Local User Group Meeting


December 14th:

14:00 - 15:00 iManifestUS - Call for Participation Featuring Dr. ... Webcast / Webinar

16:00 - 16:30 Compleo for SAP Webinar-Production Report Bursting ... Webcast / Webinar


December 16th:

11:00 - 12:00 Thinking Beyond Modernization – Safeguard your fut ... Webcast / Webinar


Have an event you want to list? Send the information to today.


In the News


Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor





MC Industry Blogs

Read and Share the latest from the IBM i Automation Blog

brought to you by Help/Systems


Inside IBM i with Alison Butterill

Submitted by Tom Huntington on Tue, 02/04/2014 - 9:31am


Where is IBM heading with mobile? What about IBM i in the cloud? Find out the future of the platform from Alison Butterill, IBM’s Worldwide Product Manager for IBM i. Alison is a key contributor for defining the future of IBM i, including content for releases and technology refreshes. We connected with her in late December to ask some big questions about trends and directions at IBM in 2014 that may influence your data center operations. Here’s what she shared with us.

Login or register to post comments

Read more