DB2Enterprise..Update statement
Posted: Sat Apr 29, 2006 1:02 pm
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...
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...