- 751. Why Migrate When You Can Modernize?
- (Development Tools)
- ... and you see no sure way to fill their positions with experienced developers. Young developers have not heard of the IBM i, RPG or COBOL; and they prefer languages they know. If you’ve experienced one ...
- Created on 05 October 2021
- 752. SQL 101: Simplifying Application Development with SQL Triggers, Part 2
- (SQL)
- ... INSERT operation, as defined by this line: AFTER INSERT ON MYSCHEMA.TBL_Order_Master I’ll discuss the FOR EACH ROW line later, with another example. Regardless of the origin of the new order (RPG program, ...
- Created on 05 October 2021
- 753. Steve Will Presents IBM i Next Gen Apps — Directions for Developers on October 13
- (Certification / Training)
- RPG & DB2 Summit Keynote Open to the Public System i Developer announces today that Steve Will, IBM i Chief Architect, will deliver the RPG & DB2 Summit Keynote address in an online forum that will be ...
- Created on 14 September 2021
- 754. Apache and Tomcat on IBM i
- (Programming - Other)
- ... in Java and runs very nicely, thank you, on IBM i. I also thought about writing a chapter on Java for IBM developers. I decided against doing that, though, because there is a solid book, Java for RPG Programmers ...
- Created on 08 September 2021
- 755. Practical Java: Start Your Java Engine!
- (Java)
- ... properties. These properties are usually set on the command line by the script that invokes the JVM, but since we're calling this from ILE RPG, we instead make use of the JNI_CreateJavaVM procedure. The ...
- Created on 31 August 2021
- 756. Node.js on IBM i: Jiving with JavaScript
- (Programming - Other)
- ... interprets JavaScript using Google’s V8 JavaScript engine.” So, let’s unpack that. Open source: check! Cross-platform: Yep! Otherwise we’d be talking about ILE RPG as the language. And then the mouthful: ...
- Created on 10 August 2021
- 757. Binding Directories
- (RPG)
- ... Editor's Note: This article is excerpted from chapter 19 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. Please see the previous article here: Service Program Compile Stuff. At this point, ...
- Created on 20 July 2021
- 758. ILE Binding Language, Part 1
- (RPG)
- ... By David Shirey Editor's Note: This article is excerpted from chapter 20 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. Please see the previous article here: Binding Directories. Ready? ...
- Created on 20 July 2021
- 759. IBM i Coding Using VS Code
- (RPG)
- ... with SEU, the Source Entry Utility. It has been around "forever," but it hasn't been updated since 2008 and remains frozen at the V6R1 level. RPG has had significant enhancements since then, and SEU doesn' ...
- Created on 19 July 2021
- 760. System Access in Python
- (Programming - Other)
- ... of SQL goodness is available to you here. I encourage you to experiment (with a test database, of course). Accessing RPG Once again, we have “one call, that’s all” for calling RPG from OSS, and that ...
- Created on 07 July 2021
- 761. SQL 101: Simplifying Application Development with SQL Triggers, Part 1
- (SQL)
- ... the same operations over the database tables. In the end, you’ll have a single program to maintain (the trigger) that RPG, C, JAVA, C#, or other languages will “call” when they perform I/O operations over ...
- Created on 06 July 2021
- 762. Service Program Compile Stuff
- (RPG)
- ... know in order to fully understand and set up your service programs for maximum efficiency. By David Shirey Editor's Note: This article is excerpted from chapter 18 of 21st Century RPG: /Free, ILE, and ...
- Created on 10 June 2021
- 763. Practical Java: Making Java Work for You
- (Java)
- ... a little more about the basics of using Java. ILE RPG and Java If you think about it, there are really three ways for RPG and Java to interact: ILE RPG calls Java Java calls ILE RPG The two ...
- Created on 01 June 2021
- 764. More Programming in Python
- (Programming - Other)
- ... from chapter 9 of Open Source Starter Guide for IBM i Developers, by Pete Helgren. Functions For RPG programmers, at least the more “modern” ones (whoever they are), monolithic code is an anathema. ...
- Created on 05 May 2021
- 765. Exploring More Complex Trigger Scenarios
- (SQL)
- ... were built in the application’s RPG III days and were never properly overhauled, are not working as they should, so we got called in to save the day. Yes, it’s another trigger scenario, a bit different ...
- Created on 04 May 2021
- 766. Introducing Database Triggers
- (SQL)
- ... in RPG or one of the other languages the IBM i supports natively, and SQL triggers. I’ll stick to the same guidelines followed thus far and will discuss only SQL triggers. It’s true that most of the stuff ...
- Created on 15 April 2021
- 767. More Prototyping Stuff
- (RPG)
- Last month, we looked at ILE RPG Prototyping Primer Keywords. In this second act, I want to look at two things. First, let’s finish up with the keywords that we can apply to the prototype subfields. ...
- Created on 15 April 2021
- 768. Practical OSS: MkDocs for the IBM i, Part 2
- (Linux / Open Source)
- ... and CGI in many other places (specifically RPG CGI on the IBM i). More recently, you have PHP, Python, and Ruby. Those languages aren’t dedicated to web development (well, PHP originally was, but that’s ...
- Created on 05 April 2021
- 769. System i Developer Announces 2021 Hands-On Workshops for IBM i Developers
- (Certification / Training)
- ... topics include: RPG Procedures & Service Programs SQL for the RPG Programmer Intermediate SQL for RPG Developers SQL Procedures, Functions and Triggers Python for RPGers RDi Quick Start RDi ...
- Created on 01 March 2021
- 770. Practical SQL: Making Connections
- (SQL)
- ... should be written in RPG, not SQL). Let's consider an example. My environment uses two different costing models: standard cost and average cost. The type of cost used in a given situation depends on a ...
- Created on 05 January 2021
- 771. Fresh Faces Offer a Different Perception of IBM i Workforce
- (Career)
- ... speaking, many IBM i folks are older than I am. It’s the longevity of the platform that has allowed multi-generations to work with it. My dad was an RPG programmer for most of his career, and I just happened ...
- Created on 14 December 2020
- 772. Node.js for Enterprise IBM i Modernization
- (Programming - Other)
- ... businesses on IBM i, these applications are typically very reliable and stable. But in the age of slick mobile apps, cloud development, and an aging RPG developer pool, holding onto outdated application ...
- Created on 02 November 2020
- 773. IBM i Shops Pivot to Battle COVID-19
- (Commentary)
- ... pivot. I haven’t said, “This or that company refactored their RPG application to provide web-based data entry to accommodate new online orders.” While I’m sure that sort of thing has happened, I’m talking ...
- Created on 16 October 2020
- 774. Fresche Announces Completion of End‑to‑End IBM i Application Testing Suite with Launch of Automated IBM i 5250 UI Testing Tool
- (Development Tools / Utilities)
- ... dashboard. The increase in RPG modernization and adoption of DevOps, web and mobile technologies in addition to digital transformation are key factors driving the need for testing automation. X-Replay ...
- Created on 14 October 2020
- 775. SQL 101: A Data Definition Language Hands-on Tour, Part 5
- (SQL)
- ... You’d use it as you’d use a logical file, in the SQL or RPG environments. Note that I didn’t specify “system names” for the view’s columns, so in an RPG context, the column names would appear a bit garbled, ...
- Created on 13 October 2020
- 776. Is 2030 the new Y2K?
- (Industry News)
- In the world of IBM i transformation, time may not be your friend. RPG resource availability is at an all-time low, and forecasts do not look promising for any resurgence. That fact, combined with the ...
- Created on 05 October 2020
- 777. UPDATED: Developer Kit: Making a Business Case for Modernization and Beyond
- (Development Tools)
- ... Source Code Our survey showed that even though most IBM i shops develop new applications in RPG IV, they still maintain many existing programs in RPG III. Business applications running on outdated RPG ...
- Created on 02 October 2020
- 778. Practical SQL: SQL Monitor Part 3, the Program Logic
- (SQL)
- Using identity fields in RPG requires a little SQL, but that SQL can coexist with traditional record-level access, as this monitor program illustrates. By Joe Pluta In my last two articles (1, 2), ...
- Created on 02 October 2020
- 779. Seiden Group and CSC Bring Business-Ready Community PHP to Japan
- (Channel News)
- Collaboration includes enhanced PHP RPMs and support services Today Seiden Group, specialists in IBM i open source development, announces an exclusive partnership with Chubu System Co., Ltd (CSC) to ...
- Created on 21 September 2020
- 780. Fresche Announces Expansion to its Automated Solutions that Accelerate IBM i (AS/400) Application Transformation to Modern Languages
- (Industry News)
- Fresche broadens scope and adaptability of automated solutions to now transform RPG to PHP, producing high quality modern and scalable applications. Fresche Solutions today introduced new capabilities ...
- Created on 17 September 2020
- 781. TechTip: Entering Quotes in CL Variables — A Better Way?
- (CL)
- ... you choose not to quote variables separately. You may have another approach to embedding quotes that you'd like to share. I'm all ears. The FIXQTE and RPLSTR Commands These both call the same RPG ...
- Created on 10 September 2020
- 782. Practical SQL: SQL Monitor Part 2, Defining the Tables
- (SQL)
- ... a question that relates directly to today's topic: How do you define the primary keys for your database files? The primary key is the one you use to get a unique record in the table; in our RPG world, it' ...
- Created on 28 August 2020
- 783. SQL 101: A Data Definition Language Hands-on Tour, Part 4
- (SQL)
- ... this using an RPG program. However, just as in the case of the timestamp that is automatically updated by the database engine, there’s also a way to define, at table level, that the value of a certain ...
- Created on 11 August 2020
- 784. Is Authority Collection a Replacement for the Audit Journal?
- (IBM i (OS/400, i5/OS))
- The short answer to that question is no, but there are at least two scenarios where it makes more sense to use the Authority Collection feature added in V7R3 than the audit journal. Read on for details! ...
- Created on 11 August 2020
- 785. Practical SQL: SQL Monitor Part 1, Using Identities to Store Big Data
- (SQL)
- ... the concept of identity columns. They're simple and powerful, but using them in RPG requires a little practice. I also combined RLA and SQL in the same program, a technique I find very convenient. Finally, ...
- Created on 03 August 2020
- 786. Open-Source Adoption Hurdles Are More Organizational Than Technical, Part 2
- (Programming - Other)
- ... and post it," he says. "If an RPG programmer with more than a few years to go in their career doesn't learn open source, then some of the newer projects may go to another team. By at least being familiar ...
- Created on 13 July 2020
- 787. Open Source and IBM i Security
- (IBM i (OS/400, i5/OS))
- ... able to do as a community with our traditional applications written in RPG: enforce rudimentary object-level controls and not give away the keys to the kingdom with special authorities. Don’t take ...
- Created on 13 July 2020
- 788. SQL 101: A Data Definition Language Hands-on Tour, Part 3
- (SQL)
- ... thus facilitating the access to all item-related data when the table is accessed by an external application, like a web server. Even though this column’s content is not directly accessible in RPG, it can ...
- Created on 08 July 2020
- 789. Practical RDi: Keeping the Object Table View in Perspective
- (RPG)
- ... Simple double-click drilling brings me to the Screen Designer. This is okay, but now, in order to see the related program, I'm going to have to go back up a level, open up my RPG source file, and then ...
- Created on 29 June 2020
- 790. Deliver Innovation and Transform Business Systems Faster with New Profound Logic Services and Leadership
- (Channel News)
- ... transformation options support unique business needs and focus on automation for faster time-to-market. We offer: RPG to Node.js– Transform to the most advanced and proven enterprise language… not ...
- Created on 18 June 2020
- 791. SQL 101: A Data Definition Language Hands-on Tour, Part 2
- (SQL)
- ... change that to prevent problems when InvMst is used in an RPG module. To demonstrate how you can use the table definitions to replace RPG code, I’ll add a Last_Changed timestamp column, common in audited ...
- Created on 09 June 2020
- 792. A Simple Case for COBOL
- (Programming - Other)
- ... into their craft has paid off. Long preamble aside, that investment is an obvious parallel with two programming languages: RPG and COBOL. While both languages have certainly evolved and modernized from ...
- Created on 18 May 2020
- 793. Seiden Group Announces New PHP Migration & Support Services
- (Programming News)
- ... withdrawn) and new Community PHP. Support extends to the full PHP stack, including web server, Db2 for i connectivity, RPG integration, and advice on system upgrades. It also includes proactive monitoring ...
- Created on 13 May 2020
- 794. SQL 101: A Data Definition Language Hands-on Tour, Part 1
- (SQL)
- ... not all, data-related validations from your RPG code and store them in the database, thus making them available to every program that accesses and, most importantly, manipulates the data. In today’s ...
- Created on 12 May 2020
- 795. What to Do When Your AS/400 Talent Retires
- (Resource Center: White Papers)
- IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications ...
- Created on 08 April 2020
- 796. What to Do When Your AS/400 Talent Retires
- (White Papers)
- IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators is small. This guide offers strategies and software suggestions ...
- Created on 08 April 2020
- 797. Developer Kit: Making a Business Case for Modernization and Beyond
- (Development Tools)
- ... new applications in RPG IV, they still maintain many existing programs in RPG III. Business applications running on outdated RPG III limit their functionality and threaten to rack up technical debt for ...
- Created on 17 February 2020
- 798. Next IBM i CIO Summit Tackles Knowledge Transfer, Innovation and More
- (Certification / Training)
- ... their developers at the RPG & DB2 Summit free of charge. The March 24 agenda includes sessions on such topics as IBM i development strategies and direction; a roundtable discussion on Future-Proofing Your ...
- Created on 30 January 2020
- 799. 2020 IBM i Marketplace Survey Results
- (Current Events & Commentary)
- ... relying on it to run at least half of their core business applications and 73% of respondents using applications written in-house. RPG remains a go-to technology, but open source development tools such ...
- Created on 30 January 2020
- 800. Open-Source Adoption Hurdles Are More Organizational Than Technical, Part 1
- (Linux / Open Source)
- ... have written nothing but RPG for years. “Although RPG is very strong for developing business logic, it’s not optimal for creating web applications,” Seiden cites as an example. “So, many companies will ...
- Created on 20 January 2020