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

May 27, 2016 | Volume 13 Issue 21


LEAD ARTICLE: TechTip: Data Warehouse Updates from IBM i Using SSIS
FEATURED ARTICLE: TechTip: DB2 for i Optimization Strategies, Part 3
NEWS HIGHLIGHT: MB Software & Consulting Releases Workload Performance Series v9.0 with New Features
EVENT: What’s New in IBM i Security in V7R3 and V7R2

Sponsor - New Generation Software, Inc.

FREE, Live Webinar, Wednesday, June 15, 2016: Answering Business Questions with Real-Time, Operational Reporting and Analytics. Big data grabs the headlines, but chances are very good that quite a few people in your company would benefit right away if you gave them a modern, integrated, query and analytical tool set that works with your real-time, operational data. That's why more and more IBM i customers use NGS-IQ. Call 800 824-1220 or register online to attend:


Feature Article - TechTip
TechTip: Data Warehouse Updates from IBM i Using SSIS

Point-and-click your way to repeatable data updates to or from any database from your DB2 database.

tom snyderWritten by Tom Snyder

One common theme I’ve experienced through several RPG developer jobs is to provide data to an external data warehouse from the all-knowing DB2 database. Other common needs may be to supply member information to a website or to some third-party software. Sometimes these would be DB2 databases, and sometimes they wouldn't. I'm going to show you how to quickly set up a SQL Server Integration Services (SSIS) package to take care of this process for you.


Sponsor - The MC Press Bookstore

Nail Exam 311! This new book will show you how. Get the newest release in the MC Press DB2 Certification Study Guide series from leading DB2 authority Roger Sanders. Sanders helped develop Exam 311 and 23 other DB2 certification exams. This new book is all you need to prepare and pass the exam in one handy, concise guide. Includes 56 practice questions and answers that model the exam. Get your copy today!


Feature Article - TechTip
TechTip: DB2 for i Optimization Strategies, Part 3

Learn ways to keep your database code lean and mean, resulting in better performance.

Written by Michael Sansoterra

This third tip in the series continues where Part 1 and Part 2 left off. Presented herein are some general guidelines for how to make your database code purr like a kitten.


Sponsor - The MC Press Bookstore

Relax…he knows his stuff! You’ll be sure to pass Exam 615 with the help of DB2 expert Roger Sanders. He helped develop Exam 615 plus 22 other certification exams. This is the latest in the popular MC Press DB2 Certification Study Guide series. Get all you need to know about DB2 10.5 for Linux, UNIX, and Windows. This guide includes a complete practice exam with 125 questions and answers. Nothing will prepare you more for the DB2 10.5 Fundamentals for LUW exam! Order your copy today.


MC SCBG Featured Product

TLAForms by TL Ashford converts your traditional IBM i spool files into high quality, professional forms.

Use a GUI Designer to create forms using data from a spool file and data from your IBM i files. Forms can be designed with true-type fonts, bar codes – including QR Code and Datamatrix, color images, overlays, lines, boxes and ellipses all in full color.

The software generates your forms as PDF documents that are archived to the IFS, automatically emailed and/or printed. Forms can be printed to IBM i PostScript printers, any printer connected to the network, or any printer connected to a PC. IFS locations, email addresses, and printers can be variable based on data within the spool file, data within the IBM i file or spool file attributes.

No programming is required to generate the new forms from your existing ERP, WMS or in-house application software.

The experienced TL Ashford technical support team will provide any pre-designed templates like the VICS Bill of Lading, and make sure working with the software is as easy and productive as possible!


In the News

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

The Latest from IBM

Support MC Press - Visit Our Vendors


Search Sponsor



MC Press Resource Centers


White Papers

Trial Software

 120x90-WOD-MCPOct2015  SB SkyView PPL 5194-120x90  SB HelpSystems ROBOT Generic120x90
Create Amazing, Modern Apps With Profound UI What Authorities Do Programmers Really Need? Easiest Way to Save Money? Stop Printing IBM i Reports
Interested in IBM Power System White Papers, Webcasts and Software solutions? Visit our resource centers today!