Create SQL Views to interpret QSYS2.DISPLAY_JOURNAL
10 March 2023
The sources (SQL statement) of this post are available on Github at this link: https://github.com/Faq400Git/Create_Display_Journal_Table_View Personally I am a big fan of IBM i Services, that series of SQL Functions (UDF and UDTF) and Stored…
---
Roberto De Pedrini
Faq400.com
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…
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
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
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
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
IFS files management
28 July 2020
I believe that all of us who work in the IBM i environment have happened, and continue to do, to have a multitude of obsolete files in the IFS and waste time locating and delet…
