TechTip: C# for RPGers—Learn More About C#’s Methods and Properties

In the previous TechTip, I showed you a couple of string methods, which were somewhat similar to RPG BIFs. This time, I’ll show you how to discover what’s available and introduce a couple of object-oriented languages concepts.

Written by Rafael Victória-Pereira

rafael victoria preiraStart firing up Visual Studio, because this is going to be a hands-on TechTip! I’ll explain a few more string methods, so that you can get familiar with the way Visual Studio can help you choose the right tool for the job, or, in other words, the right method for the job.


If you haven’t been following this series, go back to the previous TechTip and copy-paste the full code to a new Console Application project. This TechTip from earlier in this series explains how it’s done.

TechTip: Evolutionary Change and the IBM i Developer

Dont fight evolution! Adopt new stuff!

rick flaglerWritten by Rick Flagler

The topic of this article resulted from several recent events:


  • The June anniversary of the AS/400 launch and its 27th birthday
  • A television campaign by a national cable provider regarding ability to CHANGE
  • Debate about RDi vs. SEU concurrent with developer comments that IT managers wont spring for RDi because of its expense in the IT budget
  • Recently released totally free-format RPG programming techniques
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.



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
Tue Aug 02 @08:00 - 08:30AM
Getting Started with IBM i Security: Public Authority
Tue Aug 02 @12:00 - 01:00PM
The Truth About Viruses on Power Systems

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