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


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.


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


Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor