Drawing with DB2 for i SQL - Happy New Year 2022!
31 December 2021
Of course one must have time to waste to spend the whole afternoon trying to draw, with recursive SQL queries, Christmas trees, other amenities, the last day of the year (Today 31 December 2021) Actually,…
---
Roberto De Pedrini
Faq400.com
Log4J Vulnerability and IBM i
19 December 2021
(Updated December 26, 2021) Thousands of blog posts and social media have already been written on the vulnerability of the Apache Log4j Library (also known as Log4Shell). Even newspapers and television stations are talking about…
---
Roberto De Pedrini
Faq400.com
Fixed RPG to RPG Free conversion (Power-Coffee nr. 31 by Marco Riva)
20 November 2021
Many of you probably know the Power-Coffee … of our blogger and IBM Champion Marco Riva … a weekly appointment with absolutely interesting technical pills from the IBM i world. In the episode of November…
---
Roberto De Pedrini
Faq400.com
Visual Studio Code - Code for IBM i
18 November 2021
Visual Studio Code is a free development editor that allows us to start programming in any programming language, without changing editors. It supports many languages, including Python, Java, C ++, JavaScript and others. Precisely in…
Transferring objects with ObjectConnect and Enterprise Extender
22 October 2021
It is often necessary to transfer objects from one system to another (files, programs, etc.) to align software (between systems in HA, for example) or to distribute it (between development, testing, and production systems). Usually, this activity is accomplished by transferring save files via FTP, but it is also possible to use the “old” ObjectConnect with the Enterprise Extender support. Let’s see how.
DB2 for i SQL JSON_OBJECT Essential Cheat Sheet
3 October 2021
Whenever I have to create a JSON document for a Post-REST Web Service, I have to open previous programs and do a great job of copying and pasting … I thought that creating a small…
---
Roberto De Pedrini
Faq400.com
Avoid automatic startup of the controlling subsystem at the end of save entire system option on operating systems older than IBM i V7R4
24 September 2021
After many years and numerous versions of the operating system, in the V7R4 version of IBM i, IBM has finally introduced in option 21 of the SAVE menu the “Start controlling subsystem” option to decide whether or not to start the controlling subsystem at the end of the save operation. With a little effort, we can do the same on previous operating system versions as well.