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.comEarly 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…
Two and a half years after my post Transferring objects with ObjectConnect and Enterprise Extender, I finally got around to…
With a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer