- 1151. TechTip: Data Warehouse Updates from IBM i Using SSIS
- (DB2)
- Point-and-click your way to repeatable data updates to or from any database from your DB2 database. Written by Tom Snyder One common theme I’ve experienced through several RPG developer jobs ...
- Created on 26 May 2016
- 1152. What IBM i Execs Should Know, Part 1
- (IBM i (OS/400, i5/OS))
- ... no need to buy a ton of additional packages to go with the i. Almost everything you need is there right out of the box: a database with multiple access methods (RPG IO and SQL), work management systems, ...
- Created on 17 May 2016
- 1153. Townsend Security Announces a Major Step Forward in FieldProc Encryption
- (Compliance / Privacy)
- With Alliance AES/400, IBM i customers with legacy RPG applications can now deploy automatic DB2 encryption over sensitive data which are indexes. Townsend Security Announces a Major Step Forward ...
- Created on 17 May 2016
- 1154. CNX Announces General Release of Valence 5
- (Other Industry Solutions)
- ... queries and dashboards with no programming. The main focus for this newest Valence release is on helping RPG developers provide the most optimal user experience possible in their applications. “We ...
- Created on 16 May 2016
- 1155. Eye on the i World: The i as the Center of a Multiplatform Ecosystem
- (Commentary)
- ... PHP. At the same time, we recognize that proven, existing IBM i RPG applications will continue to serve customers productively and cost-effectively for a very long time. "The vast majority (80 to ...
- Created on 15 May 2016
- 1156. SQL 101: String-Related Functions, Part 5—Cutting and Stitching Strings
- (SQL)
- ... rightmost n characters of a string. Most people know these functions but are not aware that there’s another one, named MID, that would be the long-lost twin brother of RPG’s %SUBSTR BIF if this were a ...
- Created on 12 May 2016
- 1157. Aura Seeks U.S. IBM i Systems Integrators for Multi-Platform & Mobile Integration Solutions
- (Channel News)
- See Easycom, Launcher and SQL iPlug Toolkits in Booth 110 at the New Orleans COMMON User Group Conference, May 15-17, 2016. See Easycom, Launcher and SQL iPlug Toolkits in Booth 110 at the New ...
- Created on 12 May 2016
- 1158. TechTip: Additional PHP Tools—BCD Software
- (Scripting)
- ... uses the standard Zend toolkit to interface your scripts with existing RPG code. But there’s one more thing. BCD is an i company. They understand the machine and the people who use it. And there ...
- Created on 05 May 2016
- 1159. Practical SQL: GET DIAGNOSTICS
- (SQL)
- ... version requires fewer statements than even the simplest native I/O loop, which would have a minimum of 9 or 10 lines of RPG code. setll *start WOHEAD; read WOHEAD; dow not ...
- Created on 03 May 2016
- 1160. 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
- 1161. 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
- 1162. 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
- 1163. 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
- 1164. 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
- 1165. 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
- 1166. 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
- 1167. 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
- 1168. 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
- 1169. 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
- 1170. 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
- 1171. 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
- 1172. 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
- 1173. 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
- 1174. 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
- 1175. 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
- 1176. 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
- 1177. 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
- 1178. 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
- 1179. 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
- 1180. 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
- 1181. 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
- 1182. 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
- 1183. 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
- 1184. 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
- 1185. 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
- 1186. 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
- 1187. 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
- 1188. 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
- 1189. "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
- 1190. 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
- 1191. 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
- 1192. 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
- 1193. 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
- 1194. 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
- 1195. 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
- 1196. 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
- 1197. 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
- 1198. 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
- 1199. 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
- 1200. 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