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 that does not exist in other databases and which generally leads to several problems in modernization projects that see the use of other languages and tools or porting of cross-platform applications.
I purposely said AS/400 because I guess a modern development on IBM i doesn’t involve the use of multi-member files.
However, as often happens, we can find ourselves dealing with multi-member files of old applications and having to access them via SQL, so here’s this tutorial by Aldo Succi that fits perfectly:
IBMI (AS400) FANS ONLY – HOW TO ACCESS MULTIMEMBER PHYSICAL FILE USING SQL ALIAS
--- Roberto De Pedrini Faq400.com👉 Review: Bob Cozzi’s RPG IV to RPG Free Conversion – a useful VS Code extension for RPG modernization If…
Hello everyone, I’d like to highlight another excellent contribution by Massimo Duca, part of his ongoing IBM i & SQL…
Intrigued by some recent posts from Cristian Larsen on LinkedIn (New Release – Display File DDS Edit v 0.10.1), I…
Hello everyone, Today I’d like to draw your attention to a major new announcement from IBM: Project Bob — a…
I want to share with you a particularly useful article by Massimo Duca in the IBM i & SQL Tips…
Hello everyone, I’d like to highlight a very useful article by Marco Riva on Markonetools, where he clearly explains how…