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.comIf you work with IBM i, I recommend reading this insightful article by Giancarlo Lui: IBM i System Management: Simpler…
In his recent article "RPG Free and option *convert" , Aldo Succi explores the *CONVERT option in the RPG language,…
Updating Java and DCM Certificates for ECB Exchange Rate Retrieval on IBM i In our blog, we have previously discussed…
We 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…