PASING PARAMETERS TO BTEQ

Tools & Utilities
Enthusiast

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

1 REPLY
Enthusiast

Re: PASING PARAMETERS TO BTEQ

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