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

Total: 3549 results found.

Search for:
Search Only:

Page 17 of 71

801. 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
802. 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
803. 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
804. 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
805. 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
806. 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
807. 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
808. 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
809. 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
810. 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
811. 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
812. 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
813. 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
814. 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
815. 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
816. 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
817. 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
818. 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
819. 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
820. 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
821. 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
822. 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
823. 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
824. 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
825. 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
826. 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
827. 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
828. 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
829. 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
830. 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
831. 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
832. 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
833. 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
834. 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
835. 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
836. 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
837. 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
838. 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
839. 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
840. 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
841. 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
842. 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
843. 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
844. 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
845. 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
846. 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
847. 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
848. 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
849. 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
850. 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