1 10:39:17 SQL Execute: ORACLE - SELECT ZB0000,MAX(DXSYSL) CS0000,GHH000,XM0000,QSSJ00,XB0000,NL0000,BRBLH0,YPYF00,MAX(ZQCS00) ZQCS00 FROM VW_YJ_SYKP00 where yjdjh0 in (25140794) and yjksbh=13 GROUP BY ZB0000,KDRQ00,QSSJ00,GHH000,XM0000,XB0000,NL0000,BRBLH0,YPYF00 ORDER BY GHH000,ZB0000,QSSJ00 2 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 3 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 4 10:39:17 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 5 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 6 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 7 10:39:17 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 8 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 9 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 10 10:39:17 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 11 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 12 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 13 10:39:17 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 14 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 15 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 16 10:39:17 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 17 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 18 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 19 10:39:17 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 20 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 21 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 22 10:39:17 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 23 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 24 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 25 10:39:17 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 26 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 27 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 28 10:39:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 29 10:39:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 30 10:39:17 SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 31 10:39:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 32 10:39:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 33 10:39:17 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 34 10:39:17 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2,YF_MZCFMX t3 WHERE t2.CFLSH0||'-'||NVL(t2.ZB0000,'0')='4841361 -1'and t3.CXBZ00='Z' and t2.cfid00=t3.CFID00 and t2.CFLSH0='4841361' 35 10:39:17 SQL Execute: ORACLE - select t2.YPMC00 YPMC00,DECode(Sign(t2.CSL000-1),-1,'0','')||t2.csl000||' '||t2.JLDW00 YPGG00,Substrb(t2.YYZF00,1,10)yyzf00 from YS_CFMX00 t2,YF_MZCFMX t3 WHERE t2.CFLSH0||'-'||NVL(t2.ZB0000,'0')='4841361 -2'and t3.CXBZ00='Z' and t2.cfid00=t3.CFID00 and t2.CFLSH0='4841361'