Skip to Content
0
Former Member
Apr 19, 2016 at 08:43 AM

Calling Stored Procedure with Specific Date?

307 Views

Hi all,

I want to call my stored procedure with the date I select, but the date is not defined as a parameter. How can it be done?

Thanks.

CREATE PROCEDURE "_SYS_BIC"."ZBW_SP_LOAD_SD_IS04_DELTA"
LANGUAGE SQLSCRIPT AS 
BEGIN 

DECLARE START_DATE DATE; DECLARE VAR_DATE DATE; DECLARE END_DATE DATE; SELECT TO_DATE(JOB_DATE,'yyyyMMdd') INTO START_DATE FROM "_SYS_BIC"."ZBW_SLT_JOB_DATE" WHERE JOBNAME='SLT_SD_IS04'; SELECT TO_DATE(JOB_DATE,'yyyyMMdd') INTO VAR_DATE FROM "_SYS_BIC"."ZBW_SLT_JOB_DATE" WHERE JOBNAME='SLT_SD_IS04'; SELECT CURRENT_DATE INTO END_DATE FROM DUMMY; WHILE VAR_DATE <= END_DATE DO DELETE FROM "_SYS_BIC"."BW_SD_IS04" where BILL_NUM IN (SELECT DISTINCT BILL_NUM FROM "_SYS_BIC"."uno/CV_SD_IS04" WHERE VBRK_ERDAT=TO_VARCHAR(VAR_DATE,'yyyyMMdd') OR VBAK_ERDAT=TO_VARCHAR(VAR_DATE,'yyyyMMdd')) and DOC_NUMBER IN (SELECT DISTINCT DOC_NUMBER FROM "_SYS_BIC"."uno/CV_SD_IS04" WHERE VBRK_ERDAT=TO_VARCHAR(VAR_DATE,'yyyyMMdd') OR VBAK_ERDAT=TO_VARCHAR(VAR_DATE,'yyyyMMdd'));
INSERT INTO "_SYS_BIC"."BW_SD_IS04" --Keeps going with inserting and selecting attributes...

"