Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 10 Aug 2004 @ 19:47:12 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Dynamic Stored Procedure and DBC.SysExecSQL
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, August 10, 2004 15:38 -->

     SET sql_string = 'INSERT INTO pms_tables.sarbrlst (user_id, rpt_date, branch_id) '
                       || 'SELECT user, ' || :p_rpt_datetime
                       || ' branch_id FROM dss_tables.branch WHERE branch_id = '
                       || :p_budget_no ;
        CALL dbc.SysExecSQL(:sql_string);

I don't find DBC.SysExecSQL stored procedure in DBC.

Teradata RDBMS SQL Ref -Data Manipulation Statements chapter 4: Using Dynamic SQL in Stored Procedure has the following.

"The purpose of the CALL DBC.SysExecSQL statement is to check whether or not the creating user is also the immediate owner of the stored procedure and thus has the right to use dynamic SQL."

Can anyone in the group give me what is the stored procedure DBC.SysExecSQL look like or the text for stored procedure.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023