Archives of the TeradataForum

Message Posted: Fri, 23 Nov 2002 @ 01:56:04 GMT

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

From Chpater 4 of Volume 6 of the teradata SQL referfence manual.

Dynamic SQL Statements that Cannot Be Used in Stored Procedures The following SQL statements cannot be used as dynamic SQL in stored procedures:

     CALL
     CREATE PROCEDURE
     DATABASE
     EXPLAIN
     HELP
     REPLACE PROCEDURE
     SELECT
     SELECT - INTO
     SET SESSION ACCOUNT
     SET SESSION COLLATION
     SET SESSION DATEFORM
     SET TIME ZONE
     SHOW

Select is not allowed in dynamic SQl.

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