File indexing completed on 2024-04-06 12:03:13
0001
0002
0003 lastRun=$1
0004
0005 DB="cms_omds_lb"
0006 USER="cms_trg_r"
0007 PASSWORD_FILE=/nfshome0/centraltspro/secure/$USER.txt
0008 PASSWORD=`cat $PASSWORD_FILE`
0009
0010 sqlplus -S ${USER}/${PASSWORD}@${DB} <<EOF
0011 set linesize 500
0012 set wrap on
0013 set heading off
0014 set pagesize 0
0015 set feedback off
0016 SELECT MIN(RUNNUMBER)
0017 FROM
0018 (
0019 SELECT B.RUNNUMBER,
0020 A.GT_KEY,
0021 B.TSCKEY,
0022 C.GT_RUN_SETTINGS_FK
0023 FROM CMS_TRG_L1_CONF.TRIGGERSUP_CONF A,
0024 CMS_WBM.RUNSUMMARY B,
0025 CMS_GT.GT_RUN_SETTINGS_KEY_HISTORY C
0026 WHERE A.GT_KEY IS NOT NULL
0027 AND B.TSCKEY IS NOT NULL
0028 AND C.GT_RUN_SETTINGS_FK IS NOT NULL
0029 AND A.TS_KEY = B.TSCKEY
0030 AND B.RUNNUMBER = C.RUN_NUMBER
0031 AND C.RUN_NUMBER > ${lastRun}
0032 )
0033 ;
0034 EOF
0035
0036 exit