Hi,
Is is possible to use below insert statement in teradata
Insert (col1,col2,col3)
select
:Variable1 as col1,
table1.column1 as col2,
:variable2 as col3
from table1
(Am not having access to teradata now to test the senario. Please help me out)
I cannot check this either but I think that's possible.
Otherwise you can check DBC.SYSEXECSQL
You surely can combine the table columns and the SP variables in an INSERT statement.
This will work.
Regards,
Thanks a lot WAQ and QAKiani