- 1101. April 10, 2020 | Volume 14 Issue 46
- (MC TNT Tips n Techniques)
- - LEAD ARTICLE: Practical Security Tips to Survive COVID-19 and Working from Home - FEATURED ARTICLE: SQL 101: Using ILE RPG Functions as SQL UDFs - FEATURED NEWS: IBM Offers "Watson Assistant for Citizens" ...
- Created on 08 October 2016
- 1102. March 12, 2021 | Volume 14 Issue 56
- (MC TNT Tips n Techniques)
- - LEAD ARTICLE: Managing Authorities to IFS Objects - FEATURED ARTICLE: ILE RPG Prototyping Primer Keywords - FEATURED NEWS: IBM Study Finds Advancing Women is Not a Top Priority for 70 Percent of Global ...
- Created on 08 October 2016
- 1103. July 16, 2021 | Volume 14 Issue 60
- (MC TNT Tips n Techniques)
- - LEAD ARTICLE: File Shares: Accessing Objects in the IFS - FEATURED ARTICLE: System Access in Python - FEATURE EVENT: Capstone RPG & DB2 Summit Conference Announced for October 2021 - NEWS HIGHLIGHT: ...
- Created on 08 October 2016
- 1104. October 15, 2021 | Volume 14 Issue 63
- (MC TNT Tips n Techniques)
- ... - EVENT HIGHLIGHT: Virtual RPG & DB2 Summit - WEBCAST LEARNING: The Biggest Mistakes in IBM i Security - WHITE PAPER DOWNLOAD: Profound Logic Solution Guide - MC VIDEO SHOWCASE: TLAForms - Software ...
- Created on 08 October 2016
- 1105. December 10, 2021 | Volume 14 Issue 65
- (MC TNT Tips n Techniques)
- - LEAD ARTICLE: Getting Started: Sections & a Sample of ILE RPG Programs - FEATURED WHITE PAPER: Progressive Web Apps: Create a Universal Experience Across All Devices - FEATURED NEWS: IBM Launches New ...
- Created on 08 October 2016
- 1106. January 14, 2022 | Volume 14 Issue 66
- (MC TNT Tips n Techniques)
- - LEAD ARTICLE: Getting Started: Free vs. Fixed and Internal Documentation in ILE RPG Programming - FEATURED WHITE PAPER: The Power of Writing Code in a Low-Code Solution - FEATURED NEWS: IBM Welcomes ...
- Created on 08 October 2016
- 1107. May 12, 2023 | Volume 14 Issue 82
- (MC TNT Tips n Techniques)
- ... NEWS: Introducing Monarch 11 for .NET: ASNA's Next Generation RPG Migration Suite - NEWS HIGHLIGHT: IBM Unveils the Watsonx Platform to Power Next-Generation Foundation Models for Business - WHITE PAPER ...
- Created on 08 October 2016
- 1108. May 10, 2017 | Volume 6 Issue 5
- (MC Mobile on Power)
- • LEAD ARTICLE: jQuery Plug-ins, Part 2 - Plug-ins You Never Knew You Couldn’t Live Without • FEATURED ARTICLE: Do-It-Yourself Mobile Apps via the Cloud • NEWS HIGHLIGHT: CNX Announces General Release ...
- Created on 08 October 2016
- 1109. TNT - 2016/10/07 Text 2
- (MC TNT Tips n Techniques)
- Can’t wait? The wait is over…It’s finally here! The latest update to the classic IBM i security reference is now available. Fully secure your IBM i applications and data with help from security guru Carol ...
- Created on 06 October 2016
- 1110. TNT - 2016/10/07
- (MC TNT Tips n Techniques)
- ... October 7, 2016 Free-Format RPG IV Evolve Your RPG Coding: Move from OPM to ILE ... and Beyond Flexible Input, Dazzling Output with IBM i Subfiles in Free-Format RPG ...
- Created on 06 October 2016
- 1111. TNT - 2016/10/07 Text 3
- (MC TNT Tips n Techniques)
- Fundamentals of Technology Project Management, 2nd Edition Whether you’re a project manager, student, software engineer, or IT professional, Fundamentals of Technology Project Management will help you ...
- Created on 06 October 2016
- 1112. SI - 2016/10/03 Text 2
- (MC System Insight)
- ASNA Mobile RPG empowers RPG programmers to create great IBM i-driven smartphone and tablet mobile apps with nothing but plain ol’ RPG. Programmers don’t need to learn obtuse languages like HTML, ...
- Created on 02 October 2016
- 1113. Data-Centric Magic
- (General)
- ... is, we tend to use a procedural language—generally RPG, but it could be COBOL or Java or whatever—to operate on the data that we are dealing with. And this orientation seems so natural and moral that we ...
- Created on 20 September 2016
- 1114. TechTip: Edit Files in the IFS 2
- (General)
- ... (hey, I still use it sometimes). A next step up is the Joe editor, which can be used from an SSH session and actually works decently—yet another editor I use in a pinch. I've also used RPGNextGen.com's editor ...
- Created on 20 September 2016
- 1115. SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date Tricks
- (SQL)
- ... involving months, but it has a much simpler objective: returning the last day of the month. There was an RPG Academy TechTip that readers found controversial, again because SQL would be a better solution ...
- Created on 20 September 2016
- 1116. Benelux Power 2016
- (Certification / Training)
- ... Access for Mobile”, “DB2 for i: Temporal, RCAC, Analytics, IBM i services and more”, “Building applications with new tools: Node.JS, GIT, Orion”, “SQL for IBM i developers”, “Java crash course for RPG ...
- Created on 20 September 2016
- 1117. Partner TechTip: End the Scourge of Ugly Forms!
- (Document Management)
- ... and/or vertical bars to create them within the O-spec of an RPG program. Programmers would output data to a spool file and send that spool file to a tractor-feed line printer loaded with preprinted stock. ...
- Created on 15 September 2016
- 1118. A Strategy to Marry an iPhone App with Your IBMi/iSeries
- (Development Tools / Utilities)
- ... physically connected. Then the data was sent to the workstation controller, a system-level program talking directly to the final destination, the program, usually written in RPG or COBOL. At the final ...
- Created on 13 September 2016
- 1119. TechTip: Edit Files in the IFS
- (General)
- ... use it sometimes). A next step up is the Joe editor, which can be used from an SSH session and actually works decently—yet another editor I use in a pinch. I've also used RPGNextGen.com's editor for IFS ...
- Created on 08 September 2016
- 1120. IBM Rational Developer for i, V9.5.1
- (Other Industry Solutions)
- ... capabilities: Support for Apple Mac OS X operating system Support for ILE RPG O-Spec in the dynamic outline view F1 language-sensitive help that is enabled for SQL in ILE RPG Kerberos authentication ...
- Created on 06 September 2016
- 1121. Using Scope in Linear-Main Programs to Create More Stable Applications
- (RPG)
- Linear-main RPG programs eliminate the RPG logic cycle and add new levels of variable scoping to protect your code from bugs down the road. Written by Brian May While I am no expert in the RPG logic ...
- Created on 16 August 2016
- 1122. SQL 101: Date-Related Functions, Part 3 - Extracting Information from Dates
- (SQL)
- ... for some date fun? Written by Rafael Victória-Pereira Let me start with a quick flashback: an RPG Academy TechTip published in October 2015, explaining how to create an RPG function to calculate the ...
- Created on 16 August 2016
- 1123. TechTip: DB2 Adapter for Shells
- (Scripting)
- ... Before I get too much deeper, it would be good to set the stage for this article. Earlier this week, I had somebody ask whether they could compile RPG code on their Litmis Spaces account. Litmis Spaces ...
- Created on 11 August 2016
- 1124. A Bootstrap Love Affair, Part Three
- (Development Tools / Utilities)
- ... that the slide-to is zero-based, which is different from RPG, for example. 5.0 Here, we define the slider items and the caption text that will be shown when the Carousel is running. Each item is ...
- Created on 09 August 2016
- 1125. Enterprise Mobile Application Management
- (Development Tools / Utilities)
- ... do to overcome them. #1: SYNCHRONIZATION OF CHANGES: Are the right things moving to the right places at the right time when updating the mobile apps? Unlike pushing new RPG updates to the IBM i ...
- Created on 09 August 2016
- 1126. TechTip: Take Open-Source ILE Further
- (General)
- ... RPG in my career, but I love to dabble in anything ILE and PASE in my own time. I enjoy developing open-source software (OSS) for people to use on IBM i, and I also love helping people learn about open ...
- Created on 04 August 2016
- 1127. TechTip: Evolutionary Change and the IBM i Developer
- (General)
- ... its expense in the IT budget Recently released totally free-format RPG programming techniques Don’t fight evolution! Adopt new stuff! The topic of this article resulted from several ...
- Created on 28 July 2016
- 1128. SQL 101: Date-Related Functions, Part 2—Time-Saving Functions
- (SQL)
- 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 ...
- Created on 19 July 2016
- 1129. What IBM i Execs Should Know, Part 2
- (IBM i (OS/400, i5/OS))
- ... decide they’re overworked (and they probably are considering the environment they’re probably running in) and request more help. And now the management that wouldn’t hire another RPG programmer if Chris ...
- Created on 19 July 2016
- 1130. Eye on the i World: BI Tool Vendor Sees Positive Perception of IBM i as Key to the Platform's Futur
- (Commentary)
- ... conferences like the RPG & DB2 Summit," Langston stresses. On the marketing side of things, Langston isn't totally sold on social media as a way to reach IBM i users. "We have a staff person who monitors ...
- Created on 17 July 2016
- 1131. Remain Software Adds Value for Customers in the New Version 8.1 of Their IBM i ALM Software, TD/OMS
- (Development Tools / Utilities)
- ... which they find best for their specific needs. TD/OMS which is already integrated with several top solutions for IBM i development (eg. X-Analysis or RPG Toolbox) opened the ALM doors also for companies ...
- Created on 24 June 2016
- 1132. SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or Timestamp
- (SQL)
- ... by Rafael Victória-Pereira I’ll start by showing how to convert other data types to Date, Time, and Timestamp data. Handling dates and times in RPG has always been a pain. It’s true that the new-ish ...
- Created on 23 June 2016
- 1133. Eye on the i World: Software Tool Vendor Sees IBM's Watson as IBM i Ally Rather Than a Threa
- (Commentary)
- ... to integrate with Watson and the cloud. Our customers will be able to convert RPG to Node.js and to call Node.js applications directly from RPG. Our tools already provide the capability of expanding to ...
- Created on 19 June 2016
- 1134. Budget Dollars Can Be Skin Deep
- (Commentary)
- ... of a new ERP system that runs side by side with the traditional RPG-based green-screen applications. It's a bit of a process of course, moving it piecemeal. Some things can go easily. Some take a bit more ...
- Created on 19 June 2016
- 1135. What’s So Special About the IBM i Community?
- (Commentary)
- ... community, you can go to an IBM i event and stop your favorite author, the lead developer of the RPG compiler, or even the Chief Architect of the operating system and pick their brain. I see it happen ...
- Created on 14 June 2016
- 1136. Open Source on IBM i Gets Hot Hot Hot
- (Analysis of News Events)
- ... TOP that's written in RPG. Let me say that again to make sure I've conveyed the coolness. A young person has created something from scratch, an entirely new programming language, for the IBM i platform. ...
- Created on 09 June 2016
- 1137. BCD Announces GA Release of WebSmart for Node.js
- (Other Industry Solutions)
- ... popularity on the platform. IBM i organizations may choose Node.js to attract new programmers as the traditional RPG hiring pool shrinks, or to facilitate experienced developers as they absorb new technologies. ...
- Created on 03 June 2016
- 1138. WebSmart 11 Simplifies Responsive IBMi Web App Development with Mobile-Friendly Templates
- (Mobile Solutions)
- Use WebSmart to create PHP, Node.js and RPG desktop and mobile applications that use a single code base. Use WebSmart to create PHP, Node.js and RPG desktop and mobile applications that ...
- Created on 03 June 2016
- 1139. WebSmart 11 Simplifies Responsive IBMi Web App Development with Mobile-Friendly Templates
- (Mobile Solutions)
- Use WebSmart to create PHP, Node.js and RPG desktop and mobile applications that use a single code base. Use WebSmart to create PHP, Node.js and RPG desktop and mobile applications that use a single ...
- Created on 03 June 2016
- 1140. BCD’s Presto 6.5: Quickly Customize Presto Skins to Match Your Organization's Look ...
- (Development Tools / Utilities)
- ... of Presto 6.5, their rapid green screen and new RPG application modernization tool. This release includes a new visual skin editor for modifying Presto skins in the Visual Editor. Skins control the overall ...
- Created on 03 June 2016
- 1141. TechTip: Debugging PHP in Studio
- (Scripting)
- ... of Errors Every program has potentially two types of errors. The first is syntax—that is, mistakes in spelling, punctuation, or format that make the code line inoperable. In RPG, that would be ...
- Created on 02 June 2016
- 1142. 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
- 1143. 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
- 1144. 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
- 1145. 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
- 1146. 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
- 1147. 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
- 1148. 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
- 1149. 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
- 1150. 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