sql partition

[Dave]

In SQL 2000, I have paratitioned the data. I have a view that unions the
tables to gether. Is there a way to update the records or add a record
without having to write code to figure out which paratition the record needs
to go in.

[Göran Andersson]

For updating a record it's at least theoritically possible that you
could update the record in the view.

For adding a record the database has no information that could let it
decide where the record would go.

Dave wrote:

In SQL 2000, I have paratitioned the data. I have a view that unions the
tables to gether. Is there a way to update the records or add a record
without having to write code to figure out which paratition the record needs
to go in.

[Dave]

I left out several facts about my partitions. I setup constraints for each
partitions, for instance par1, a-e; par2. f-h ; par 3 i-n; par4 o-z. The
constraining column is part of the primary key. There is no overlap on
columns. There is no other constraint on the partitioning column.

When I try to do an update a record the following error is received, "UNION
ALL view ," name of view, "is not updateable because a partitioning column
was not found." What else needs to be done inorder to do an update?

"Göran Andersson" wrote:

For updating a record it's at least theoritically possible that you
could update the record in the view.

For adding a record the database has no information that could let it
decide where the record would go.

Dave wrote:

In SQL 2000, I have paratitioned the data. I have a view that unions the
tables to gether. Is there a way to update the records or add a record
without having to write code to figure out which paratition the record needs
to go in.