Roberto De Pedrini

Drawing with DB2 for i SQL - Happy New Year 2022!

31 December 2021

03 - Open Source (EN)03a - Java (EN)04 - System Administration (EN)04f - Security

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

01 - Programming (EN)

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

02 - DB2 for i (EN)02a - SQL (EN)

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

01 - Programming (EN)01d - Rational RDi and other tools (EN)

Rdi 9.6.0.11 and Isphere (PCML Exception - Search Function)

22 September 2021

Upgrading Rational Rdi to version 9.6.0.11 I encountered a problem with the Isphere plugin … source search has stopped working. Rdi users probably know the great plugin Isphere which offers numerous advantages and, among these,… --- Roberto De Pedrini Faq400.com

06 - Miscellanea (EN)06b - News

IBM i Technology Refresh 7.4 TR5 and 7.3 TR11 - ACS - Rdi - Power10 - Highlights

19 September 2021

As in the Highlitghs of Serie A football, this post aims to highlight the most interesting things of the IBM autumn announcements (for IBM i and Power, with links to posts, videos, webcasts and podcasts… --- Roberto De Pedrini Faq400.com

02 - DB2 for i (EN)02a - SQL (EN)

New QSYS2.HTTP Functions SQL (7.4 TR5 and 7.3 TR11)

19 September 2021

Let's see how to use the new DB2 for i SQL QSYS2.HTTP functions released with Technologyr Refresh TR5 7.4 and TR11 7.3. Let's see the integration with Google Translate API via SQL. --- Roberto De Pedrini Faq400.com

04d - IFS (EN)

ncdu - IFS Disk Space Analyzer

23 August 2021

If we want to check the disk space occupied by IFS files and directories, we have the possibility to install a great utility, NCDU, which allows us to quickly navigate inside IFS (but also inside… --- Roberto De Pedrini Faq400.com