Archives of the TeradataForum

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

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

<-- 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.

Thanks.

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