Archives of the TeradataForum

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

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

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