TechTip: PDO for PHP

Why do we use PHP with an HTML web page? Lots of reasons, but data access is one of the most important, and PHP Data Objects (PDO) is, for me, the best way to do that.

david shireyWritten by David Shirey

There are lots of web languages out there, aren’t there? HTML5, JavaScript, PHP, CoyoTE. I actually don’t know if that last one exists, but given the number of special languages available for the web, I think I’ve got a 50-50 chance.


And increasingly, on the IBM i, we are being introduced toand find reasons to usemore and more of these languages. Each has its own list of things that it does well and things that it doesn’t.

TechTip: The .NET Core Framework

Provide support for a variety of chip and OS targets.

joydip kanjilalWritten by Joydip Kanjilal

Since the initial version of .NET Framework (the first beta version of .NET 1.0 was released in the fall of 2000), Microsoft has released many more upgrades over the years. With an intent to make the framework cross-platform, open source, and modular, the software giant has now come up with .NET Core Framework.

The IBM i Skills Shortage Myth

The problem isn’t IBM i skills shortage; it’s an “RPG II/III-fixed format-legacy-cycle” skills shortage.

steve pitcherWritten by Steve Pitcher

Yeah, I said it.


An “RPG II/III-fixed format-legacy-cycle” skills shortage. The kind of shortage you don’t want to have if you care about the future of your business. So forgive me if I take exception to the argument about IBM i having a skills shortage. It doesn’t. IBM i’s history is rooted in being a business computer for business people. They run business programs to do business things. IBM i may have grown in terms of capabilities, but at its core it’s a business operating system. So when people talk about an IBM i skills shortage, it makes me wonder if we’ve lost the point about what IBM i really is.

IBM i Security Without Breaking the Bank

Stop neglecting IBM i security. Consider a risk assessment and two control layers to enjoy substantially less risk of data losswithout sending your organization into the red.

robin tatamWritten by Robin Tatam

The time is now!

While some companies take a proactive stance on becoming more secure, many more act as a result of regulation. Governments and industry bodies have enacted numerous enforceable mandates, typically as a result of a scandal or high-profile breach. The growing list of these mandates includes PCI-DSS for credit card data, MAS-TRM for financial organizations in Singapore, BASEL for the banking industry, SOX for publicly traded companies, and HIPAA for those in the U.S. healthcare industry. Operators in the European Union face a dramatic increase in fines that may be levied for data breaches since the General Data Protection Regulation (GDPR) was adopted in April 2016. This replacement for the previous “directive” will become law in May 2018, and the financial impact on companies within this territory could be quite dramatic.

The Lesser of Two Evils: Choosing the Better IBM i Security Configuration

Carol describes scenarios where the configuration options aren’t optimal, but a choice must be made.

carol woodburyWritten by Carol Woodbury

By the time you read this, the election in the United States will be over. Many in the States view this election as having to choose between the lesser of two evils. While I’m not going to discuss the way I voted, I thought I might discuss some similar situationswhere I’ve been presented with two IBM i configurations to choose from, and neither is optimal.

TechTip: Store and Parse JSON Data Natively with DB2 for i

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.



Maxava Expands Support for JD Edwards Customers

Maxava, a global leading specialist in cloud monitoring, replication and recovery solutions for IBM Power Systems, today announced additional support for JD Edwards (“JDE”) Enterprise One and World applications via their in-house monitoring and recovery offerings.

Townsend Security Announces Major Update to Alliance LogAgent for IBM i

New features include full reporting of administrative users, including authority the user adopts through Group Profiles and Supplemental Group Profiles.

IBM Rational Solution for Collaborative Lifecycle Management V6.0.3

IBM Rational solution for Collaborative Lifecycle Management V6.0.3 helps teams to improve software and systems delivery through higher productivity and quality.

IBM Privileged Identity Manager V2.1

IBM Privileged Identity Manager V2.1 with Identity Governance and Intelligence V5.2.2 help improve privileged user governance.

IBM InfoSphere Master Data Management V11.6

IBM InfoSphere Master Data Management V11.6 creates trusted views of your critical master data assets to support operational, big data, and analytical initiatives.

IBM Explorys Platform with Enterprise Performance Management Together with IBM Watson Care Manager

IBM Explorys Platform with Enterprise Performance Management together with IBM Watson Care Manager provide an optimized, end-to-end care management solution.

IBM Rational Software Architect Designer V9.6

IBM Rational Software Architect Designer V9.6 product family delivers new capabilities and adopts Eclipse 4.6 Neon.

IBM TRIRIGA V10.5.2 and IBM TRIRIGA Application Platform V3.5.2

IBM TRIRIGA V10.5.2 and IBM TRIRIGA Application Platform V3.5.2 enable analytic insights to be derived through integration with IBM Watson Analytics; Lease Accounting enhancements for payments and lease treatments; new Move Request perceptive apps.


IBM COPLINK on Cloud offers affordability for small agencies and significant usability and performance enhancements.

Maxava and CMA Technology Solutions Bolster Partnership to Deliver Next Gen DR Services

Strategic Partnership reaffirms commitment to deliver premium Recovery and Monitoring services.



Introduction to Configuring iAccess Servers to use SSL

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

Events Calendar

December 2016
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




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 >>

MC Press Bookstore Year-End Inventory BLOWOUT

Year End Sale 5-dollar 500px

Year End Sale 10-dollar 500px

Year End Sale 15-dollar 500px

Year End Sale 25-dollar 500px

Year End Sale 35-dollar 500px

MC Press Bookstore Year-End Inventory BLOWOUT