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

November 14, 2012 | Volume 7 Issue 11


TOP STORY: Introduction to SQL, Part 1
FEATURED NEWS: Introducing LongRange University: Free, Easy Online Education for Developing Native Mobile Apps
NEWS HIGHLIGHT: IBM Delivers New Software to Help Organizations Build Smarter Products
BUYER'S GUIDE: DBXFlex Report Writer / Query Tool
EVENT: Ad-Hoc File Transfers -- Easy and Secure
Manage Subscription | Contact Us


Sponsor - T.L. Ashford & Associates

Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at


Feature Article - Programming
Introduction to SQL, Part 1

This article is an excerpt from Mastering IBM i (MC Press, 2011).

jim buckWritten by Jim Buck and Jerry Fottral

Structured Query Language (SQL) has become the mainstay for data manipulation on most platforms today. It is important for today's IBM i professional to understand the traditional DDS tools, but most new database systems are created and manipulated using SQL. The intent of this series of articles is to expose the reader to both the traditional tools and the latest tools and concepts. SQL is a complete database language with data-definition, data-manipulation, and data-control components.


Sponsor - ASNA

Creating great mobile applications for smartphones and tablets is challenging and requires a highly evolved skillset. ASNA Mobile RPGTM changes all of that by coupling a state-of-the-art mobile user interface with traditional RPG to dramatically reduce the work required to build smartphone and tablet apps for the IBM i. The only skills required to create superb mobile applications with Mobile RPG are traditional RPG coding skills—period! 


Learn more about Mobile RPG at:


Featured News - Networking
Introducing LongRange University: Free, Easy Online Education for Developing Native Mobile Apps

Following the recent launch of LongRange, the first native mobile app builder for RPG developers, comes LongRange University, free online education for building stylish, high-performance Apple and Android mobile apps fully integrated with your core IBM i applications.


MC SCBG - Featured Product

DBXFlex125x75DBXFlex report writer / query tool extracts data from IBM i, iSeries and AS/400 database files creating custom reports directly to Excel and PDF.



  • Extract data from one or multiple IBM i data files to create custom reports
  • Output directly to Excel, PDF, CSV and print files
  • Perform record and field selection
  • Add calculations, color, sort, justification, date format etc.
  • Runs on any IBM System running IBM OS V5R1 or higher

Standalone module can pre-process spooled files for use by other IBM i software applications.

DBXFlex provides flexibility over legacy reporting allowing users to create reports by accessing the data they want, and outputting to formats they need, delivered by email and archived to network servers. . For a closer look, schedule an online demonstration, or request a free trial


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor