Newsgroups: comp.databases.oracle,alt.cobol From: chadb@NeoSoft.com (Chad A Brockman) Subject: Re: Accessing Oracle database from cobol Organization: NeoSoft Internet Services -- +1 713 684 5969 Date: Fri, 24 Dec 1993 17:37:23 GMT Message-ID: References: <2f95im$kg2@karhu.Helsinki.FI> <1993Dec22.190448.12482@mswinsor> <2fbe4v$g78@karhu.Helsinki.FI> Lines: 48 In article <2fbe4v$g78@karhu.Helsinki.FI> mvarila@karhu.Helsinki.FI (Mikael J Varila) writes: >Mark S. Winsor (wmark@mswinsor) wrote: >: mvarila@karhu.Helsinki.FI (Mikael J Varila) writes: >: > Mark S. Winsor (wmark@mswinsor) wrote: >: > : I have a need to access an Oracle database from some old cobol code that >: > : will be using the Microfocus Cobol/2 compiler on AIX. What do I need, or >: > : is it possible, to do this effectively. >: > >: > One question first: what level of the MF Cobol are you using? Is it perhaps >: > 3.0? Or 1.0 (which is actually VS Cobol)? >: > >: It is 3.1 Microfocus for AIX. > >Good. Here are some impressions I have gathered: > >1. One way is to recode your code to use embedded SQL, and than compile it > with the Oracle precompiler. This is the older method. > >2. The newer one (better one?) is the MF Cobol Transparency System (I am not >quite certain of the name, this is all by memory). This system enables you to >access databases without any modifications to the cobol code and requiring only >a recompile. When you recompile your programs using the Transparency System, >your standard cobol filehandler will be replaced with one, that can access >both standard C-ISAM files, and some databases. You just tell the file handler >which files to map to database tables and what cobol fields equal what table >columns. If I understand correctly, both C-ISAM and database files can be >accessed at the same time. > >This system is not released on the AIX system (correct me if I am wrong), but >will be soon. > > Mikael > Just a quick note on this. We are currently doing the same thing with our Micro Focus code. We checked out the the transparentcy system before Micro Focus bought it and it does work... but it is EXTREAMLY slow. Just thought you would want to know... Chad -- (-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-) ) Chad A.Brockman - ( ( VertiComp, Inc. - I'm just an OS/2 junkie!! ) ) chadb@sugar.NeoSoft.com - (