Insert statement in stored procedure

[Prabhu_Teradata1]

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)

[WAQ]

I cannot check this either but I think that's possible.

Otherwise you can check DBC.SYSEXECSQL

[Qaisar_Kiani]

You surely can combine the table columns and the SP variables in an INSERT statement.

This will work.

Regards,

[Prabhu_Teradata1]

Thanks a lot WAQ and QAKiani