topic Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API in Operating System - OpenVMS

Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Jose Antonio Rocha — Wed, 23 May 2012 19:52:48 GMT

Hi,

Somebody please can supply me a Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API. Our programmers have strong knowhow in Cobol language but not in C.

Regards

Fernando Rocha.

Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Bob Blunt — Wed, 23 May 2012 20:11:58 GMT

http://www.theminimumyouneedtoknow.com/openvms_application_developer_book.html

and

http://vouters.dyndns.org/tima/

Looks like really good places to start. I'd also recommend Google-ing for your query. Sorry about the second URL if it doesn't link correctly...

bob

Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Mark Hurcombe — Thu, 24 May 2012 03:10:42 GMT

Hi,

Assuming you are using Cobol on OpenVMS and without knowing more of your environment, I would suggest using SQL Module Language to access the Rdb databases. This is well documented in the Rdb manuals. You basically write all of the sql in the sql module file, compile it using the supplied compiler (which comes with Rdb), and then call the sql routines from your Cobol program.

There (normally) are also example programs installed in SYS$COMMON:[SYSHLP.EXAMPLES.RDB72] or whatever version of Rdb you are using when the product is installed.

Cheers,

Mark

Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Jose Antonio Rocha — Mon, 28 May 2012 19:05:13 GMT

Thanks a lot

Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Jose Antonio Rocha — Mon, 28 May 2012 19:06:10 GMT

Thanks

Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API

Richard J Maher — Thu, 31 May 2012 10:58:15 GMT

Weren't you asking for SQL/Service or Dynamic SQL in COBOL instead?