Focal Point
[SOLVED] Query to retrieve info on a data adapter

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/631103391

July 28, 2009, 12:23 PM
Francis Mariani
[SOLVED] Query to retrieve info on a data adapter
Is there a query command I can use to see settings for data adapters when I am not a WebFOCUS server administrator?

Thanks,

This message has been edited. Last edited by: Kerry,


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
July 28, 2009, 12:35 PM
GinnyJakes
SQL DB2 ?


Replace DB2 with whatever engine you are using. I would think this would work even if you are not an admin.

Is this what you are looking for?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 28, 2009, 12:58 PM
Francis Mariani
Ginny,

Thank you! This is exactly what I am looking for.

Cheers,


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
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