Assorted #ibmi hints and tips #3 : Handling multi-member physical files from SQL

Here's another useful possibility I hadn't spotted until recently.

For SQL access to a non-default member, use an alias, e.g.:

CREATE ALIAS QTEMP/MYMBRB FOR MYSCHEMA/MYTABLE (MBRB)

By the way, if you missed hint #2:
Assorted IBM i hints and tips #2: Making physical file DDS changes faster, easier, and less risky ‪#ibmi‬ Nice article at http://search400.techtarget.com/tip/Using-CHGP …