Re: Q: FROM clause of SELECT statement?

Posted in 1997

Rudy Fernandes — Thu, 20 Mar 97 05:34:28 GMT — source: Informix-list mailing list archive (1991-1998)

In article <332F3717.41C6@quality.com>, Arun Jamwal <jamwal@quality.com> wrote: >Hi everyone! > >I want to do a SELECT where FROM table-name is unknown >until the runtime. The sample code follows: PREPARE your statement. For example . LET l_select = 'SELECT * FROM ', l_tablename, '....' PREPARE stmt_1 FROM l_select DECLARE anytab_curs CURSOR FOR stmt_1 . HTH ---------------------- Rudy Fernandes (ICP) GIC, Kuwait ----------------------