Nancy,

You are quite right I never use dbcname!tablename so I forget about it.

>Just a minor technical note: you can USE a view without having the dbc open by including the DBC in the name. For example, USE myDBC!myview will open the database _and_ view.