- 801. Case Study: Hörmann Success Story
- (Case Studies)
- ... at its core by the company's own developers under RPG. A total of three developers and the head of DV/ORG are in the central IT department. The Need for Modern Development Tools At Hörmann KG Werne, ...
- Created on 12 December 2019
- 802. IBM i Got New Technology Refreshes in October
- (IBM i (OS/400, i5/OS))
- ... The RPG language of IBM Rational Development Studio for i (RDS) includes overloading for procedure calls. RPG now has a framework to generate many other data languages, such as XML, JSON, YAML, and ...
- Created on 19 November 2019
- 803. SQL 101: Ultra-Flexible Cursors—The Beauty of PREPARE
- (SQL)
- SQL’s PREPARE statement, combined with ILE RPG, can bring unmatched flexibility to your application’s code. Read on to find how you can do it. It’s easier than you think! By Rafael Victória-Pereira Using ...
- Created on 04 October 2019
- 804. How to Make Learning About Node.js a Profound Experience
- (Programming - Other)
- ... is made possible by the Profound.js Connector, which also provides other advantages. These include the ability to let existing RPG and CL code use any Node.js module—as well as Web services, the Internet ...
- Created on 26 September 2019
- 805. TechTip: Let’s Have a Date, Part 1
- (Programming - Other)
- ... all the necessary functionality within itself, it can be a little cumbersome if you (like me) have an RPG background and are used to the built-in opcodes in the RPG language. So for years I have been using ...
- Created on 09 September 2019
- 806. World-Renowned Data Expert Birgitta Hauser Joins Fresche Solutions
- (Channel News)
- ... in 1992. She has been a software and database engineer since 2008, focusing on RPG, SQL, and Web development on IBM i. Most recently, she worked for Toolmaker Advanced Efficiency GmbH, developing a software ...
- Created on 03 September 2019
- 807. SQL 101: Killing Open Query File Operations with SQL Cursors
- (SQL)
- ... File command or OPNQRYF, along with the GOTO and TAG operations codes, sits at the top of the RPG programmer’s worst nightmare list because what (eventually) started as a good, simple idea becomes a huge ...
- Created on 12 August 2019
- 808. Open-Source Tools for Watson, Part 2
- (Analytics & Cognitive)
- ... how do you set up a model? Can you code it up in RPG or Node.js? Do you have to buy a half-million-dollar product suite? Do you need high-rolling data scientists? Yes, excellent questions…and ones we ...
- Created on 16 July 2019
- 809. SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 2
- (SQL)
- Last time around, I introduced the concept of using an SQL cursor as a way to replace the typical RPG opcodes to access data. Now let’s go deeper and find out where cursors can really help you. By Rafael ...
- Created on 09 July 2019
- 810. Practical Linux: M Is for MySQL
- (Linux / Open Source)
- ... green-screen types than PHP. PHP is basically just adding a compiler, and we’re at least used to the difference between COBOL and RPG, even if we don’t code in both. So configuring PHP isn’t a completely ...
- Created on 01 July 2019
- 811. SQL 101: Using SQL Cursors to Replace Record-Level Data Access, Part 1
- (SQL)
- ... keyed-record access, SQL is usually inferior to RPG’s CHAIN operation. However, SQL is a more than fit replacement for Open Query File access or multiple-table access, typically written in RPG with a series ...
- Created on 11 June 2019
- 812. Profound Logic Celebrates 20 Years of Innovation at POWERUp 2019
- (Channel News)
- ... Profound Logic has been dedicated to innovation and giving businesses a path to true modernization, with solutions that include the first browser-based visual designer for RPG, the first commercially available ...
- Created on 15 May 2019
- 813. What to Do When Your AS/400 Talent Retires
- (Career)
- ... most experienced AS/400 resources are reaching retirement age. IT managers hoping to find new IBM i talent to fill their shoes are discovering that the pool of experienced RPG programmers and operators ...
- Created on 14 May 2019
- 814. IBM Champion Liam Allan Joins Seiden Group
- (Channel News)
- ... RPG, and emerging open source technologies. Expands service offerings for Node.js, Git & open source on IBM i Seiden Group, specialists in IBM i open source and API-based application development ...
- Created on 17 April 2019
- 815. IBM Access Client Solutions Gets Major Updates
- (IT Infrastructure - Other)
- ... what we have in RDi with RPG and COBOL, being able to understand the language. SP: Almost like a precompiler? TR: In a way. We’re not prompting you for bad SQL yet, but if you will, this is the next ...
- Created on 15 April 2019
- 816. SQL 101: Your First Embedded SQL Function
- (SQL)
- ... that this series is about SQL, not RPG. However, you’ll see a bit of RPG in this and the next TechTips. My intention is to help you think outside the box and consider using SQL where you normally wouldn’t. ...
- Created on 08 April 2019
- 817. TechTip: The Find Object (FND) Command for the Integrated File System
- (Programming - Other)
- Search the IFS for objects by name and type—excluding the file systems or directories you wish—and save the result to a database file. By Juan Macias Have you struggled to find certain objects in the ...
- Created on 07 February 2019
- 818. 2019 IBM i Marketplace Survey Results
- (Current Events & Commentary)
- ... at least half of their core business applications—and 64% of these are written in-house. RPG remains a go-to technology, but open source development tools such as Apache, Node.js, and Python also support ...
- Created on 21 January 2019
- 819. Breaking the Code: How Open Source Builds Bridges Between New Programmers and Veteran IBM i-ers
- (Programming - Other)
- ... with, you can be an IBM i programmer. Why aren’t there more young IBM i programmers? The received answer is that schools don’t teach RPG or “business programming” anymore and that, as a result, there’s ...
- Created on 17 December 2018
- 820. TechTip: Calling SQL Procedures on the Fly
- (SQL)
- Call SQL procedures from the RPG green-screen easily and retrieve the returned result sets if you are on V5R4 or later. By Juan Macias The command Call SQL Procedure (CALLSQLPRC or CALLP) allows us ...
- Created on 11 December 2018
- 821. John Valance Joins Profound Logic Services Team
- (Channel News)
- ... and modernization on IBM i. Additionally, he's an expert in numerous programming languages RPG, SQL, Java, and PHP. John also acts as a board member for the COMMON user group. John will be entering the ...
- Created on 10 December 2018
- 822. Updating Your Modernization Mindset
- (IBM i (OS/400, i5/OS))
- ... development/administration Rip/replace “legacy” systems with “modern” systems Free-form RPG Modular programming Procedures Prototypes Using Linux partitions UX, UI, web, mobile devices, open ...
- Created on 15 November 2018
- 823. Tim Rowe Explains What Watson Means for the IBM i
- (Analytics & Cognitive)
- ... your back-end office functions, which means you must be able to trigger the Watson REST APIs from within your existing SQL and RPG apps.” “So what’s the plan? Put support for that stuff in 7.4?” Tim ...
- Created on 15 November 2018
- 824. Implementing Business Rules Using Constraints and Triggers
- (Certification / Training)
- ... a Free-Form RPG Program Coding SQL Statements in an RPG Program Coding SQL Statements in a COBOL Program SQL Stored Procedures Implementing Business Rules Using Constraints and Triggers Using ...
- Created on 14 November 2018
- 825. TechTip: Checking Character and Numeric Data with SQL Functions
- (SQL)
- SQL functions that check the validity of character and numeric data in your RPG code can be implemented by using the hexadecimal representation of the data and the SQL predicate REGEXP_LIKE. By Juan ...
- Created on 07 November 2018
- 826. The Importance of IBM i Services
- (IT Infrastructure)
- ... easy? It’s as easy as a table read. Information previously retrieved with RPG programs calling APIs or layers of RUNQRY operations are now often at the end of a simple SQL statement. I’m going to share ...
- Created on 16 October 2018
- 827. Exploring Open Source on IBM i: The PASE Environment
- (IBM i (OS/400, i5/OS))
- ... where you suddenly leave the black and white world of RPG and then land, sometimes with a thud, into the color-filled world of open source. But what the heck is it? It’s an integrated runtime environment ...
- Created on 11 October 2018
- 828. ARCAD releases new Codechecker module to guarantee software quality and reduce DevOps risk
- (Development Tools / Utilities)
- ... release supports RPG Free Form, the most popular language on the IBM i (aka iSeries, AS/400) platform. Other languages including CL, COBOL, DDS and DDL (SQL) will be supported in upcoming releases. Michel ...
- Created on 26 September 2018
- 829. 3 Steps to Better Application Modernization
- (RPG)
- Set up your RPG modernization project for success by first deciding if the app is worth modernizing, then take it slow, set realistic goals, and let go of old programming habits by Rafael Victória-Pereira ...
- Created on 18 September 2018
- 830. ILEditor Comes Out Swinging for Round Two
- (Programming)
- ... update, and we’d like that to stay the same. SP: OK, so tell me some of the things you have coming down the pike. What should we expect to see in the near future? LA: We plan to add things like: RPG ...
- Created on 17 September 2018
- 831. SQL for IBM i: A Database Modernization Guide
- (MC Press Bookstore)
- ... files (typical of many RPG applications), then transform it into a proper SQL database with advanced features that can be used both internally (by an RPG application, for instance) or externally (by a ...
- Created on 03 August 2018
- 832. IBM i CIO Summit Features Db2 for i Briefing with IBM’s Scott Forstie
- (Certification / Training)
- ... and how to attract young developers. On the optional second day, CIO guests can join their developers at the RPG & DB2 Summit free of charge. The October 2 agenda includes sessions on such topics as ...
- Created on 01 August 2018
- 833. Using Apache as a Reverse Proxy on IBM i
- (IBM i (OS/400, i5/OS))
- ... to the mobilerem library. So, if I had an CGIDEV2 RPG program in the mobilerem library called mypgm.pgm, and the URL parsed looked like this: www.mysite.com/mobilerem/mypgm.pgm, then the directive above ...
- Created on 23 July 2018
- 834. Talking About Modernization Isn’t Good Enough
- (General)
- ... they’re out there. I see old RPG code, flat files, green-screens...they all can make that step into the world of free-form RPG, open source, and SQL tables. Bit by bit, program by program, interface by ...
- Created on 18 July 2018
- 835. TechTip: A Primer to Bootstrap 4, Part 1
- (Development Tools / Utilities)
- ... writing an RPG CGI program that will display sales data, Key Performance Indicators (KPIs) to show the production figures for last week, and the order intake split on country areas. Everything now runs ...
- Created on 17 July 2018
- 836. Practical SQL: PREPARE, EXECUTE, and EXECUTE IMMEDIATE
- (SQL)
- ... for a specific customer. Well, that's still easy to do with embedded SQL. We simply add a WHERE clause and use a "host variable" (a fancy name for any variable in our RPG program). The syntax is still simple: ...
- Created on 17 July 2018
- 837. 7 Best Practices for Business Web Application Development
- (Web Languages)
- ... RPG and Business Computing Professional exams. Laura has been involved in the Southeast Michigan iSeries User group since 1988, and has served as group president for over 15 years and as lead organizer ...
- Created on 17 July 2018
- 838. Going off the Rails
- (General)
- Should you be actually building all your IBM i apps directly on IBM i? Maybe not. By Jeff Olen Not so long ago, I was an RPG developer working on IBM i. I’d been doing it for about 15 years when I ...
- Created on 17 July 2018
- 839. Edmodo Partners with IBM Watson Education to Close Learning Gaps using AI
- (Analytics & Cognitive News)
- ... is a vertically integrated, cutting-edge R&D powerhouse with a highly successful track record which includes the development of flagship MMORPGs including Eudemons Online, Heroes Evolved (formerly known ...
- Created on 17 July 2018
- 840. Profound UI Mobile Client Offers Offline Mode; Makes It Even Easier To Take IBM i Anywhere
- (Industry News)
- ... Screens. Ability to directly connect or sync (offline) with a Node.js application, in addition to RPG, on IBM i or other platforms. Offline Mode in Profound UI Mobile Client In previous versions ...
- Created on 19 June 2018
- 841. POWERUp 18 Recap
- (Career)
- ... i, and used IBM i RPGLE web services to communicate via JSON with the front-end configurator program, which also runs on IBM i. The front-end was developed using the Unity open source 3D gaming platform, ...
- Created on 15 June 2018
- 842. Profound Logic Customers and Employees Shine Bright at COMMON POWERUp18 Conference
- (Channel News)
- ... and passionate advocate for RPG and the IBM i platform. He has served as a member of the Strategic Education Team (SET) and a Subject Matter Expert (SME) for several years helping to shape COMMON's education ...
- Created on 05 June 2018
- 843. Practical SQL: More DB2 Services
- (SQL)
- ... directly in an RPG program without having to go through the traditional exercise of creating a work file and then reading through it. Yes, you'll need to use embedded SQL syntax, but I hope you're already ...
- Created on 04 June 2018
- 844. Profound Logic Reveals A Major Update to Their Visual Designer at COMMON POWERUp18
- (Industry News)
- ... a prolific year of research and development for Profound Logic in which we’ve made great strides in delivering solutions for modern, free-format RPG and Node.js development on IBM i. “We are very proud ...
- Created on 29 May 2018
- 845. Reusing Legacy Code in Business Applications for the Web
- (Web Languages)
- ... IBM i system, however, the rules for stored procedures are relatively relaxed; the stored procedure can be written in several languages, including RPG, COBOL, FORTRAN, PL/I, REXX, CL, and C. Stored procedures ...
- Created on 14 May 2018
- 846. Practical RDi: Exploring RDi 9.6, Part 3
- (RPG)
- ... somewhat arbitrary. The Enter key in RDi's LPEX editor for ILE RPG was just such a case. In case the term is unfamiliar, LPEX is just the collective name given to the SEU replacement editors in RDi. While ...
- Created on 30 April 2018
- 847. IBM i Receives Package Manager Support
- (Analysis of News Events)
- ... With confidence, you keep and grow your customer base. Of course, it's a new way to do things. And that may make people a little wary. If you're a meat and potatoes RPG shop that has no interest in open ...
- Created on 13 April 2018
- 848. Profound Logic Expands Professional Services to Include Node.js Projects
- (Channel News)
- ... Framework; a WYSIWYG Visual Designer; a multi-platform Connector that supports IBM i, MySQL, SQL Server, Oracle, and more; and a self-service RPG-to-Node.js Conversion tool (in beta). "Node.js is one ...
- Created on 03 April 2018
- 849. Open Source Development on the IBM i: Getting Started with Ruby
- (Linux / Open Source)
- ... as programmers, are familiar with. It is the implementation of those constructs that can make the "getting started" step a bumpy ride. So, let's get on the horse and ride! Variables Unlike RPG and more ...
- Created on 03 April 2018
- 850. Building an Open-Source Community for IBM i
- (Programming - Other)
- ... community is evolving. IBM i is no longer just an RPG/COBOL box. As the system has added new technologies, more developers are moving out of their comfort zones. There’s still a long way ...
- Created on 30 March 2018