MC Press Online

Friday, Apr 28th

Last updateFri, 28 Apr 2017 10am

You are here: Home PUBLICATIONS MC Systems Insight October 17, 2016

MC SI Header

Lead Article - Analysis

Happy Halloween with IBM i 7.3 Technology Refresh 1

IBM announces a new cloud storage product inside IBM i 7.3 TR 1.

Written by Steve Pitcher

It’s October and that means two very important things:

One, I get to impose my yearly Sheriff of Nottingham-style 10 percent candy tax on my three kids after Halloween. And two, IBM has released its fall announcement for IBM i, in this case the news that IBM i 7.3 Technology Refresh 1 and 7.2 Technology Refresh 5 have been announced.

New Generation Software, Inc.

Graphical, Web, and mobile query and reporting. Make it all happen on IBM i. NGS-IQ enables users to write queries that output to Excel, Access, Word, PDF, CSV, TXT, HTML, and XML; build OLAP cubes; run Web reports with charts and drill down options; and distribute output via email. Attend our next webinar and see how we complement Microsoft Power BI or look for us at the Fall COMMON and VAI conferences. FREE Trials are available upon request. Contact us at www.ngsi.com or call 800 824-1220.

MC Press Bookstore

Data is the world’s new “natural resource,” and DB2 for z/OS is still the gold standard for storing and leveraging your mission-critical data. In this book by 5 IBM DB2 for z/OS experts, you will learn about new technologies that help you take advantage of DB2 in the cloud, protect your data, deliver predictive analytics to make better decisions, integrate DB2 for z/OS with mobile banking, and gain business insights from both DB2 and non-DB2 data.

MC Press Bookstore

Now available at a special price! One of our most popular certification study guides, DB2 10 for z/OS Database Administration, prepares you for IBM Certification Exam 612 like nothing else can. This is a comprehensive review, written by two members of the test creation team, which walks you through all areas covered on the exam. You’ll get tips on working with DB2 for z/OS and new information about Version 10. Includes an 85-question practice exam complete with detailed answers.

Featured Article - Database

Book Review: Database Design and SQL for DB2

If you have time for just one book to begin your journey into SQL on the IBM i, this is that book.

Reviewed by Joe Pluta

Writing technical books is always a juggling act between depth and breadth. Unless you're writing a 2,000-page Microsoft tome, there's no way you can provide both complete coverage and enough detail to be a complete reference. This is particularly true of books written for the IBM i, which have to serve the dual purpose of educating on the basic topic as well as addressing the nuances specific to the midrange platform. The best you can hope to do is to address the critical areas with enough depth to make someone productive.

Happily, James Cooper's book Database Design and SQL for DB2 manages to do exactly that.