prepare update

Posted in 2003

H.J. Sanders — Thu, 15 May 2003 11:22:17 +0200 — source: Usenet: comp.databases.informix

Hello. In order to gain a better performace we would like to "PREPARE" the update statements (usin 4GL). But how to prepare a statement like: UPDATE rms SET rms.* = r_rms.* where rms.rms_uniq = r_rms.rms_uniq A prepare like PREPARE abc FROM "UPDATE rms SET * = ? where rms.rms_uniq = ? " produces sqlerror 201. How to do this besides mentioning all columns ? Tnanks Henk Sanders