All Forums Database
Prabhu_Teradata 17 posts Joined 06/12
12 Jul 2012
Insert statement in stored procedure


      Is is possible to use below insert statement in teradata


Insert (col1,col2,col3)


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



Thanks, Prabhu
WAQ 158 posts Joined 02/10
13 Jul 2012

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

Otherwise you can check DBC.SYSEXECSQL

Qaisar Kiani 337 posts Joined 11/05
14 Jul 2012

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

This will work.


Prabhu_Teradata 17 posts Joined 06/12
15 Jul 2012

Thanks a lot WAQ and QAKiani


You must sign in to leave a comment.