1 15:54:59 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 2 15:54:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 3 15:55:02 SQL Prepare: ORACLE - Select * from (select WZMC00,GG0000,WZSXMC,XH0000,KCZSL0,JLDW00,PYSM00,WBSM00,WZID00,KCBMBH,CKPFJ0 from VW_WZ_KCZS00 where (PYSM00 Like :1) and( KCBMBH=208 ) Order By PYSM00) where Rownum<=200 4 15:55:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 5 15:55:02 SQL Execute: ORACLE - Select * from (select WZMC00,GG0000,WZSXMC,XH0000,KCZSL0,JLDW00,PYSM00,WBSM00,WZID00,KCBMBH,CKPFJ0 from VW_WZ_KCZS00 where (PYSM00 Like ?) and( KCBMBH=208 ) Order By PYSM00) where Rownum<=200 6 15:55:09 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 7 15:55:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 8 15:55:16 SQL Prepare: ORACLE - SELECT PZDE00 FROM WZ_PZDE00 WHERE WZID00 =83201 AND KSDM00 =60 9 15:55:16 SQL Execute: ORACLE - SELECT PZDE00 FROM WZ_PZDE00 WHERE WZID00 =83201 AND KSDM00 =60 10 15:55:16 SQL Prepare: ORACLE - SELECT NVL(SUM(KCZSL0),0) JCS000 FROM WZ_KC0000 WHERE WZID00 =83201 AND KCBMBH =208 11 15:55:16 SQL Execute: ORACLE - SELECT NVL(SUM(KCZSL0),0) JCS000 FROM WZ_KC0000 WHERE WZID00 =83201 AND KCBMBH =208 12 15:55:16 SQL Prepare: ORACLE - select SQ_WZ_QLD000_KSQLDH.NEXTVAL KSQLDH from dual 13 15:55:16 SQL Execute: ORACLE - select SQ_WZ_QLD000_KSQLDH.NEXTVAL KSQLDH from dual 14 15:55:16 SQL Prepare: ORACLE - INSERT INTO WZ_QLD000 (KSQLDH,KSQLBZ,CKBMBH ,QLBMBH,QLRQ00,QLSJ00,QLRBH0) VALUES(:1,:2,:3 ,:4,TO_CHAR(SYSDATE,'YYYYMMDD') ,TO_CHAR(SYSDATE,'HH24:MI:SS'),:5) 15 15:55:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 291405.000000 16 15:55:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 17 15:55:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 208.000000 18 15:55:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 19 15:55:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 476.000000 20 15:55:16 SQL Execute: ORACLE - INSERT INTO WZ_QLD000 (KSQLDH,KSQLBZ,CKBMBH ,QLBMBH,QLRQ00,QLSJ00,QLRBH0) VALUES(?,?,? ,?,TO_CHAR(SYSDATE,'YYYYMMDD') ,TO_CHAR(SYSDATE,'HH24:MI:SS'),?) 21 15:55:16 SQL Data In: ORACLE - Rows affected = 1 22 15:55:16 SQL Prepare: ORACLE - INSERT INTO WZ_QLDMX0 (QLMXID,KSQLDH ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,WZDJ00,WZSL00) VALUES(SQ_WZ_QLDMX0_QLMXID.NEXTVAL,:1 ,:2,:3,:4,:5,:6 ,:7,:8,:9) 23 15:55:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 291405.000000 24 15:55:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 83201.000000 25 15:55:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3M9378 26 15:55:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = ÎÀÉú²ÄÁÏ 27 15:55:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = A610ml B10 28 15:55:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 29 15:55:16 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Ì× 30 15:55:16 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 300.000000 31 15:55:16 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 32 15:55:16 SQL Execute: ORACLE - INSERT INTO WZ_QLDMX0 (QLMXID,KSQLDH ,WZID00,WZMC00,WZSXMC,WZGG00,WZXH00 ,WZDW00,WZDJ00,WZSL00) VALUES(SQ_WZ_QLDMX0_QLMXID.NEXTVAL,? ,?,?,?,?,? ,?,?,?) 33 15:55:16 SQL Data In: ORACLE - Rows affected = 1 34 15:55:16 SQL Prepare: ORACLE - Commit 35 15:55:16 SQL Execute: ORACLE - Commit 36 15:55:16 SQL Data In: ORACLE - Rows affected = 0 37 15:55:16 SQL Prepare: ORACLE - COMMIT WORK 38 15:55:16 SQL Execute: ORACLE - COMMIT WORK 39 15:55:18 SQL Prepare: ORACLE - SELECT * FROM WZ_QLDMX0 WHERE 1=2 40 15:55:18 SQL Execute: ORACLE - SELECT * FROM WZ_QLDMX0 WHERE 1=2 41 15:55:19 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 42 15:55:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 43 15:55:29 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 44 15:55:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 45 15:55:39 SQL Prepare: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 46 15:55:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00