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

February 5, 2016 | Volume 13 Issue 5


LEAD ARTICLE: SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and More
FEATURED ARTICLE: TechTip: Running PHP Scripts - Zend Server
NEWS HIGHLIGHT: ASNA Announces Business Partners in Morocco and Mexico
WHITE PAPER: 10 Top Reasons to Choose PHP for IBM i Web Application Development
EVENT: See What's New In Profound UI 5.3

Sponsor - New Generation Software

Query & Reporting for IBM i Users 1. Qport Office for Query/400: No license fee for 2 users. Run IBM Query/400 queries from Windows. Create/refresh Excel sheets, Access tables, & Word docs. 2. NGS SDK - $895: Query & Web reporting for 1 developer & 1 concurrent user. Fee includes online education & support. 3. NGS-IQ: Query, reporting, & OLAP. Windows, Web, & 5250 interfaces. Date math, conditional calculations, prompting, email. Output to Excel, Word, Access, PDF, DB2, CSV, & more.


Feature Article - TechTip
SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and More

RPG provides a few ways to replace characters in a string, such as the %XLATE BIF. SQL also has interestingand, more importantly, easy to usefunctions to transform strings, changing the case of its characters or replacing them altogether.

rafael victoria preiraWritten by Rafael Victória-Pereira

The previous article in this series discussed a set of scalar functions you can use to convert data to its representation in string format. Once this data is in string format, you can use it with text information from your files in order to create descriptions or other texts, which you can use in reports. However, these texts might require a different type of conversion; their case might not be the most adequate, or you might want to replace a character somewhere in the middle of the string. I could argue that his is also a conversion, albeit a different one.


Sponsor - NEUGC

26th Annual Northeast IBM i User Groups Conference

April 11 – 13, Framingham, MA

Sponsored By Northeast User Groups Conference

The Mighty i

  • Super Charge Developer Productivity
  • Empower User Data Access
  • Modernize Your Apps and Database
  • Enhance Your Skills

70+ sessions; NEW topics for 2016; top industry speakers; in-depth seminars; vendor expo


Feature Article - TechTip
TechTip: Running PHP Scripts - Zend Server

We looked at WAMP/MAMP/LAMP and how they can quickly and cheaply give you the ability to run the PHP scripts that you develop on your PC. But other options are available.

david shireyWritten by David Shirey

Even though MAMP and its two amigos do a good job of letting you run your PHP scripts, there are other, more sophisticated ways to do this. And the first thing that we will look at is using Zend Server to provide the server capability for you.


Sponsor - The MC Press Bookstore

This ain’t your mama’s RPG! Time to move on from OPM—with Evolve Your RPG Coding. This comprehensive new book gives you all the tools to move to a more modern, modular, and efficient ILE RPG. The book guides you through the transition at a comfortable pace, making every ILE concept totally accessible. You’ll start with simple, easy-to-understand examples and analogies to OPM, then advance to complete and complex ILE code. Finally, you’ll go beyond ILE with a detailed discussion of SQL, code organization, and structure. Pre-order your copy today!


MC White Paper Center

Choose one or more of these recently added downloads in our MC White Paper Center

DR Strategy Guide from Maxava: Brand New Edition - now fully updated to include Cloud!



Download your free copy of DR Strategy Guide for IBM i today.

The DR Strategy Guide for IBM i is brought to you by Maxava – innovative global leaders in High Availability and Disaster Recovery solutions for IBM i.

Element Break



10 Top Reasons to Choose PHP for IBM i Web Application Development

Download this free eBook to get a detailed look at the top 10 reasons why PHP is a great web development choice for IBM i shops, including:

  • Easy learning curve for RPG programmers
  • Leveraging DB2 and RPG with PHP
  • Benefits of choosing an open-source language
  • Why PHP makes mobile apps easy to deploy
  • Attracting new programmers

This eBook, which was co-sponsored by BCD and Zend, also features a foreword written by Alan Seiden.

Element Break



2016 IBM i Marketplace Survey Results

Now in its second year, HelpSystems surveyed over 800 IBM i users from around the world to produce the IBM i Marketplace Survey Results. The expanded 2016 survey builds on last year’s results to provide even greater insight into the IBM i marketplace.

From manufacturing and retail to finance and healthcare, IBM i professionals from around the world reported their plans and concerns for their IT environments, revealing how IBM i is being used and how it relates to their broader IT objectives.

Download the survey results to see how over 800 of your peers on the platform address:

  • Modernization & mobile applications
  • Hardware & operating systems
  • IT concerns & initiatives
  • Data growth, storage, & security
  • The future of IBM i

Element Break



5 Winning Strategies to Combat Information Overload

Today’s businesses must be available 24/7 with fewer people having to manage more complex systems and processes.

IT departments receive a constant bombardment of information from a diverse variety of operating systems, business applications, and critical processes and support a complex array of servers and devices running across their entire network.

With tight resources and the need to keep costs in check, more and more is expected of IT operational staff to handle this information efficiently. They need to ensure a swift response with appropriate actions, that essential data is received at the right time, prove service levels are maintained, that contingency and high availability strategies are fully operational, and that vital business activities run smoothly and without disruption.

What kind of safety net processes can you put in place so you can combat information overload, yet not miss a single thing, drop the ball, or cause a negative impact on the business—and more importantly, how do you go about it?

Learn how to handle the daily deluge of information and discover five strategies you can deploy to become an IT superhero in your organization.

Element Break



2015 Guide to Manufacturing Software

For all manufacturing industries, growth remains top of mind. Post-recession cautiousness has given way to confidence and more ambitious business goals. From automotive to fashion, more manufacturing leaders are ready to take bigger risks in the hopes of bigger payoffs, and optimism is the highest it’s been in years.

To help manufacturers choose the right software in a rapidly changing industry landscape, this guide will explore four key technologies that are essential to any successful manufacturing operation:

  • Enterprise Resource Planning (ERP)
  • Enterprise Asset Management (EAM)
  • Configure Price Quote (CPQ)
  • Supply Chain Management (SCM)

We’ll discuss the market trends increasing the need for adoption of each technology, provide a “shopper’s checklist” of essential features and functions, and share success stories from real-life industry leaders. This guide will also outline how Infor’s industry-specific software and cloud-based technology are helping global companies thrive.

Element Break



The Business Case for IBM i Green Screen Modernization

We've all heard the complaints from IBM i users: "Green screens look outdated. I want to use my mouse. What about mobile?"

Before decision-makers approve your modernization project, you'll need to make a compelling business case and highlight why it’s about more than giving your applications a pretty face. It's also about adding value to your IBM i.

Download this ebook to learn about the top business reasons for green screen modernization, including:

  • Modern, browser-based look and functionality
  • Improved workflows and access to information
  • Leveraging and future-proofing existing applications
  • Increased end-user productivity
  • Taking advantage of mobile devices

You'll also see real-world examples that include screenshots and links to videos.


Element Break



Overcoming Common IBM i Mobile Development Challenges

Creating mobile applications for IBM i on Power Systems doesn't have to be difficult!

Mobile applications can take your business to new levels of engagement, customer support and competitiveness. By making your ERP, Sales, Line of Business, and other applications mobile, you empower your workforce to get more done - from anywhere, at any time. If your business runs on IBM i (formerly known as AS400 or iSeries) there's no need to worry. You can easily make your RPG applications available on any mobile device!

Read this free white paper, and learn how you can overcome the most common challenges to mobile for IBM i shops, including:

  • How to go mobile with limited staff or budget
  • How to make any RPG developer a mobile superstar
  • Whether to choose hybrid or native development
  • How to ease BYOD development stress

Element Break



Plus Choose From The Outstanding Full Selection in our MC White Paper Center

*Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.

The MC Resource Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we're all about choice. We're even giving one lucky person the opportunity to choose their own prize in our "It's All About Choice" contest for a $250 Best Buy gift card.  Visit the MC Webcast, MC White Paper and MC Software Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win a $250 Best Buy gift card!



In the News

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

The Latest from IBM

Support MC Press - Visit Our Sponsors



Search Sponsor