Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2002 @ 19:58:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subramanya, Girija wrote:

Hi,

this is Dynamic SQL. It is now avialble in Teradata V2r4.1.

    CALL DBC.SysExecSQL(
       'INSERT INTO dba.process_table (process_id,process_name)
        SELECT Process_ID, Process_Name From ' || :tname ||
       'Where process_date = DATE;');

The exact syntax can be found in

Chapter 4 of the Teradata RDBMS SQL Reference - Volume 6 Data Manipulation Statements

www.info.ncr.com...

click on Sql Reference and then find Volume 6 of release 4.1.x.

Please let me know if you need

	<Prev	Next>		<<First	<Prev	Next>	Last>>