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.comWe are pleased to receive and share this "tip & trick" from Patrick Rizzi, which introduces a technique that allows…
I take inspiration from a response by Michael Mayer on the Midrange.com mailing lists to someone who asked how to…
Businesses are increasingly seeking tools to enhance efficiency, collaboration, and resource management. Enterprise Resource Planning (ERP) systems provide a comprehensive…
Early April saw the release of the "Spring Version" of ACS Access Client Solution, version 1.1.9.5 Interesting new features especially…
If the packed agenda of sessions at Common Europe Congress 2024, June 3-6 Milan, wasn't enough for you, here's another…
Debugging functions with Visual Studio Code have been available for some time but this new version 2.10.0 simplifies the handling…