You used the WITH NO LOG option in the wrong context. Use it only when you create a TEMP table and you wish to exclude transaction log operations on it. See the IBM Informix Guide to SQL: Syntax for the SQL syntax and proper usage of the WITH NO LOG option.