Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 28, 2009, 03:23 PM
Francis Mariani
Some interesting info in the result of the command:
(FOC1702) ODBC SOURCE IS - : abb
(FOC1703) ODBC USER IS - : useabb02
(FOC1704) ODBC TIMEOUT IS - : 15
(FOC1707) ODBC ISOLATION IS - : RU
(FOC1711) ODBC AUTODISCONNECT OPTION IS - : ON FIN
(FOC1706) ODBC CONCUR IS - : RONLY
(FOC1491) FETCH BUFFERING FACTOR - : 100
(FOC1531) INSERT BUFFERING FACTOR - : 1
(FOC1496) AUTODISCONNECT OPTION IS - : ON FIN
(FOC1441) WRITE FUNCTIONALITY IS - : ON
(FOC1445) OPTIMIZATION OPTION IS - : ON
(FOC1420) OPTIMIZATION OF ALL=ON AS LEFT JOIN - : OFF
(FOC1763) IF-THEN-ELSE OPTIMIZATION IS - : OFF
(FOC1484) SQL ERROR MESSAGE TYPE IS - : DBMS
(FOC1552) INTERFACE DEFAULT DATE TYPE - : NEW
(FOC1446) DEFAULT DBSPACE IS - :
There are a few options that I'd be interested in finding out more about, like IF-THEN-ELSE optimization...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server