Glad to have you back for this week's IBM i Pulse! Each week we will be taking a deeper look at the latest IBM i and Profound Logic news.
From Our Experts:
- Ted Holt continues his Guru series for IT Jungle with his article on LTRIM + RTRIM > TRIM.
- Brian May talks about Building an Open-Source Community for IBM i with MC Press Online.
Profound Logic News:
- MC Press highlights the new Expanded Node.js Professional Services offered by Profound Logic.
- New on-demand webinar available: Make Applications You'll Love with RPG and Node.js
- Liam Allan shows you how to Create your First Profound.js Web Service.
- Alex Roytman was able to take control of his Tesla Model 3 Interface Using the Power of Node.js.
Curious how he did it?
- Profound UI 5.14 is now available! Learn more about the latest version here or Download the latest version.
- Create Custom ToolTips easily with this Profound Pro Tip.
The Five Hottest RFES of the Quarter by Alex Woodie
A little more then a year ago IBM introduced their Request for Enhancement (RFE) process that allowed any and all developers to request enhancements to the IBM i. This new program has been seen as a great success and with the first quarter of 2018 over, we can now compare the top 5 requests submitted through the RFE program.
1. New built-in function %SPLIT
This new built-in function could be used to extract an array of elements from a source string. This request got 63 votes and is currently the #1 request on the platform.
2. Allow use of RPG constants in embedded SQL
This request came from David Gibbs and states, “When a constant is defined in RPG, allow that constant to be used in embedded SQL statements so that the value of the constant does not have to be hard coded in the SQL statement. Allow the constant to be referenced as if it were a program variable with a colon prefix.” This request currently has 50 votes and sits at #2 on the list.
3. SQL prompting in ACS
This request asks for the prompt feature that is in the SQL to be utilized within the Access Client Solution. This is a close 3rd with 48 votes.
4. Add "in use" for stream files in iACS
This new feature would make it easier for the user who is performing maintenance to track down who has a lock on an IFS-based stream file through iACS. Currently this function has 35 votes.
5. Run SQL Scripts - Autocomplete
The goal of this feature is to give IBM i programmers the same types of SQL autocomplete functionality that are found on other platforms. With 27 votes this request comes in at number 5.
IBM i 30th Anniversary Celebration Begins by Steve Wills
This week begins the celebration of the 30th anniversary of the IBM i. With so much accomplished already, the IBM i is still growing and expanding, so much so that the slogan for this celebration is "30 years of innovation and we are just getting started!" 2 weeks ago at the RPG & DB2 Summit, Steve Wills had a preview party, and now they are ready to unveil the birthday plans to the entire IBM i community!
The celebration will have an on-line home, which you can get to by visiting the IBM i home page or by clicking here. To help celebrate, they asked volunteers to share their stories of how they are innovating with the IBM i, and the response was huge. From all over the world, people shared their insight and happiness with what the IBM i is doing in their business and how they are innovating with in the IBM i. Over the next 10 weeks the celebration will continue with a new story posted on the home page, each story will highlight a client and the IBM i innovation that they are using.