Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Problem in compiling Stored procedure
 
From:   Narayan Murthy

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019