1 10:57:14 SQL Prepare: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='JGDY' 2 10:57:14 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='JGDY' 3 10:57:14 SQL Stmt: ORACLE - Fetch 4 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1191.000000 5 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = QXID00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 4 6 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YQDH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = HH 7 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = QXLX00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = JGCL 8 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = QXGNDH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = JGDY 9 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = QXGNMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 结果打印 10 10:57:14 SQL Stmt: ORACLE - Reset 11 10:57:14 SQL Stmt: ORACLE - Close 12 10:57:14 SQL Prepare: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') AND SFTJ00='Y') 13 10:57:14 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') AND SFTJ00='Y') 14 10:57:14 SQL Stmt: ORACLE - Fetch 15 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0001 16 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 17 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 18 10:57:14 SQL Stmt: ORACLE - Reset 19 10:57:14 SQL Stmt: ORACLE - Close 20 10:57:14 SQL Prepare: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='TJBG' 21 10:57:14 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='TJBG' 22 10:57:14 SQL Stmt: ORACLE - Fetch 23 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1191.000000 24 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = QXID00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 12 25 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YQDH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = HH 26 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = QXLX00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = JGCL 27 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = QXGNDH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = TJBG 28 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = QXGNMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 打印体检 29 10:57:14 SQL Stmt: ORACLE - Reset 30 10:57:14 SQL Stmt: ORACLE - Close 31 10:57:14 SQL Prepare: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' AND MZZYBZ='0') 32 10:57:14 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' AND MZZYBZ='0') 33 10:57:14 SQL Stmt: ORACLE - Fetch 34 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0001 35 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 36 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 37 10:57:14 SQL Stmt: ORACLE - Reset 38 10:57:14 SQL Stmt: ORACLE - Close 39 10:57:14 SQL Prepare: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='DYMZBG' 40 10:57:14 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='DYMZBG' 41 10:57:14 SQL Stmt: ORACLE - Fetch 42 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1191.000000 43 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = QXID00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 21 44 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YQDH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = HH 45 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = QXLX00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = JGCL 46 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = QXGNDH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = DYMZBG 47 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = QXGNMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 打印门诊报告 48 10:57:14 SQL Stmt: ORACLE - Reset 49 10:57:14 SQL Stmt: ORACLE - Close 50 10:57:14 SQL Prepare: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' AND MZZYBZ='1') 51 10:57:14 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' AND MZZYBZ='1') 52 10:57:14 SQL Stmt: ORACLE - Fetch 53 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0020 54 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 55 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 56 10:57:14 SQL Stmt: ORACLE - Reset 57 10:57:14 SQL Stmt: ORACLE - Close 58 10:57:14 SQL Prepare: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='DYZYBG' 59 10:57:14 SQL Execute: ORACLE - Select * From VW_JY_YGQXZD where YGBH00='1191' and YQDH00='HH' and QXLX00='JGCL' and QXGNDH='DYZYBG' 60 10:57:14 SQL Stmt: ORACLE - Fetch 61 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1191.000000 62 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = QXID00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 61 63 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YQDH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = HH 64 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = QXLX00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = JGCL 65 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = QXGNDH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = DYZYBG 66 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = QXGNMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 打印住院报告 67 10:57:14 SQL Stmt: ORACLE - Reset 68 10:57:14 SQL Stmt: ORACLE - Close 69 10:57:14 SQL Prepare: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') AND SFJM00='Y') 70 10:57:14 SQL Execute: ORACLE - select * from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') AND SFJM00='Y') 71 10:57:14 SQL Stmt: ORACLE - Fetch 72 10:57:14 SQL Stmt: ORACLE - EOF 73 10:57:14 SQL Stmt: ORACLE - Reset 74 10:57:14 SQL Prepare: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') ) t1 75 10:57:14 SQL Execute: ORACLE - select t1.*,SF_JUDGE_RESULT_ZY(t1.PYRQ00,t1.YBH000) LX0000 from (select DISTINCT ybh000,pyrq00,SFYB00 from JY_YW0000 where PYRQ00='20140617' and SUBSTR(YBH000,1,2)='HH' and SUBSTR(YBH000,3,4) BETWEEN '0001' AND '0050' and JGZT00 in ('8','9') ) t1 76 10:57:14 SQL Stmt: ORACLE - Fetch 77 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0001 78 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 79 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 80 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 81 10:57:14 SQL Stmt: ORACLE - Close 82 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0001') from dual 83 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0001') from dual 84 10:57:14 SQL Blob IO: ORACLE - Return blob data 85 10:57:14 SQL Stmt: ORACLE - Fetch 86 10:57:14 SQL Stmt: ORACLE - Fetch 87 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0002 88 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 89 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 90 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 91 10:57:14 SQL Stmt: ORACLE - Reset 92 10:57:14 SQL Stmt: ORACLE - Close 93 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0002') from dual 94 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0002') from dual 95 10:57:14 SQL Blob IO: ORACLE - Return blob data 96 10:57:14 SQL Stmt: ORACLE - Fetch 97 10:57:14 SQL Stmt: ORACLE - Fetch 98 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0003 99 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 100 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 101 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 102 10:57:14 SQL Stmt: ORACLE - Reset 103 10:57:14 SQL Stmt: ORACLE - Close 104 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0003') from dual 105 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0003') from dual 106 10:57:14 SQL Blob IO: ORACLE - Return blob data 107 10:57:14 SQL Stmt: ORACLE - Fetch 108 10:57:14 SQL Stmt: ORACLE - Fetch 109 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0007 110 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 111 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 112 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 113 10:57:14 SQL Stmt: ORACLE - Reset 114 10:57:14 SQL Stmt: ORACLE - Close 115 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0007') from dual 116 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0007') from dual 117 10:57:14 SQL Blob IO: ORACLE - Return blob data 118 10:57:14 SQL Stmt: ORACLE - Fetch 119 10:57:14 SQL Stmt: ORACLE - Fetch 120 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0009 121 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 122 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 123 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 124 10:57:14 SQL Stmt: ORACLE - Reset 125 10:57:14 SQL Stmt: ORACLE - Close 126 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0009') from dual 127 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0009') from dual 128 10:57:14 SQL Blob IO: ORACLE - Return blob data 129 10:57:14 SQL Stmt: ORACLE - Fetch 130 10:57:14 SQL Stmt: ORACLE - Fetch 131 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0010 132 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 133 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 134 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 135 10:57:14 SQL Stmt: ORACLE - Reset 136 10:57:14 SQL Stmt: ORACLE - Close 137 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0010') from dual 138 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0010') from dual 139 10:57:14 SQL Blob IO: ORACLE - Return blob data 140 10:57:14 SQL Stmt: ORACLE - Fetch 141 10:57:14 SQL Stmt: ORACLE - Fetch 142 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0014 143 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 144 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 145 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 146 10:57:14 SQL Stmt: ORACLE - Reset 147 10:57:14 SQL Stmt: ORACLE - Close 148 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0014') from dual 149 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0014') from dual 150 10:57:14 SQL Blob IO: ORACLE - Return blob data 151 10:57:14 SQL Stmt: ORACLE - Fetch 152 10:57:14 SQL Stmt: ORACLE - Fetch 153 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0020 154 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 155 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 156 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 157 10:57:14 SQL Stmt: ORACLE - Reset 158 10:57:14 SQL Stmt: ORACLE - Close 159 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0020') from dual 160 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0020') from dual 161 10:57:14 SQL Blob IO: ORACLE - Return blob data 162 10:57:14 SQL Stmt: ORACLE - Fetch 163 10:57:14 SQL Stmt: ORACLE - Fetch 164 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0021 165 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 166 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 167 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 168 10:57:14 SQL Stmt: ORACLE - Reset 169 10:57:14 SQL Stmt: ORACLE - Close 170 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0021') from dual 171 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0021') from dual 172 10:57:14 SQL Blob IO: ORACLE - Return blob data 173 10:57:14 SQL Stmt: ORACLE - Fetch 174 10:57:14 SQL Stmt: ORACLE - Fetch 175 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0022 176 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 177 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 178 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 179 10:57:14 SQL Stmt: ORACLE - Reset 180 10:57:14 SQL Stmt: ORACLE - Close 181 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0022') from dual 182 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0022') from dual 183 10:57:14 SQL Blob IO: ORACLE - Return blob data 184 10:57:14 SQL Stmt: ORACLE - Fetch 185 10:57:14 SQL Stmt: ORACLE - Fetch 186 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0023 187 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 188 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 189 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 190 10:57:14 SQL Stmt: ORACLE - Reset 191 10:57:14 SQL Stmt: ORACLE - Close 192 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0023') from dual 193 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0023') from dual 194 10:57:14 SQL Blob IO: ORACLE - Return blob data 195 10:57:14 SQL Stmt: ORACLE - Fetch 196 10:57:14 SQL Stmt: ORACLE - Fetch 197 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0024 198 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 199 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 200 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 201 10:57:14 SQL Stmt: ORACLE - Reset 202 10:57:14 SQL Stmt: ORACLE - Close 203 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0024') from dual 204 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0024') from dual 205 10:57:14 SQL Blob IO: ORACLE - Return blob data 206 10:57:14 SQL Stmt: ORACLE - Fetch 207 10:57:14 SQL Stmt: ORACLE - Fetch 208 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0025 209 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 210 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 211 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 212 10:57:14 SQL Stmt: ORACLE - Reset 213 10:57:14 SQL Stmt: ORACLE - Close 214 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0025') from dual 215 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0025') from dual 216 10:57:14 SQL Blob IO: ORACLE - Return blob data 217 10:57:14 SQL Stmt: ORACLE - Fetch 218 10:57:14 SQL Stmt: ORACLE - Fetch 219 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0027 220 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 221 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 222 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 223 10:57:14 SQL Stmt: ORACLE - Reset 224 10:57:14 SQL Stmt: ORACLE - Close 225 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0027') from dual 226 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0027') from dual 227 10:57:14 SQL Blob IO: ORACLE - Return blob data 228 10:57:14 SQL Stmt: ORACLE - Fetch 229 10:57:14 SQL Stmt: ORACLE - Fetch 230 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0028 231 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 232 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 233 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 234 10:57:14 SQL Stmt: ORACLE - Reset 235 10:57:14 SQL Stmt: ORACLE - Close 236 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0028') from dual 237 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0028') from dual 238 10:57:14 SQL Blob IO: ORACLE - Return blob data 239 10:57:14 SQL Stmt: ORACLE - Fetch 240 10:57:14 SQL Stmt: ORACLE - Fetch 241 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0029 242 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 243 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 244 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 245 10:57:14 SQL Stmt: ORACLE - Reset 246 10:57:14 SQL Stmt: ORACLE - Close 247 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0029') from dual 248 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0029') from dual 249 10:57:14 SQL Blob IO: ORACLE - Return blob data 250 10:57:14 SQL Stmt: ORACLE - Fetch 251 10:57:14 SQL Stmt: ORACLE - Fetch 252 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0030 253 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 254 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 255 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 256 10:57:14 SQL Stmt: ORACLE - Reset 257 10:57:14 SQL Stmt: ORACLE - Close 258 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0030') from dual 259 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0030') from dual 260 10:57:14 SQL Blob IO: ORACLE - Return blob data 261 10:57:14 SQL Stmt: ORACLE - Fetch 262 10:57:14 SQL Stmt: ORACLE - Fetch 263 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0031 264 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 265 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 266 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 267 10:57:14 SQL Stmt: ORACLE - Reset 268 10:57:14 SQL Stmt: ORACLE - Close 269 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0031') from dual 270 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0031') from dual 271 10:57:14 SQL Blob IO: ORACLE - Return blob data 272 10:57:14 SQL Stmt: ORACLE - Fetch 273 10:57:14 SQL Stmt: ORACLE - Fetch 274 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0032 275 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 276 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 277 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 278 10:57:14 SQL Stmt: ORACLE - Reset 279 10:57:14 SQL Stmt: ORACLE - Close 280 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0032') from dual 281 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0032') from dual 282 10:57:14 SQL Blob IO: ORACLE - Return blob data 283 10:57:14 SQL Stmt: ORACLE - Fetch 284 10:57:14 SQL Stmt: ORACLE - Fetch 285 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0033 286 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 287 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 288 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 289 10:57:14 SQL Stmt: ORACLE - Reset 290 10:57:14 SQL Stmt: ORACLE - Close 291 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0033') from dual 292 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0033') from dual 293 10:57:14 SQL Blob IO: ORACLE - Return blob data 294 10:57:14 SQL Stmt: ORACLE - Fetch 295 10:57:14 SQL Stmt: ORACLE - Fetch 296 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0034 297 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 298 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 299 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 300 10:57:14 SQL Stmt: ORACLE - Reset 301 10:57:14 SQL Stmt: ORACLE - Close 302 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0034') from dual 303 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0034') from dual 304 10:57:14 SQL Blob IO: ORACLE - Return blob data 305 10:57:14 SQL Stmt: ORACLE - Fetch 306 10:57:14 SQL Stmt: ORACLE - Fetch 307 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0035 308 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 309 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 310 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 311 10:57:14 SQL Stmt: ORACLE - Reset 312 10:57:14 SQL Stmt: ORACLE - Close 313 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0035') from dual 314 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0035') from dual 315 10:57:14 SQL Blob IO: ORACLE - Return blob data 316 10:57:14 SQL Stmt: ORACLE - Fetch 317 10:57:14 SQL Stmt: ORACLE - Fetch 318 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0036 319 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 320 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 321 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 322 10:57:14 SQL Stmt: ORACLE - Reset 323 10:57:14 SQL Stmt: ORACLE - Close 324 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0036') from dual 325 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0036') from dual 326 10:57:14 SQL Blob IO: ORACLE - Return blob data 327 10:57:14 SQL Stmt: ORACLE - Fetch 328 10:57:14 SQL Stmt: ORACLE - Fetch 329 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0037 330 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 331 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 332 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 333 10:57:14 SQL Stmt: ORACLE - Reset 334 10:57:14 SQL Stmt: ORACLE - Close 335 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0037') from dual 336 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0037') from dual 337 10:57:14 SQL Blob IO: ORACLE - Return blob data 338 10:57:14 SQL Stmt: ORACLE - Fetch 339 10:57:14 SQL Stmt: ORACLE - Fetch 340 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0038 341 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 342 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 343 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 344 10:57:14 SQL Stmt: ORACLE - Reset 345 10:57:14 SQL Stmt: ORACLE - Close 346 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0038') from dual 347 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0038') from dual 348 10:57:14 SQL Blob IO: ORACLE - Return blob data 349 10:57:14 SQL Stmt: ORACLE - Fetch 350 10:57:14 SQL Stmt: ORACLE - Fetch 351 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0039 352 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 353 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 354 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 355 10:57:14 SQL Stmt: ORACLE - Reset 356 10:57:14 SQL Stmt: ORACLE - Close 357 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0039') from dual 358 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0039') from dual 359 10:57:14 SQL Blob IO: ORACLE - Return blob data 360 10:57:14 SQL Stmt: ORACLE - Fetch 361 10:57:14 SQL Stmt: ORACLE - Fetch 362 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0040 363 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 364 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 365 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 366 10:57:14 SQL Stmt: ORACLE - Reset 367 10:57:14 SQL Stmt: ORACLE - Close 368 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0040') from dual 369 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0040') from dual 370 10:57:14 SQL Blob IO: ORACLE - Return blob data 371 10:57:14 SQL Stmt: ORACLE - Fetch 372 10:57:14 SQL Stmt: ORACLE - Fetch 373 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0041 374 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 375 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 376 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 377 10:57:14 SQL Stmt: ORACLE - Reset 378 10:57:14 SQL Stmt: ORACLE - Close 379 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0041') from dual 380 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0041') from dual 381 10:57:14 SQL Blob IO: ORACLE - Return blob data 382 10:57:14 SQL Stmt: ORACLE - Fetch 383 10:57:14 SQL Stmt: ORACLE - Fetch 384 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0042 385 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 386 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 387 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 388 10:57:14 SQL Stmt: ORACLE - Reset 389 10:57:14 SQL Stmt: ORACLE - Close 390 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0042') from dual 391 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0042') from dual 392 10:57:14 SQL Blob IO: ORACLE - Return blob data 393 10:57:14 SQL Stmt: ORACLE - Fetch 394 10:57:14 SQL Stmt: ORACLE - Fetch 395 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0043 396 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 397 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 398 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 399 10:57:14 SQL Stmt: ORACLE - Reset 400 10:57:14 SQL Stmt: ORACLE - Close 401 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0043') from dual 402 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0043') from dual 403 10:57:14 SQL Blob IO: ORACLE - Return blob data 404 10:57:14 SQL Stmt: ORACLE - Fetch 405 10:57:14 SQL Stmt: ORACLE - Fetch 406 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0044 407 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 408 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 409 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 410 10:57:14 SQL Stmt: ORACLE - Reset 411 10:57:14 SQL Stmt: ORACLE - Close 412 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0044') from dual 413 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0044') from dual 414 10:57:14 SQL Blob IO: ORACLE - Return blob data 415 10:57:14 SQL Stmt: ORACLE - Fetch 416 10:57:14 SQL Stmt: ORACLE - Fetch 417 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0045 418 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 419 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 420 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 421 10:57:14 SQL Stmt: ORACLE - Reset 422 10:57:14 SQL Stmt: ORACLE - Close 423 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0045') from dual 424 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0045') from dual 425 10:57:14 SQL Blob IO: ORACLE - Return blob data 426 10:57:14 SQL Stmt: ORACLE - Fetch 427 10:57:14 SQL Stmt: ORACLE - Fetch 428 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0046 429 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 430 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 431 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 432 10:57:14 SQL Stmt: ORACLE - Reset 433 10:57:14 SQL Stmt: ORACLE - Close 434 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0046') from dual 435 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0046') from dual 436 10:57:14 SQL Blob IO: ORACLE - Return blob data 437 10:57:14 SQL Stmt: ORACLE - Fetch 438 10:57:14 SQL Stmt: ORACLE - Fetch 439 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0047 440 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 441 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 442 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 443 10:57:14 SQL Stmt: ORACLE - Reset 444 10:57:14 SQL Stmt: ORACLE - Close 445 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0047') from dual 446 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0047') from dual 447 10:57:14 SQL Blob IO: ORACLE - Return blob data 448 10:57:14 SQL Stmt: ORACLE - Fetch 449 10:57:14 SQL Stmt: ORACLE - Fetch 450 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0048 451 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 452 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 453 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 454 10:57:14 SQL Stmt: ORACLE - Reset 455 10:57:14 SQL Stmt: ORACLE - Close 456 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0048') from dual 457 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0048') from dual 458 10:57:14 SQL Blob IO: ORACLE - Return blob data 459 10:57:14 SQL Stmt: ORACLE - Fetch 460 10:57:14 SQL Stmt: ORACLE - Fetch 461 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0049 462 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 463 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 464 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 465 10:57:14 SQL Stmt: ORACLE - Reset 466 10:57:14 SQL Stmt: ORACLE - Close 467 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0049') from dual 468 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0049') from dual 469 10:57:14 SQL Blob IO: ORACLE - Return blob data 470 10:57:14 SQL Stmt: ORACLE - Fetch 471 10:57:14 SQL Stmt: ORACLE - Fetch 472 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0050 473 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 474 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 475 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = LX0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 476 10:57:14 SQL Stmt: ORACLE - Reset 477 10:57:14 SQL Stmt: ORACLE - Close 478 10:57:14 SQL Prepare: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0050') from dual 479 10:57:14 SQL Execute: ORACLE - select SF_JY_UNION_JYYWID('20140617','HH0050') from dual 480 10:57:14 SQL Blob IO: ORACLE - Return blob data 481 10:57:14 SQL Stmt: ORACLE - Fetch 482 10:57:14 SQL Stmt: ORACLE - Fetch 483 10:57:14 SQL Stmt: ORACLE - EOF 484 10:57:14 SQL Stmt: ORACLE - Reset 485 10:57:14 SQL Stmt: ORACLE - Reset 486 10:57:14 SQL Stmt: ORACLE - Close 487 10:57:14 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 488 10:57:14 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 489 10:57:14 SQL Stmt: ORACLE - Fetch 490 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035 491 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = YYQC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = 福建省老年医院 492 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YYJC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 福建省老年医院 493 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = XKZH00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = +LvAQ0zEkHUMClXO0sg 494 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 495 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = YYDJ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = U 496 10:57:14 SQL Data Out: ORACLE - Column = 7, Name = YYBZ10, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 497 10:57:14 SQL Data Out: ORACLE - Column = 8, Name = YYBZ20, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 498 10:57:14 SQL Data Out: ORACLE - Column = 9, Name = YYFZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 499 10:57:14 SQL Stmt: ORACLE - Reset 500 10:57:14 SQL Stmt: ORACLE - Close 501 10:57:14 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='JY_DYJSZBCFS' 502 10:57:14 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='JY_DYJSZBCFS' 503 10:57:14 SQL Stmt: ORACLE - Fetch 504 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 1 505 10:57:14 SQL Stmt: ORACLE - Reset 506 10:57:14 SQL Stmt: ORACLE - Close 507 10:57:14 SQL Prepare: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '1191' 508 10:57:14 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where NAME00='JYBGDPRT' and YGBH00 = '1191' 509 10:57:14 SQL Stmt: ORACLE - Fetch 510 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 200, Scale = 0, Data = Samsung Universal Print Driver 2 511 10:57:14 SQL Stmt: ORACLE - Reset 512 10:57:14 SQL Stmt: ORACLE - Close 513 10:57:14 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG') 514 10:57:14 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYDYSFDYFCJG') 515 10:57:14 SQL Stmt: ORACLE - Fetch 516 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = N 517 10:57:14 SQL Stmt: ORACLE - Reset 518 10:57:14 SQL Stmt: ORACLE - Close 519 10:57:14 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 520 10:57:14 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JYBGDYSTSFCYGCTQNR') 521 10:57:14 SQL Stmt: ORACLE - Fetch 522 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = N 523 10:57:14 SQL Stmt: ORACLE - Reset 524 10:57:14 SQL Stmt: ORACLE - Close 525 10:57:14 SQL Prepare: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT') 526 10:57:14 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 in ('JY_JGCLDYYLBDYSFGXZT') 527 10:57:14 SQL Blob IO: ORACLE - Return blob data 528 10:57:14 SQL Stmt: ORACLE - Fetch 529 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = NAME00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = JY_JGCLDYYLBDYSFGXZT 530 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = VALUE0, Type = fldZSTRING, Precision = 100, Scale = 0, Data = Y 531 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 532 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = FL0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 检验结果处理-打印 533 10:57:14 SQL Data Out: ORACLE - Column = 6, Name = SYXT00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = J 534 10:57:14 SQL Stmt: ORACLE - Close 535 10:57:14 SQL Prepare: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) 536 10:57:14 SQL Execute: ORACLE - select DISTINCT YQDH00 from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) 537 10:57:14 SQL Stmt: ORACLE - Fetch 538 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YQDH00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = HH 539 10:57:14 SQL Stmt: ORACLE - Reset 540 10:57:14 SQL Stmt: ORACLE - Close 541 10:57:14 SQL Prepare: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='HH' 542 10:57:14 SQL Execute: ORACLE - select BGYS00,BGMC00,YQSM00, HYSL00, BGVIEW from JY_JYYQZD where YQDH00='HH' 543 10:57:14 SQL Stmt: ORACLE - Fetch 544 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = BGYS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 545 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = BGMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = Data_SL1.fr3 546 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = YQSM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 547 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = HYSL00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 548 10:57:14 SQL Data Out: ORACLE - Column = 5, Name = BGVIEW, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 549 10:57:14 SQL Prepare: ORACLE - select distinct decode(sign(count(*)-0),1,'>=',0,'>=','-1','<') FH from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 550 10:57:14 SQL Execute: ORACLE - select distinct decode(sign(count(*)-0),1,'>=',0,'>=','-1','<') FH from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 551 10:57:14 SQL Stmt: ORACLE - Fetch 552 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = FH, Type = fldZSTRING, Precision = 2, Scale = 0, Data = >= 553 10:57:14 SQL Prepare: ORACLE - select * from (select DISTINCT a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') where 1=1 and (ybh000,pyrq00) in (select ybh000,pyrq00 from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 having count(*) >= 0) order by pyrq00,ybh000 554 10:57:14 SQL Execute: ORACLE - select * from (select DISTINCT a.ybh000,a.pyrq00,0 bgdh00,(select nvl(SQBQ00,0) from jy_yw0000 where ybh000=a.ybh000 and pyrq00=a.pyrq00 and rownum=1) sqbq00 from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') where 1=1 and (ybh000,pyrq00) in (select ybh000,pyrq00 from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 having count(*) >= 0) order by pyrq00,ybh000 555 10:57:14 SQL Stmt: ORACLE - Fetch 556 10:57:14 SQL Data Out: ORACLE - Column = 1, Name = YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = HH0001 557 10:57:14 SQL Data Out: ORACLE - Column = 2, Name = PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140617 558 10:57:14 SQL Data Out: ORACLE - Column = 3, Name = BGDH00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 559 10:57:14 SQL Data Out: ORACLE - Column = 4, Name = SQBQ00, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 0.000000 560 10:57:14 SQL Prepare: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where JYYWID IN (select a.JYYWID from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) ) and YQDH00='HH' and (ybh000,pyrq00) in (select ybh000,pyrq00 from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 having count(*) >= 0) and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0 561 10:57:14 SQL Execute: ORACLE - select photo1,bgxmid,ybh000,pyrq00 from jy_jyjg00 where JYYWID IN (select a.JYYWID from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) ) and YQDH00='HH' and (ybh000,pyrq00) in (select ybh000,pyrq00 from vw_jy_jyjg00 where jyywid in (select DISTINCT jyywid from JY_YW0000 a where a.JYYWID in (0,2205042,2233092,2232961,2233030,2233970,2233971,2233973,2233974,2233966,2233941,2233506,2233310,2233850,2233318,2233831,2233617,2233619,2233647,2233649,2233839,2233255,2233256,2233962,2233963,2233107,2233108,2233109,2233110,2233113,2233910,2233911,2233912,2233913,2233914,2233915,2233916,2233453,2233454,2233455,2233456,2233457,2233460,2233461,2233462,2233468,2233441,2233447,2233448,2233449,2233450,2233370,2233371,2233372,2233373,2233690,2233692,2233693,2233694,2233695,2233696,2233697,2233435,2233427,2233428,2233429,2233430,2233431,2233843,2233844,2233791,2233408,2233410,2233411,2233184,2233185,2233186,2233187,2233188,2233211,2233212,2233213,2233216,2233074,2233075,2233076,2233077,2233714,2233716,2233717,2233718,2233719,2233720,2233667,2233668,2233669,2233670,2233894,2233895,2233896,2233897,2233898,2233899,2233954,2233955,2233956,2233957,2233418,2233419,2233420,2233421,2233572,2233573,2233574,2233575,2233576,2233556,2233557,2233558,2233559,2233560,2233561) and a.YQDH00='HH') group by ybh000,pyrq00 having count(*) >= 0) and bgxmid>=999988 and photo1 is not null and nvl(jyywid,0)<>0