Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 11:36:32 GMT

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

I guess there is a limitation on what(kind of statement) can be used within a stored procedure - I guess that's what the error is pointing out:

- No DDLs(All your CREATE/REPLACE) ,

- No DCLs(All your GRANTs)

- No Dynamic SQL (I think something like

               "sel col1, col2 from :vartablename"
          Where you are supplying a tablename at runtime)

Now w.r.t the DBC.Sysexecsql which is used to execute something that is built at the runtime - there could be some limiatations too.

These are the statement that you cannot use with conjunction with Sysexecsql (according to the manuals) There are others too(perhaps you could look into those too).

     * ALTER PROCEDURE
     * CALL
     * CREATE PROCEDURE
     *DATABASE
     *EXPLAIN
     * HELP (all forms)
     * REPLACE PROCEDURE
     * SELECT
     * SELECT ... INTO
     * SET ROLE
     * SET SESSION ACCOUNT
     * SET SESSION COLLATION
     * SET SESSION DATEFORM
     *SET T IME Z ONE
     *SHOW
     * Cursor statements (OPEN, FETCH, CLOSE)

Narayan

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