[CR# 416569] When updating the filename column of a proxy table mapped to a directory of files, Sybase recommends that you qualify the update to specific files by having the filename included in the where clause of the update. Since some file systems may implement a rename as a deletion followed by the creation of a new directory entry, the same filename could be updated multiple times if the update were not restricted.
For example, this statement could cause multiple updates:
update t1 set filename=filename + 'old' where filetype = 'REG'
Workaround: Add a clause such
as 'and filename like '%.c' .
