How to extract program interface information (PCML) embedded in programs or service programs
7 March 2023
What is PCML? Program Call Markup Language (PCML) is a tag language based on the Extensible Markup Language (XML) that describes the input and output parameters of a program or the exported procedures of a…
How to use REST API on IBM i: the Open Banking example
19 February 2023
The IBM i system, being a robust and versatile business server, can easily connect to the world of REST APIs, enriching the applications it hosts with features taken from the cloud.In today’s example we will…
Writing ILE RPG code with ChatGPT? Let's try!
8 January 2023
There is talk everywhere about this ChatGPT, OpenAI’s new system that allows interaction with Artificial Intelligence systems to be more natural and intuitive. In this video I asked ChatGPT to write for me a simple…
---
Roberto De Pedrini
Faq400.com
Multi-member file and SQL
5 January 2023
I recommend this post by Aldo Succi from his blog “IBM i (AS/400) Fans Only” on the topic of Multimember Physical Files and SQL. The concept of multi-member file is a purely DB2 AS/400 thing…
---
Roberto De Pedrini
Faq400.com
Power coffee no. 19/2022 – Dates and times: default and null values
4 January 2023
I would like to point out this Power Coffee by the legendary Marco Riva, IBM Champion and colleague. In this video (by now only in Italian) we can see how to deal wtih dates/time, default…
---
Roberto De Pedrini
Faq400.com
Static analysis of Cobol and RPG source code on IBM i with SonarQube
20 December 2022
Let's discover a tool that can help in the static analysis of Cobol and RPG source code.
Export source code to IFS
7 December 2022
If you need to export the sources of programs stored on source file members to IFS then the command topic of the article could help you.