You must first drop rowids before you use ALTER FRAGMENT... DETACH. See the syntax and usage in the IBM Informix Guide to SQL: Syntax.