Re: Creating tables via Pro*C using variable names

From: Pete Bergstrom <bergstro_at_src.honeywell.com>
Date: Wed, 20 May 1992 22:20:22 GMT
Message-ID: <1992May20.222022.14175_at_src.honeywell.com>

The short answer is: you can't (at least to my knowledge).

You must use dynamic sql statements a la

---

sprintf(execBuff.arr,"CREATE TABLE %s (LINE NUMBER(5),Txt CHAR(128))",

        OVtableName);
execBuff.len = strlen(execBuff.arr);
EXEC SQL EXEC IMMEDIATE :execBuff;

---

Pete Received on Thu May 21 1992 - 00:20:22 CEST