All Forums Tools
sunny.j 90 posts Joined 10/10
29 Mar 2013
PASING PARAMETERS TO BTEQ

Hi
 
i have the start and end dates in a table and i need to use this dates to call a stored procedure in the Bteq
 
sel start_dt , end_dt  from table1
 
CALL  PROC_CALCULATE( TABLE2, start_dt, end_dt )  -- This procedure will create table for the start and end date
 
please suggest me
 
 

KS42982 137 posts Joined 12/12
29 Mar 2013

I think you can do it using dynamic sql and CALL DBC.SYSEXECSQL.

You must sign in to leave a comment.