File indexing completed on 2024-04-06 12:03:13
0001
0002
0003 run=$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 B.TSCKEY,
0017 A.GT_KEY,
0018 C.GT_RUN_SETTINGS_FK
0019 FROM CMS_TRG_L1_CONF.TRIGGERSUP_CONF A,
0020 CMS_WBM.RUNSUMMARY B,
0021 CMS_GT.GT_RUN_SETTINGS_KEY_HISTORY C
0022 WHERE A.TS_KEY = B.TSCKEY
0023 AND B.RUNNUMBER = C.RUN_NUMBER
0024 AND C.RUN_NUMBER = ${run}
0025 ;
0026 EOF
0027
0028 exit
