- 1151. My Favorite IBM i 7.3 Enhancements for Developers
- (IBM i (OS/400, i5/OS))
- ... to your management to start planning your upgrade. Limitless Free-Format RPG Support This enhancement is not entirely new, but it ships with 7.3 and I have not written about it yet. The last piece ...
- Created on 19 April 2016
- 1152. SQL 101: String-Related Functions, Part 4—“Stringscaping” with TRIM and Related Functions
- (SQL)
- ... you’re probably removing some characters, like the blank space, from your strings using RPG’s %TRIM. SQL provides an interesting group of scalar functions that provide %TRIM’s functionality and more. Let’s ...
- Created on 19 April 2016
- 1153. IBM i 7.3 Philosophy Includes Marketing
- (Analysis of News Events)
- ... going to help. SP: How important is it to reassure the RPG community that you're committed to RPG? AB: With the 7.3 announcement, it was just good timing to put it out there now. It depends completely ...
- Created on 17 April 2016
- 1154. More About IBM i 7.3
- (Operating Systems)
- ... the other DS8000 server be unavailable. As with previous releases, IBM i 7.3 continues to extend both the traditional application development environment with new features and functions in RPG IV, but ...
- Created on 15 April 2016
- 1155. Hooking Up a Smartphone App to IBM i
- (Development Tools / Utilities)
- Use Sencha Touch and JSON/JSONP to talk to your RPG programs. Written by Robert Swanson In my previous article on distributing mobile apps within your enterprise, we opened by discussing the difference ...
- Created on 13 April 2016
- 1156. ASNA Announces New Distributor in Valencia, Spain
- (Mergers / Acquisitions)
- ... global IBM i services and our long experience with RPG. We'll be very well positioned to help these customers with improving their IBM i investment by helping them extend the life and value of their RPG ...
- Created on 12 April 2016
- 1157. Profound Logic Puts Customer on the Fast Track to IBM i Modernization
- (Development Tools / Utilities)
- When faced with modernizing a decades-old IBM i (AS/400) application that has been maintained by several different RPG developers, it's easy to see how an IBM i development team might feel overwhelmed about ...
- Created on 06 April 2016
- 1158. TechTip: Riding the Rails, Part 3
- (Scripting)
- Ruby's database access is simple and elegant, something I thought I'd never say about another language after using RPG for over a decade. Written by Aaron Bartell In the January 2016 article "Riding the ...
- Created on 10 March 2016
- 1159. SQL 101: String-Related Functions, Part 3 - Pulling Strings Around with REPLACE and INSERT
- (SQL)
- RPG's %XLATE BIF converts characters to uppercase or lowercase. The previous article of this series showed a few SQL functions that provide this type of functionality. But %XLATE can also replace characters ...
- Created on 10 March 2016
- 1160. Chrome DevTools: The Indispensable Toolkit for Interrogating Web Page Data
- (General)
- ... the DDS display file for the underlying screen, use SDA to find the appropriate record format and field name(s), and then look at the associated RPG code to see how those particular display fields are ...
- Created on 08 March 2016
- 1161. Eye on the i World: Complacency and User Aging Threaten the IBM i
- (Commentary)
- ... few years will be the lack of progress on app modernization and the fact that the RPG community seems reluctant to learn new skills and languages." Does Watson Mean Jeopardy for the IBM i? In late ...
- Created on 06 March 2016
- 1162. TechTip : Embedded SQL - Easy String Manipulation Using SQL Functions
- (SQL)
- SQL is always much better than RPG for handling string data. Written by Sumit Goyal Embedding SQL in RPG gives RPG the great power not only to handle database operations but also to perform string manipulation. ...
- Created on 25 February 2016
- 1163. BCD Announces Beta Release of WebSmart for Node.js
- (Development Tools / Utilities)
- ... organizations attract new programmers as the traditional RPG hiring pool shrinks but also facilitate experienced developers as they absorb new technologies. “IBM i continues to transform as a modern ...
- Created on 19 February 2016
- 1164. TechTip: IBM i Services - What It Is
- (SQL)
- ... thing you need to know is SQL. And a lot of us don't. But all of us should. You can argue all day long about whether embedded SQL is better than RPG I/O for use in RPG programs, but you can't argue that ...
- Created on 18 February 2016
- 1165. Rational Developer for i 9.5: New Features You Should Be Using
- (RPG)
- RDi is where you should be doing your RPG development work. Period. Here are some goodies in RDi 9.5 to make your life easier. Written by Brian May I am amazed every time someone asks me why ...
- Created on 16 February 2016
- 1166. TechTip: Riding the Rails, Part 2
- (Scripting)
- ... in the config/routes.rb file to configure how inbound requests should be mapped to your Ruby code. Think of this as being similar to an RPG green-screen program that needs to route processing based on ...
- Created on 11 February 2016
- 1167. TD/OMS Integrates with WebSmart PHP to Enable Robust PHP Web ALM on IBM i
- (Development Tools / Utilities)
- The Remain Software IBM i Application Lifecycle Management solution, TD/OMS is now integrated with WebSmart PHP from BCD Software to enable PHP and RPG developers to deliver high quality and modern web ...
- Created on 11 February 2016
- 1168. SQL 101: String-Related Functions, Part 2 - Changing Case of a String Without %XLATE and More
- (SQL)
- RPG provides a few ways to replace characters in a string, such as the %XLATE BIF. SQL also has interesting—and, more importantly, easy to use—functions to transform strings, changing the case of its characters ...
- Created on 04 February 2016
- 1169. ASNA Announces Business Partners in Morocco and Mexico
- (Mergers / Acquisitions)
- ... brings ASNA's total number of worldwide partners to 32. The Moroccan and Mexican distributors broaden the regions in which ASNA can provide direct sales and support for modernizing IBM i RPG assets. ...
- Created on 04 February 2016
- 1170. Profound Logic Survey Sheds Light on the State of IBM i Legacy Application Modernization
- (Survey Results)
- ... areas that need to be addressed – namely, converting to the use of modern, free-format RPG code; training a new generation of developers in this code; and developing modern Web and mobile applications ...
- Created on 01 February 2016
- 1171. Book Review: Database Design and SQL for DB2
- (DB2)
- ... Database Design and SQL for DB2 manages to do exactly that. This book provides everything an IBM i programmer needs in order to become productive with SQL, particularly in an RPG environment, and manages ...
- Created on 28 January 2016
- 1172. In the Wheelhouse: Dissecting the IBM i Marketplace Survey
- (Analysis of News Events)
- ... and accommodating to people who know languages other than RPG and COBOL. What made me chuckle is that, according to the survey, only 39% of people run an Apache web server. Every IBM i partition runs at ...
- Created on 17 January 2016
- 1173. Eye on the i World
- (Commentary)
- ... web-centric presentations at COMMON on such topics as JavaScript and securing CGI applications written in RPG. Trevor's recent experience has been focused on developing web-faced applications using PHP ...
- Created on 17 January 2016
- 1174. TechTip: Riding the Rails, Part 1
- (Scripting)
- ... Written by Aaron Bartell In the February 2015 article "Trying on a Ruby Ring," I talked about doing a small Hello World Ruby app and showed how to invoke an RPG program from Ruby. In March 2015's article ...
- Created on 14 January 2016
- 1175. CSS Animation for the IBM i
- (Development Tools / Utilities)
- The current incarnation of the web-styling language CSS provides some nice and simple-to-implement animation capabilities. Written by Trevor Seeney The current incarnation of the web-styling language ...
- Created on 12 January 2016
- 1176. Overcoming Common IBM i Mobile Development Challenges
- (Development Tools / Utilities)
- ... A key to outsourcing your mobile development is to find a partner who has a deep understanding of your current systems, RPG source code, and services needed to link mobile applications to existing databases. ...
- Created on 12 January 2016
- 1177. TechTip: Running PHP Scripts: WAMP/MAMP/LAMP
- (Scripting)
- Running RPG programs once they're created is easy. But what about PHP? We created a class-oriented script, but how do we run it? And what kind of setup is required to have a functioning PHP environment? ...
- Created on 07 January 2016
- 1178. Practical SQL: VALUES and DB2 Services
- (SQL)
- Using a combination of SQL and new services, DB2 continues to be an RPG programmer’s best friend. Written by Joe Pluta In a previous article, I introduced you to a powerful SQL statement, VALUES. This ...
- Created on 05 January 2016
- 1179. Profound UI 5.2 Introduces Beta Program for Green-Screen Open Access Handler
- (Development Tools / Utilities)
- ... as AS400) developers to transform legacy RPG code and green screen applications into modern, web and mobile applications. The new features in version 5.2 make it possible for developers to have more control ...
- Created on 05 January 2016
- 1180. "Mission Attainable: Rogue Server
- (IBM i (OS/400, i5/OS))
- ... profiles and TCP communications, then it's time to take a new stance. While the genesis of many poor security practices can be traced back to simpler days of Twinax cabling and RPG II code, it's past time ...
- Created on 03 January 2016
- 1181. What Was Your Favorite Gift from IBM This Year?
- (General)
- ... slow for new languages on a platform where RPG is king, but it's always exciting to me and other likeminded developers to have a new tool to experiment with. Node.js was invented in 2009 to take Google' ...
- Created on 15 December 2015
- 1182. SQL 101: String-Related Functions, Part 1 - Converting Almost Anything to a String
- (SQL)
- ... similar to RPG's %CHAR BIF: it takes a numeric expression as an input parameter and converts it to the respective string representation. If the expression to be converted is either a Decimal or Floating-point ...
- Created on 10 December 2015
- 1183. Remain Software expands Partner Network in North America, Europe and Africa
- (Channel News)
- ... solutions : X-Analysis and RPG ToolBox 2 - with its simplicity of use and flexible pricing model, it addresses companies of any size 3 - its integration with "Gravity", an IBM i task and workflow solution, ...
- Created on 08 December 2015
- 1184. TechTip: PHP Classes: Just When You Thought It Was Over
- (Scripting)
- I promise, this is it, the last section of our opus on creating PHP OO classes. Finally! And believe me, no one is happier than I am. Except that now I have to decide what to write about next. Written ...
- Created on 03 December 2015
- 1185. Practical SQL: Quick Results with VALUES
- (SQL)
- ... to programmers, tasks that might otherwise take many lines of RPG code. ILE RPG has gotten much better at providing some of these base functions and also at making it easy for programmers to write their ...
- Created on 01 December 2015
- 1186. The Remain Software ALM software, TD/OMS integrates with JIRA Software
- (Development Tools / Utilities)
- ... integration with Gravity Task and Workflow Management system significantly improves operations and collaboration within the IT team. TD/OMS is integrated with solutions, such as X-Analysis, RPG Toolbox, ...
- Created on 30 November 2015
- 1187. State of the Tech: Web Application Servers
- (Application Servers)
- ... where one is embraced and the other is an afterthought. An interesting case is the PHP-based architecture that I like to call RAMP (RPG, Apache, MySQL, and PHP). Yes, I realize that MySQL is no longer ...
- Created on 22 November 2015
- 1188. The Business Case for IBM i Green Screen Modernization
- (Development Tools)
- ... of dollars, whereas modernization projects are generally much narrower in scope. Migrating to a new platform offers little advantage over the IBM i and provides a bleak outlook for RPG programmers. For ...
- Created on 22 November 2015
- 1189. TechTip: Drivers, Start Your Nginx!
- (Linux / Open Source)
- ... Those were some tough days for my RPG programmer brain, but I stuck with it. Now I see the advantages of going through many mud puddles. Nginx (pronounced Engine-X) is a very popular web server, ...
- Created on 19 November 2015
- 1190. A Look at IBM i TR3 for 7.2
- (IBM i (OS/400, i5/OS))
- ... designed for a virtualized environment and seeks opportunities to support multiple applications and workload consolidation. If you want more info on it, check this out. RPG Stuff It wouldn't b ...
- Created on 17 November 2015
- 1191. Procedures: How, When, and Why to Build Them
- (RPG)
- Procedures are part of modules. A module can contain one or more procedures. Written by Rafael Victória-Pereira Editor's note: This excerpt is from chapter 3 of Evolve Your RPG Coding: Move ...
- Created on 17 November 2015
- 1192. Technology Focus: The Ranks of Cloud Hosting Providers for IBM i Continue to Burgeon
- (Managed Services / SaaS / PaaS / IaaS)
- ... to combine hosting (operations) and consulting services," confides First Option's Fuller. "But there is also a prospective customer concern that lack of quality consulting resources will prevent their RPG ...
- Created on 15 November 2015
- 1193. SQL 101: Aggregate Functions: Discovering SQL's Hidden Gem
- (SQL)
- ... functions. Written by Rafael Victória-Pereira How do you calculate a total amount based on detail records in RPG? You probably read each record, add the respective amount to a work variable, ...
- Created on 12 November 2015
- 1194. BCD Introduces Presto Mobile App for iOS Devices
- (Mobile Solutions)
- ... is BCD’s solution for rapidly giving existing green screens and new RPG programs a web GUI. “The Presto Mobile app is another example of the investment we’re continually making in Presto and its mobile ...
- Created on 06 November 2015
- 1195. TechTip: PHP Classes: The Final Chapter
- (Scripting)
- No more Mr. Nice Guy. We're going to finish talking about setting up classes, and we're going to use full OO type notation. Don't worry, it ain't that hard. But it looks way weird, so don't freak. ...
- Created on 05 November 2015
- 1196. IBM i ALM from Remain Software ready for IBM Rational Developer for i 9.5
- (Development Tools / Utilities)
- ... Task and Workflow Management system significantly improves operations and collaboration within the IT team. TD/OMS is integrated with solutions, such as X-Analysis, RPG Toolbox, and others which are also ...
- Created on 03 November 2015
- 1197. CAMSS in Conversation: Analytics
- (Business Intelligence)
- ... to any application yet be confident that your data is secure because it's managed at the database level. There are even more examples like with traditional RPG record-level access, one record at a time ...
- Created on 01 November 2015
- 1198. TechTip: Embrace Auto-Updating IBM i Performance Stats in Real Time
- (Scripting)
- ... 20 ROWS ONLY In short, UDTFs are used in similar fashion to RPG's service programs, which hide complexity and provide reusability. In this case, there are likely many things going on under the covers ...
- Created on 30 October 2015
- 1199. Profound Logic Gives Chemical Distributor the Formula for Fast, Affordable Mobile IBM i Development
- (Mobile Solutions)
- ... and design canvases that make anyone a mobile development expert. Profound Mobile utilizes RPG Open Access, which natively opens up RPG code to Web browsers and mobile devices, without re-writing applications. ...
- Created on 23 October 2015
- 1200. CNX Announces Release of Valence Framework 4.2
- (Development Tools / Utilities)
- Features new PHP support, JSON-based Web Services, iAdmin Mobile and more. Features new PHP support, JSON-based Web Services, iAdmin Mobile and more. CNX announced today at the RPG/DB2 Summit in ...
- Created on 21 October 2015