Tightening IBM i Security with Little Fear of Breakage

Carol describes five IBM i security settings that eliminate exposures and can be changed with very little risk of breaking anything.

carol woodburyWritten by Carol Woodbury


I know that many of you feel handcuffed. You want to make changes to improve your IBM i security posture, but your organization is so risk averse that it’s almost impossible to make changes that have the possibility of breaking a production process. While I can’t guarantee that these changes will not cause an issue, it’s unlikely that they will.

RPG Fundamentals Tip #2: Working with Linear Main Programs

Unlike cycle main programs, linear main programs do not include the RPG cycle.

jim buckWritten by Bryan Meyers and Jim Buck

Editor’s note: This article is excerpted from Programming in ILE RPG, Fifth Edition, chapter 14, “Building Modular Programs with Procedures.”


RPG supports a second type of program (as an alternative to cycle main programs) that does not include the RPG cycle. A linear main program explicitly names a procedure to be the main procedure for the program. A linear main program includes a Ctl-opt instruction with the Main keyword to name the main procedure:

The JavaScript Event Loop for IBM i Developers

Understanding the Event Loop is critical to JavaScript development both in the browser and in Node.js.

brian mayWritten by Brian May

In my day-to-day work, I switch between RPG and JavaScript development constantly. While I do not consider myself the ultimate authority on JavaScript, I do have a solid working knowledge of the language. There was a time when JavaScript was only used for browser manipulation at runtime, but with the rise of Node.js, which is now available on IBM i, JavaScript is becoming a major player for server-side development as well.

SQL 101: Tools of the Trade - Old, Reliable STRSQL, Part 1

This article kicks off a new subseries in which I’ll discuss a few tools at your disposal to write, validate, and run SQL statements. The first of the list is the Interactive SQL, better known as STRSQL.

rafael victoria preiraWritten by Rafael Victória-Pereira

Perhaps the most used (and certainly the oldest) tool to execute SQL statements is the green-screen Start Interactive SQL Session command, STRSQL. This command is somewhat similar to the QCMD command in the sense that it provides similar function keys.

Happy Halloween with IBM i 7.3 Technology Refresh 1

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

steve pitcherWritten 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.

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.

joe plutaReviewed 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.



New Software from Dynamic Solutions International Takes Secondary Storage to the Cloud

Restore software virtualizes the data backup and recovery process for small and mid-sized businesses.

Kisco Announces New System Monitoring Tool for IBM i

Kisco Information Systems today announces Release 2 of its system monitoring tool for the IBM i platform.

Software AG Launches Open Source Internet of Things Analytics Kit

Software AG has significantly expanded the capabilities of its Apama Community Edition with a new Internet of Things (IoT) Analytics Kit, provided free of charge as Open Source Software.

IBM and AT&T Strengthen Alliance by Offering Advanced Cloud Networking to Businesses

IBM and AT&T* are teaming to help businesses manage their networking services more effectively and efficiently.

Siemens Healthineers and IBM Watson Health Forge Global Alliance for Population Health Management

Alliance to enable providers worldwide to transform health through value-based healthcare.

IBM Bolsters Social Services Sector With Technology Grants

Launches $18 million grant program that uses cloud computing to improve services for those most in need.

Free-Form RPG Programming

Manta Technologies is proud to announce the release of its newest series, Free-Form RPG Programming.

Surround Technologies Announces Accelerator Version 7

New Ways to Love Your Software - Anywhere

Surround Technologies is excited to announce the general availability of Accelerator Version 7.

ARCAD Software announces support for external SCM tools, Git, SVN and TFS

ARCAD Software, leading vendor in Enterprise Modernization and DevOps solutions for IBM i, announces October 30th GA release of Version 3.0 of ARCAD-Builder, an intelligent IBM i build engine supporting several external source code management (SCM) tools, including Git, Subversion (SVN) and Microsoft Team Foundation Server (TFS).



Introduction to Configuring iAccess Servers to use SSL

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


Wed Oct 26
COMMON - Fall Conference and Expo
Wed Oct 26 @13:00 - 01:30PM
IBM i Monitoring by the Dashboard Light
Thu Oct 27 @11:00 - 12:00PM
Work Smarter: Integrate IBM i and Desktop Applications
Thu Oct 27 @12:00 - 01:00PM
Making the Move from SSL to TLS1.1 and TLS1.2

Events Calendar

October 2016
25 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




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

The MC Press Bookstore runs promotions throughout the week.

Make sure to stop by and check out these Special Deals:
Weekly Collection Sale - Every week an entire Subject is on sale between 15% to 30% off the Sale Price.
10/24 to 10/28 - 30% OFF All DB2 books
Monday's Blowout Book - Every Monday check out this DEEPLY discounted book - 50% or more off Sale Price. 
10/24 to 10/28 - 50% OFF - Evolve your RPG Coding: Move from OPM to ILE... and Beyond
Tuesday's 2-Day Sale - Every Tuesday come check out a very special offer on one of our top selling books.
10/25 to 10/26 - 35% OFF - IBM System i APIs at Work
Thursday's 2-Day Sale - Every Thursday come check out a very special offer on one or more of our books.
10/27 to 10/28 - 35% OFF - Free-Format RPG IV: Third Edition


Check out these New MC Press Books

DB2 11 for z/OS Database Administration: Certification Study Guide (Exam 312) IBM i Security Administration and Compliance: Second Edition Evolve Your RPG Coding: Move from OPM to ILE ... and Beyond DB2 10.5 Fundamentals for LUW (Exam 615)


eBook Special >>

Save 20% Off the Hard Copy Sale Price