Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API (1070 Views)
Reply
Occasional Advisor
Jose Antonio Rocha
Posts: 8
Registered: ‎09-13-2009
Message 1 of 6 (1,070 Views)

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

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.

Respected Contributor
Bob Blunt
Posts: 314
Registered: ‎05-01-2003
Message 2 of 6 (1,067 Views)

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

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

Occasional Advisor
Mark Hurcombe
Posts: 8
Registered: ‎04-02-2009
Message 3 of 6 (1,058 Views)

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

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

Occasional Advisor
Jose Antonio Rocha
Posts: 8
Registered: ‎09-13-2009
Message 4 of 6 (1,009 Views)

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

Thanks a lot

Occasional Advisor
Jose Antonio Rocha
Posts: 8
Registered: ‎09-13-2009
Message 5 of 6 (1,007 Views)

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

Thanks
Trusted Contributor
Richard J Maher
Posts: 397
Registered: ‎12-26-2005
Message 6 of 6 (992 Views)

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

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.