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...
"