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 …
Assorted IBM i hints and tips #2: Making physical file DDS changes faster, easier, and less risky
No comments:
Post a Comment