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
I think you can do it using dynamic sql and CALL DBC.SYSEXECSQL.