1 09:22:58 SQL Execute: ORACLE - select distinct ZBBH00 ZBBH00 from XT_YPMBMX where MBID00=2604 and YPLB00='0' 2 09:22:58 SQL Execute: ORACLE - update xt_yzmb00 set MBMC00 ='1111',PYSM00 ='1111',WBSM00 ='1111',YXBZ00 ='1',BZ0000 ='' Where MBID00 = 2604 3 09:22:58 SQL Data In: ORACLE - Rows affected = 1 4 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2543.000000 5 09:22:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 6 09:22:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3554.000000 7 09:22:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 78 8 09:22:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 9 09:22:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 10 09:22:58 SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 500.000000 11 09:22:58 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = Æ¿ 12 09:22:58 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 13 09:22:58 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Ìì 14 09:22:58 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 09:22:58 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 16 09:22:58 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 17 09:22:58 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 09:22:58 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2543.000000 19 09:22:58 SQL Execute: ORACLE - update xt_ypmbmx set MXID00 = ?, MBID00 = ?, YPNM00 = ?, YFID00 = ?, PCID00 = ?, JL0000 = ?, YPZSL0 = ?, ZLDW00 = ?, YYSJ00 = ?, YYSJDW = ?, ZB0000 = ?, YYZF00 = ?, ZNXH00 = ?, ZBBH00 = ? where MXID00 = ? 20 09:22:58 SQL Data In: ORACLE - Rows affected = 1 21 09:22:58 SQL Execute: ORACLE - Select * from vw_xt_yzmb00_all where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and symbys=1913 and mbgs00='0') order by mbmc00 22 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 23 09:22:58 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 24 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 25 09:22:58 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000,x.BB0000,x.BBID00,x.CJKS00,x.CJKSMC from xt_zlmbmx x where mbid00=? order by xsxh00 26 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 27 09:22:58 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 28 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 29 09:22:58 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 30 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 31 09:22:58 SQL Execute: ORACLE - select x.mxid00,x.mbid00,x.yzlb00,x.clbz00,x.zlxmid,x.zhxmbz, x.zlxmjc,x.xsxh00,x.ts0000,x.tsdw00,x.pcid00,x.pcmc00, x.mcsl00,x.dw0000,x.bz0000,x.BB0000,x.BBID00,x.CJKS00,x.CJKSMC from xt_zlmbmx x where mbid00=? order by xsxh00 32 09:22:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2604.000000 33 09:22:58 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,ts0000,m.pcid00, m.jl0000,m.yyzf00,m.xmyfmc,y.ypmc00,f.ypyfmc,y.jldw00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='1' order by zbbh00,znxh00 34 09:22:58 SQL Execute: ORACLE - COMMIT WORK