Can I MERGE into a view?

The syntax diagram in the documentation seems to indicate that only a table can be merged into while the merge source can be a table, view, or query.  

Note 137202.1 in Metalink seems to indicate that a view CAN be merged into ("You cannot specify DEFAULT when updating a view.")  

I have not been able to create a test case allowing a merge into a view, but it seems to me that it should be allowed since MERGE is an atomic combination of INSERT and UPDATE, both of which can work on views.  

Can anyone enlighten me or point me to some definitive documentation?

-
Baldo Received on Tue Mar 18 2003 - 07:16:01 CET