Archives of the TeradataForum
Message Posted: Wed, 21 Jun 2006 @ 16:56:22 GMT
| Subj: | | Re: Dymanic SQL Procedure |
| |
| From: | | John Graas |
IIUC, you'll want to call dbc.SysExecSQL to submit the SQL build within a stored procedure. This will allow one to string together a SQL
statement and then submit for execution.
Look at chapter 4 of the Teradata SQL Reference manual, "SQL Stored Procedures" in section "Using Dynamic SQL in Stored Procedures" on page 116
of the V2R6.1 manuals for a start.
The manual "Teradata SQL Reference" is available on
www.teradata.com
for download.
John
www.jgraas.com
| 
