Focal Point
COBOL Subroutine that accesses DB2

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

June 29, 2005, 10:46 PM
Ira Bodenheim
COBOL Subroutine that accesses DB2
We are currently calling a COBOL Subroutine from a DEFINE in FOCUS/MF in MVS Batch to retrieve a value from a sequential file. This Subroutine is used from FOCUS as well as from COBOL.

This COBOL Subroutine is going to be changed to retrieve the value from a DB2 Table. A stored procedure will be called from within the new COBOL Subroutine to access the data.

Since we do not use FOCUS to access DB2 - the FOCUS/DB2 Interface is not installed - we would like to continue to use the changed Subroutine from FOCUS and to access DB2 via the COBOL Subroutine.

Do I need to install the FOCUS/DB2 Interface in order to run the Subroutine or can I get away without the installation, since COBOL is actually accessing the data?

Any ideas on the subject would be appreciated.
July 11, 2005, 09:11 PM
Kerry
Hi Ira,
Has the issue regarding COBOL
Subroutine that accesses DB2 been resolved?
I ran a quick search of Focal Point posts and came across the following topics which may be of interest:
DB2 Stored Procedures https://forums.informationbuilders.com/eve/forums/a/...361067331#8361067331 Running a cobol program from WebFocus
https://forums.informationbuilders.com/eve/f...491097331#7491097331 If you still have questions,
another suggestion would be to
open a case with Tech Support.
Please either call Information Builders' Technical Support Help Desk at
1-800-736-6130, or access the o
nline system InfoResponse at http://techsupport.informationbuilders.com. <br /><br />Hope this helps.
Cheers,<br /><br />Kerry

This message has been edited. Last edited by: <Mabel>,