We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn't show up in DSPDBR.
And is there really a benefit to not creating it in QTEMP everytime we want to use it?
And finally, is there a different way to access multiple data members in SQL statements other than ALIAS?