You would create an alias to the member on that file using the following in SQL:
CREATE ALIAS aliaslib/aliasname FOR filelib/file (member)
The alias you created can be used in a SELECT * FROM aliaslib/aliasname, The data you would be looking at is in the member you built the alias over.
To dispose of the alias once you are done execute the follwoing SQL statement.
DROP ALIAS aliaslib/aliasname
Last Wiki Answer Submitted: August 26, 2008 5:35 pm by WaltZ400645 pts.