You cannot update a base table that is part of any join index. Sybase IQ Reference Manual and Sybase IQ System Administration Guide do not emphasize this restriction and error message “-1000102 Cannot update table %2 because it is defined in one or more join indexes” is undocumented.