DB2Enterprise..Update statement

[srikanthd1978]

people,

Can we do an Update statement via DB2 Enterprise on a non-partitioning Key...

I tried to do this but get an error saying that the partitioning key is not present...so is it correct to say that u have to have the Partitioning key in the where clause of the Update statement, in order t0 update a partitioned table in DB2 Database.

DB2 does not have this limitation..it allows me to update..but from datasatge..i get the error and the job aborts..

any clues ??

Thanks...