![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1yF8m9sQ5ACDbw1hYJTIZvXbm1ntoXEmAzOxL_gIh1TIk3OkWu9QXo9W2f2xTlQOepKtHHagsZlFLFGF2oJI1_qtipscreNJI-thi2gY8pXoPFeAMyfdNKJSTPjNTlnlEUCF5OVtfQn3p0qLmCWWM6fCHMDhjx7He58vrrazR-yuw7EpXT-RA1z6Vcx0/s200/sql.png)
The SQL Create Alias statement was enhanced in the latest round of Technology Refreshes, IBM i 7.5 TR4 and IBM i 7.4 TR10. Previously when you created a SQL Alias you had to give a specific member in the DDS Physical file. Now I can use *LAST to denote the most recent member in the Physical file, and what is really cool is if I add another member to the file the Alias will now use that member!
This will be clearer when I show my examples.
First I need a DDS physical file. I called this one MULTIMBR, and it is found in my library MYLIB.
A R RMULTIMBR A FIELD 100A |
I compiled the above DDS Physical file with the following command:
01 CRTPF FILE(MYLIB/MULTIMBR) SRCFILE(MYLIB/DEVSRC) MAXMBRS(*NOMAX) |