Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 14:11:07 GMT

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

There is a restriction on what(SQL Statement type) can be used as parameter w.r.t to the Stored procedure DBC.SysExecSql - one major guy is the SELECT statement(which is not allowed). This also places a restriction on the use of an INSERT-SELECT statement because here again you have the SELECT in picture.

So something like :

.....
set strSQL = 'Select '||colNameParam1||','||colNameParam2||...
                                'FROM '||tblNameParam;';
CALL DBC.SysExecSQL(:strSQL);
.....

The above would through an error.

So the Dynamic SQL as it is called has its restriction.

Regards,

Narayan

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