Insert statement in stored procedure

Database
Enthusiast

Insert statement in stored procedure


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)



 



 


Tags (1)
3 REPLIES
WAQ
Enthusiast

Re: Insert statement in stored procedure

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

Otherwise you can check DBC.SYSEXECSQL

Enthusiast

Re: Insert statement in stored procedure

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

This will work.

Regards,

Enthusiast

Re: Insert statement in stored procedure

Thanks a lot WAQ and QAKiani