06
Mon, Jan
2 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 3549 results found.

Search for:
Search Only:

Page 16 of 71

751. 2022 IBM i Marketplace Survey Results
(Operating Systems)
... on IBM i continues, and RPG usage soars. The amount of development that takes place on IBM i is always a particular area of interest in our research and this year RPG usage has soared to 93%. We are ...
Created on 07 February 2022
752. Practical SQL: Matching Records with UNION
(SQL)
... ways to get around in SQL using partitions, but it requires some syntax that I don’t find particularly easy to write (or read!). Instead, I prefer to write an RPG program to process the records because ...
Created on 31 January 2022
753. ILE Activation Groups, Part 1
(RPG)
... This article is excerpted from chapter 17 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. The activation group is nothing more than a sub-environment in which an application runs. It defines ...
Created on 31 January 2022
754. SQL 101: Time to Sum Up (and You’ll Want to Bookmark This Article)
(SQL)
... corresponding to the topics mentioned. By Rafael Victoria Pereira The database is so integrated into IBM i that you can program for years without having to explicitly use SQL. RPG provides native operation ...
Created on 04 January 2022
755. How Low Code Helps Businesses Modernize their IBM i Apps
(Development Tools)
... way to the number one spot. It’s no secret that RPG developers are retiring faster than they are being created, and it’s an issue that is projected to widen over the next few years. To make matters ...
Created on 29 November 2021
756. Practical SQL: Complex Summarization
(SQL)
... condition, the program model. The easiest way to determine the program model for a program is to see whether the object attribute has LE in it: that is, such as RPGLE or CLLE. But just take a look at what ...
Created on 01 November 2021
757. ILE Binding Language, Part 2
(RPG)
What Binding Language Doesn’t Do 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 articles ...
Created on 01 November 2021
758. 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
759. 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
760. 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
761. 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
762. 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
763. 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
764. 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
765. 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
766. 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
767. 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
768. 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
769. 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
770. 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
771. 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
772. 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
773. 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
774. 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
775. 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
776. 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
777. 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
778. 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
779. 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
780. 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
781. 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
782. 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
783. 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
784. 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
785. 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
786. 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
787. 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
788. 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
789. 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
790. 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
791. 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
792. 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
793. 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
794. 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
795. 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
796. 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
797. 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
798. 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
799. 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
800. 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