TechTip: IBM i Access Client Solutions Update

Integrated File System support leads the way with this important new update.

steve pitcherWritten by Steve Pitcher

As of today, there’s a new version of the highly popular IBM i Access Client Solutions (ACS) product. If you’ve already downloaded the April version of ACS, you can easily upgrade using the new Check for Updates feature underneath the Help option in the title bar. Otherwise, click here and download the latest version. If you want all the ODBC features, those are included in two separate Application Package downloads (one for Windows, one for Linux) found on the IBM ESS website.

TechTip: How to Prepare for the DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Certification Exam

One of the best ways to prepare for any DB2 certification exam is by answering practice questions that are similar to, and that are presented in the same format as, the questions you are likely to encounter when you take the actual exam.

roger sandersWritten by Roger E. Sanders

Editor’s note: This article is adapted from DB2 10.5 DBA for LUW Upgrade from DB2 10.1: Certification Study Notes (Exam 311) by Roger E. Sanders.


 A few months after the “IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1” certification exam (Exam 311) was announced, I spent several weeks developing training material that I could use to help individuals prepare for the 311 certification exam. I used the same technique to develop material for that course that I have used to develop my other DB2 certification exam preparation courses and study guides: I carefully reviewed notes I had taken during the exam development process, as well as the questions I wrote for that particular test, and I made sure I covered, in detail, all the objectives that had been defined for that certification exam.

SQL 101: Date-Related Functions, Part 2—Time-Saving Functions

The functions discussed in this article won’t save time in the literal sense; mankind has yet to invent a time machine. However, these functions will surely cut down on the time it takes an RPG programmer to perform complicated “date math.”

rafael victoria preiraWritten by Rafael Victória-Pereira

As I mentioned in the previous article, there’s no BIF to return the day of the week, for instance. SQL provides several simple-to-use scalar functions that do that and more, as you’ll see later in this article.


Before getting to that, let me take a moment to address some readers’ remarks regarding the functions I presented in the previous article.

What IBM i Execs Should Know, Part 2

Oooh. Executives. Sounds so very sophisticated, doesn’t it? Handsome guys in expensive suits who go to clubs like Laslo’s after work and meet up with slender, willowy brunettes for a martini. Very classy.

david shireyWritten by David Shirey

OK, it’s time to talk a bit more about what IBM i managers and executives should know.


When we left off last time, we had identified two things that “i leaders” need to be familiar with: what makes the i special and what’s up with the Power architecture these days and why it’s a better choice than Intel for the long haul. But that’s not the end of the story. Come on, walk this way.

The Spark

Thoughts on encouraging the ones around us to learn and innovate on our behalf.

steve pitcherWritten by Steve Pitcher

I wrote the following little piece for the COMMON.CONNECT magazine about a month ago. I’ve shared it in its entirety below (in italics) and then expanded on my thoughts because in retrospect I really needed to go deeper.

Eye on the i World: BI Tool Vendor Sees Positive Perception of IBM i as Key to the Platform's Future

IBM's recent emphasis on TV advertising for its Watson platform is seen by some as a sign of declining commitment to the IBM i. Prominent business intelligence vendor New Generation Software thinks this concern is misplaced.

john gristWritten by John Ghrist

Judging by what we see in mass-media advertising these days, IBM's vision of its own future seems to be centered on its Watson platform. Data analytics via the cloud will surely play a big role in many enterprises' futures, but can we rely on the inference some could draw that the IBM i is fading from view everywhere else except in companies already committed to the platform?



IBM Bluemix Local System W3500 and W3550

IBM Bluemix Local System W3500 and W3550 models run cloud native services, enabled middleware, and open pattern workloads concurrently.

IBM Bluemix Data and Analytics Plan

IBM Bluemix Data and Analytics Plan offers easy, flexible access to a wide range of data and analytics services.

IBM Customer Insight for Banking V1.0.4

IBM Customer Insight for Banking V1.0.4 helps banks grow revenue, improve service, and increase marketing efficiency.

IBM MaaS360 Launches Four New Suites

IBM MaaS360 launches four new suites, offering key enterprise mobility management capabilities in purpose-focused bundles to improve mobile productivity and secure corporate content.

IBM Customer Insight for Insurance V1.0.4

IBM Customer Insight for Insurance V1.0.4 features IBM Predictive Customer Intelligence to help insurers improve customer programs and build deeper relationships.

IBM Client Insight for Wealth Management V1.0.4 With Watson

IBM Client Insight for Wealth Management V1.0.4 With Watson empowers financial advisors with capability to predict, personalize, and address changing needs of clients.

IBM Decision Optimization Center V3.9

IBM Decision Optimization Center V3.9 platform delivers effective prescriptive analytics solutions for line-of-business decisions across the enterprise.

IBM Hardware Announcements July 26, 2016

DS888x, DeepFlash, Data Engine for NoSQL, Flex System, Power 710 Express, and more.

HelpSystems Delivers Comprehensive IBM i Performance Monitoring

HelpSystems today announced the release of Robot Monitor 14.0, which brings leading performance and application monitoring technology to the Robot product line to create the most comprehensive monitoring solution available for IBM i environments.



Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here


Mon Aug 01 @22:30 - 11:00PM
Getting Started with IBM i Security: Public Authority

Events Calendar

July 2016
26 27 28 29 30 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6



NEW White Paper Addressing IBM i HA/DR in the Cloud

Connectria Hosting

3 Compelling Drivers for Implementing an HA Solution on an IBM i Cloud with MIMIX




IBM i Security Administration and Compliance

IBM i Security Administration and Compliance



Click for this Week's

Bookstore Special Deals



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!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


Latest Offer from the MC Press Bookstore >>

Element Break



Move from OPM to ILE...and Beyond
Evolve Your RPG Coding
 Element Break

 Bookstore Special Offer
Take an Extra 10% Off Any Top 10 Bestseller


eBook Special >>

Save 20% Off the Hard Copy Sale Price