If you have a multi-member file on the AS400, and need to look at member C instead of the first default member, here is the instructions:
First, we need to create an alias for the member. For this, we run this SQL command:
CREATE ALIAS ALIAS1 FOR LIB1/FILE1(C)
Now, the SQL is looking in member C of file FILE1, in library LIB1.
Next, we can simply perform any SQL command over the alias ALIAS1:
SELECT * FROM ALIAS1
This would list all records from member C on the screen.
Remember to drop the alias when you are finished. Otherwise, the next person might try to create an alias called ALIAS1, but it would already exist.
DROP ALIAS ALIAS1
Have fun!
