Dynamic SQL inside stored procedure that use host varibales
Hi! I need to generate a dynamic parameterized SQL statement inside of a stored procedure. This can be easily done on all the other DBMS by the USING clause at EXECUTE statement, except on Teradata --- or at least I haven't found it. According the SQL Reference - Stored Procedure manual, one can only use DBC.SysExecSQL to execute a dynamic SQL statement yet this SYsExecSQL does not seem to accept any augment except one string or one string variable. So how do I pass the parameter values that I normally do with USING?