Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 17:49:31 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Dynamic SQL inside SPL
From:   Ferry, Craig

I'm trying to see if Dynamic SQL works in SPL. The relevant code follows:

   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);

When I do this I receive the following error:

SPL1078:E(L303), User is not authorized to use the DDL/DCL/Dynamic SQL statement

Has anyone encountered this before? Is this something that is possible?



  <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