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.
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
Power10 has arrived in the IBM Power family
22 September 2021
Collection of material to learn about the new Power10
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
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
Changing password level (QPWDLVL system value) from 0/1 to 2/3 with the help of USER_INFO view
4 September 2021
The only one of my customers with password level (QPWDLVL system value) still set to 0 has finally decided to improve the system password complexity by introducing the distinction between upper and lower case and by increasing the minimum length (from 8 to 10). Better late than never!