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, 2014 | Volume 11 Issue 45


TOP STORY: TechTip: DB2 for i's Sample Database
FEATURED ARTICLE: TechTip: 24/7 Notifications from Your IBM i
NEWS HIGHLIGHT: New JumpStart Modernization Tool Generates Excitement with IBM i Developers
ON-DEMAND WEBCAST:  Introduction to Configuring iAccess Servers to use SSL Presented by Carol Woodbury
EVENT: TUESDAY: OCEAN User Group Meeting - DB2 Web Query
MC VIDEO PORTAL: Top 10 Security and Compliance Considerations for Cloud Computing


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 30 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. Watch our video to see what Barcode400 Software can do for you. Call 800-541-4893 or use the Live Chat feature at


Feature Article - TechTip
TechTip: DB2 for i's Sample Database

The built-in sample database makes self-learning and prototype activities easier.

kent milligan 117x117Written by Kent Milligan

Almost all of the DB2-related TechTips that I have written highlight new DB2 for i functions and features. While it's good to raise awareness of new DB2 capabilities, this does result in existing DB2 features being overlooked. This is especially true of the more ordinary database functions.


Sponsor - New Generation Software, Inc.

FREE, Live Webinar: Reporting & Analytics for Manufacturers & Distributors using IBM i (iSeries). Date: Tuesday, November 18, 2014, 11am PST / 1pm CST / 2pm EST. Description: See how the NGS-IQ query, reporting, and analytics solution simplifies data retrieval for Microsoft Excel and Web users and tackles complex report writing tasks. Who Should Attend: Manufacturing & Distribution industry Managers, IT Managers, IT staff, and Business Analysts. Call 800 824-1220. Register now at


Feature Article - TechTip
TechTip: 24/7 Notifications from Your IBM i

SP4i-Push offers free plug-and-play mobile messaging for up to 10 users.

serge charbitWritten by Serge Charbit

Today, with a smartphone in your pocket, you can get up-to-the-minute information from nearly anywhere—your friends, the news, social media, your email. So why is it so difficult to stay on top of important information from your IBM i applications and systems when you can't log on?


Sponsor - The MC Press Bookstore

Don't miss out! This is the hands-on guide to IBM's strategic language for IBM i. Database Design and SQL for DB2 delivers everything you need to know about database design and SQL. Author Jim Cooper gives you all the tips and techniques you need in one convenient place, whether you’re a beginner or an advanced developer. Includes real-life examples to help you hone your skills. The bonus companion website explains embedded SQL and explores client-side technologies.


MC Webcast Center

Don't miss these Featured On-Demand Webcasts:


What’s New in V7R2 Security

During this Coffee with Carol session Carol Woodbury will discuss the security enhancements added to V7R2 including:

  • new auditing options,
  • password composition rules,
  • general updates as well as
  • the DB2 security enhancements – RCAC (Row and Column Access Control.)Element Break

Introduction to Configuring iAccess Servers to use SSL Presented by Carol Woodbury

Due to popular demand, Carol has updated her presentation on configuring iAccess to use SSL sessions to include, not just the step-by-step configuration guidance but also a discussion on the benefits and challenges of using certificates from a well-known CA (Certificate Authority) vs a self-signed certificate as well as practical tips for enterprise implementation.

Element Break



Coffee with Carol: I want my Privacy!


Whether you are a cloud provider or a consumer of cloud technology, this session will apply to you. Using a consumer's point of view, Carol Woodbury will discuss the security considerations you'll want to make when choosing a provider as well the security measures you can expect from various types of cloud providers. Also discussed will be the types of audits that the cloud provider can supply to provide assurances of security and privacy of data.

Element Break



Create Amazing, Modern Apps With Profound UI

In this information-packed Webinar featuring IBM Champion Scott Klement and Profound Logic Developer David Russo, you’ll learn why you don’t need to compromise your investment in IBM i to deliver amazing, modern business applications!

  • A patented, drag-and-drop visual designer for easy modernization
  • The first available Handler for RPG Open Access
  • Over 150 built-in rich UI widgets that take your apps beyond anything possible in 5250
  • Integration with a suite of tools that future-proof your applications

Element Break



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

Element Break

Plus choose from the Complete Collection in the MC Press Webcast Center


*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.


The MC Resource Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we’re all about choice. We’re even giving one lucky person the opportunity to choose their own prize in our “It’s All About Choice” contest for a $250 Best Buy gift card.  Visit the MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security,  and MC Disaster Recovery Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win a $250 Best Buy gift card!


Have a Webcast you would like to list? click here or call (208) 629-7275 Ext.504 for information.




In the News

Vendors:  Have a press release to share?  send it to MC Press

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



MC Video Portal

MC Video Portal

Top 10 Security and Compliance Considerations for Cloud Computing


Whether you are using a cloud-based application or moving your whole infrastructure to the cloud, you should consider how this move effects your organization's security and compliance requirements. In this Coffee with Carol session, Carol Woodbury will discuss the top 10 considerations you should make as well as how to ensure that your organization's security and compliance requirements are not compromised.