1 16:17:05 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 2 16:17:05 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 3 16:17:05 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 4 16:17:05 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 5 16:17:05 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 6 16:17:05 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 7 16:17:05 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 8 16:17:05 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 9 16:17:05 SQL Prepare: ORACLE - Select QZFSID,QZFSMC from BQ_YPQZFS 10 16:17:05 SQL Execute: ORACLE - Select QZFSID,QZFSMC from BQ_YPQZFS 11 16:17:09 SQL Prepare: ORACLE - select * from BM_YPLB00 12 16:17:09 SQL Execute: ORACLE - select * from BM_YPLB00 13 16:17:09 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 14 16:17:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 16:17:09 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 16 16:17:09 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 17 16:17:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 18 16:17:09 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 19 16:17:09 SQL Prepare: ORACLE - select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW from bm_yd0000 A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YKBMBH=478 and TZRQ00 IS NULL order by YPBM00 20 16:17:09 SQL Execute: ORACLE - select A.*,(SELECT SCCJZW FROM BM_YPSCCJ WHERE SCCJBH=A.SCCJBH) SCCJZW from bm_yd0000 A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YKBMBH=478 and TZRQ00 IS NULL order by YPBM00 21 16:17:10 SQL Prepare: ORACLE - select count(1) count0 from bm_yd0000 where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YKBMBH=478 and TZRQ00 IS NULL order by YPBM00 22 16:17:10 SQL Execute: ORACLE - select count(1) count0 from bm_yd0000 where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YKBMBH=478 and TZRQ00 IS NULL order by YPBM00 23 16:17:10 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 24 16:17:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 25 16:17:10 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 26 16:17:10 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 27 16:17:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 16:17:10 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 29 16:21:21 SQL Prepare: ORACLE - update bm_yd0000 set YPNM00 = :1, YKBMBH = :2, YPBM00 = :3, PYSM00 = :4, WBSM00 = :5, YPMC00 = :6, YPGG00 = :7, YPJCL0 = :8, KCDW00 = :9, JLDW00 = :10, ZYFYDW = :11, MZFYDW = :12, K2J000 = :13, Z2J000 = :14, M2J000 = :15, PFJ000 = :16, LSJ000 = :17, ZBJ000 = :18, GJJ000 = :19, CYJL00 = :20, PDXH00 = :21, SFKYYY = :22, SFZBYP = :23, QZFS00 = :24, CFJB00 = :25, LBBH00 = :26, YLBH00 = :27, JXBH00 = :28, SFPSYY = :29, DXSYBZ = :30, ZJBZ00 = :31, SFXY00 = :32, BZ0000 = :33, NSBL00 = :34, JKBH00 = :35, BZGG00 = :36, YPTYM0 = :37, ZDXL00 = :38, NDJCTS = :39 where YPNM00 = :40 30 16:21:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7645.000000 31 16:21:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 32 16:21:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 016001000 33 16:21:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10grxbdb 34 16:21:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10gwtrnr 35 16:21:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 10gÈËѪ°×µ°°× 36 16:21:21 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20%*50ml 37 16:21:21 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.140000 38 16:21:21 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 39 16:21:21 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = ml 40 16:21:21 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 41 16:21:21 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 42 16:21:21 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 43 16:21:21 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 44 16:21:21 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 45 16:21:21 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 16:21:21 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 402.500000 47 16:21:21 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 16:21:21 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 350.000000 49 16:21:21 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 50 16:21:21 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 51 16:21:21 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 52 16:21:21 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 53 16:21:21 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 54 16:21:21 SQL Data In: ORACLE - Param = 25, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 16:21:21 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 16:21:21 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 57 16:21:21 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 001 58 16:21:21 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 59 16:21:21 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 60 16:21:21 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 61 16:21:21 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 62 16:21:21 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 63 16:21:21 SQL Data In: ORACLE - Param = 34, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 64 16:21:21 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 16:21:21 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 66 16:21:21 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 67 16:21:21 SQL Data In: ORACLE - Param = 38, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 16:21:21 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 69 16:21:21 SQL Data In: ORACLE - Param = 40, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7645.000000 70 16:21:21 SQL Execute: ORACLE - update bm_yd0000 set YPNM00 = ?, YKBMBH = ?, YPBM00 = ?, PYSM00 = ?, WBSM00 = ?, YPMC00 = ?, YPGG00 = ?, YPJCL0 = ?, KCDW00 = ?, JLDW00 = ?, ZYFYDW = ?, MZFYDW = ?, K2J000 = ?, Z2J000 = ?, M2J000 = ?, PFJ000 = ?, LSJ000 = ?, ZBJ000 = ?, GJJ000 = ?, CYJL00 = ?, PDXH00 = ?, SFKYYY = ?, SFZBYP = ?, QZFS00 = ?, CFJB00 = ?, LBBH00 = ?, YLBH00 = ?, JXBH00 = ?, SFPSYY = ?, DXSYBZ = ?, ZJBZ00 = ?, SFXY00 = ?, BZ0000 = ?, NSBL00 = ?, JKBH00 = ?, BZGG00 = ?, YPTYM0 = ?, ZDXL00 = ?, NDJCTS = ? where YPNM00 = ? 71 16:21:21 SQL Data In: ORACLE - Rows affected = 1 72 16:21:21 SQL Prepare: ORACLE - commit 73 16:21:21 SQL Execute: ORACLE - commit 74 16:21:21 SQL Data In: ORACLE - Rows affected = 0 75 16:21:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7645.000000 76 16:21:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 77 16:21:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 016001000 78 16:21:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10grxbdb 79 16:21:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10gwtrnr 80 16:21:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 10gÈËѪ°×µ°°× 81 16:21:30 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20%*50ml 82 16:21:30 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.150000 83 16:21:30 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 84 16:21:30 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = ml 85 16:21:30 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 86 16:21:30 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 87 16:21:30 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 88 16:21:30 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 89 16:21:30 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 90 16:21:30 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 91 16:21:30 SQL Data In: ORACLE - Param = 17, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 402.500000 92 16:21:30 SQL Data In: ORACLE - Param = 18, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 93 16:21:30 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 350.000000 94 16:21:30 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 95 16:21:30 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 96 16:21:30 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 97 16:21:30 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 98 16:21:30 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 99 16:21:30 SQL Data In: ORACLE - Param = 25, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 100 16:21:30 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 101 16:21:30 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 16 102 16:21:30 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 001 103 16:21:30 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 104 16:21:30 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 16:21:30 SQL Data In: ORACLE - Param = 31, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 106 16:21:30 SQL Data In: ORACLE - Param = 32, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 107 16:21:30 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 108 16:21:30 SQL Data In: ORACLE - Param = 34, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 109 16:21:30 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 110 16:21:30 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 111 16:21:30 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 112 16:21:30 SQL Data In: ORACLE - Param = 38, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 113 16:21:30 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 114 16:21:30 SQL Data In: ORACLE - Param = 40, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7645.000000 115 16:21:30 SQL Execute: ORACLE - update bm_yd0000 set YPNM00 = ?, YKBMBH = ?, YPBM00 = ?, PYSM00 = ?, WBSM00 = ?, YPMC00 = ?, YPGG00 = ?, YPJCL0 = ?, KCDW00 = ?, JLDW00 = ?, ZYFYDW = ?, MZFYDW = ?, K2J000 = ?, Z2J000 = ?, M2J000 = ?, PFJ000 = ?, LSJ000 = ?, ZBJ000 = ?, GJJ000 = ?, CYJL00 = ?, PDXH00 = ?, SFKYYY = ?, SFZBYP = ?, QZFS00 = ?, CFJB00 = ?, LBBH00 = ?, YLBH00 = ?, JXBH00 = ?, SFPSYY = ?, DXSYBZ = ?, ZJBZ00 = ?, SFXY00 = ?, BZ0000 = ?, NSBL00 = ?, JKBH00 = ?, BZGG00 = ?, YPTYM0 = ?, ZDXL00 = ?, NDJCTS = ? where YPNM00 = ? 116 16:21:30 SQL Data In: ORACLE - Rows affected = 1 117 16:21:30 SQL Prepare: ORACLE - commit 118 16:21:30 SQL Execute: ORACLE - commit 119 16:21:30 SQL Data In: ORACLE - Rows affected = 0