Use Variable as Table name in EXEC SQL statements (ESQL/C)

Posted in 1995

Kok-Bin LEE — Wed, 29 Nov 1995 14:23:51 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, I have heard that ORACLE allows string variable (ESQL/C) to be used to reference a table in EXEC SQL statements. eg: EXEC SQL SELECT BOXNO, SHIPREFNO INTO :BoxNo, :ShipRefNo FROM :BOXDETL <<<------- (a C variable) WHERE :BoxNo=:mBoxNo; Can I do the same in INFORMIX? -- +--------------------------------------------------------------------+ | LEE Kok-Bin | | kok-bin_lee@hp-singapore-om1.om.hp.com | | Standard Disclaimer | +--------------------------------------------------------------------+