Last Updated on 11 September 2025 by Roberto De Pedrini
I want to highlight the second post by Massimo Duca in his SQL Tips series.
In this installment, we see how to use SQL to read a text file in the IFS (Integrated File System) of IBM i—allowing you to include external files (outside the traditional library system) directly in your SQL data flow.
Another very practical tip—thanks Massimo for sharing!
👉 Read the full post on LinkedIn here:
SQL Tips #2 – Reading IFS Files with Massimo Duca
Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more
DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more
Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more
Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more
