Last Updated on 5 January 2023 by Roberto De Pedrini
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
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
