Focal Point
[CLOSED] How can I query release of DB2 from FOCUS?

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

September 15, 2010, 09:38 AM
Bruce C. Litzkow
[CLOSED] How can I query release of DB2 from FOCUS?
We are on mainframe FOCUS release 7.0.9. We have the DB2 R/W adapter installed. We are about to upgrade DB2 from V7 to V8. Per IBI instruction, we are reinstalling our DB2 adapter to recognize DB2 V8. Once the adapter has been re-installed, how can I verify from within a FOCUS session what version of DB2 FOCUS is now working with?

This message has been edited. Last edited by: Kerry,
September 15, 2010, 10:42 AM
Francis Mariani
Try running this code in a fex:

SQL DB2 SELECT * FROM TABLE (SYSPROC.ENV_GET_INST_INFO()) AS X;
END



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