SQL VIEWS over multi-member files

I am trying to create SQL views over multi-member files. I need to change the view to point to a specific member that was created that day. How would I do this? Do I have to recreate the view every day? How do I point to the specific member in the CREATE VIEW statement? I have tried to remove the member but the system doesn't allow that. The system limits a view to one member because it is a view and not a logical file. I see no way to change the view with an SQL statement. Anyone ever successfully tried this?

Thanks,

Marvin
No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced, traumatized, triggered, and crying for their safe spaces.

Notice: This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. This message may also contain Protected Health Information (PHI) and must be treated confidentially and handled in accordance with HIPAA and other federal and state privacy laws. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately and delete this e-mail (and any accompanying attachments).