Re: ? Dynamic SQL ?

Posted in 1995

Kerry Sainsbury — Sun, 07 May 1995 19:53:28 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3ofi3g$35v@cssun.mathcs.emory.edu>, BENDJENAHI@IST.CERIST.DZ wrote: > > In a 4gl application, I have a requirment to use a dynamic query SQL > containing program variables. > For example, I want to use in query CREATE TABLE ... a prgram variables > containing table name and list of fields and their types. LET l_sql = "CREATE TABLE ", l_tablename, "(", l_columnname, " ", l_datatype, ")" PREPARE create_table FROM l_sql EXECUTE create_table ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.2 Mar 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html