setlocal
 
:: Define the sql commands:
if exist %WORK_FILE% del %WORK_FILE%
echo execute transport_statistics.CREATE_TRANSPORT_STATISTICS(to_char( trunc( %vorgestern%, 'DD' ), 'DD.MM.YYYY HH24:MI:SS' ),to_char( trunc( %heute%, 'DD' ), 'DD.MM.YYYY HH24:MI:SS' ), 'DD.MM.YYYY HH24:MI:SS' ); >> %WORK_FILE%
echo set verify off; >> %WORK_FILE%
echo set feed off; >> %WORK_FILE%
echo set underline off; >> %WORK_FILE%
echo set colsep " "; >> %WORK_FILE%
echo set head on; >> %WORK_FILE%
echo set trimspool on; >> %WORK_FILE%
echo set linesize 32767; >> %WORK_FILE%
echo set pagesize 32767; >> %WORK_FILE%
echo set wrap off; >> %WORK_FILE%
echo set termout off; >> %WORK_FILE%
echo spool %OUT_FILE%; >> %WORK_FILE%
echo set ECHO OFF; >> %WORK_FILE%
echo select bay_name, INTRABAY_STATISTICS.NUM_TRANSPORTS_IN( bay_name, TRUNC(%vorgestern%, 'DD'), TRUNC(%gestern%, 'DD' ) )+ INTRABAY_STATISTICS.NUM_TRANSPORTS_OUT( bay_name, TRUNC(%vorgestern%, 'DD'), TRUNC(%gestern%, 'DD' ) ) Cycles_per_Day_before ,TO_CHAR( INTRABAY_STATISTICS.AVG_DELIVERY_TIME( bay_name, TRUNC(%vorgestern%, 'DD'), TRUNC(%gestern%, 'DD')) / 60, '9999D99','NLS_NUMERIC_CHARACTERS = '',.'' ' ) AVARAGE_TS_TIME_Day_before ,INTRABAY_STATISTICS.NUM_TRANSPORTS_IN( bay_name, TRUNC(%gestern%, 'DD') , TRUNC(%heute%, 'DD')) + INTRABAY_STATISTICS.NUM_TRANSPORTS_OUT( bay_name, TRUNC(%gestern%, 'DD'), TRUNC(%heute%, 'DD')) Cycles_per_Day, TO_CHAR( INTRABAY_STATISTICS.AVG_DELIVERY_TIME( bay_name, TRUNC(%gestern%, 'DD'), TRUNC(%heute%, 'DD'))/60 ,'9999D99','NLS_NUMERIC_CHARACTERS = '',.'' ' ) AVARAGE_TS_TIME from intrabays where oht_name is not null and BAY_TYPE like 'C'; >> %WORK_FILE%
echo / >> %WORK_FILE%
echo spool off; >> %WORK_FILE%
echo exit >> %WORK_FILE%
start %SQLPLUS_Aufruf%  @%WORK_FILE% >> %ERR_FILE%
endlocal