Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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?


Thanks

Craig



     
  <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: 27 Dec 2016