Re: Cobol example program using OpenVMS RDB routines, of Oracle SQL/ Services Client API (1218 Views)
Reply
Occasional Advisor
Posts: 8
Registered: ‎09-13-2009
Message 1 of 6 (1,296 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
Posts: 315
Registered: ‎05-01-2003
Message 2 of 6 (1,293 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
Posts: 9
Registered: ‎04-02-2009
Message 3 of 6 (1,284 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
Posts: 8
Registered: ‎09-13-2009
Message 4 of 6 (1,235 Views)

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

Thanks a lot

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

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

Thanks
Highlighted
Trusted Contributor
Posts: 397
Registered: ‎12-26-2005
Message 6 of 6 (1,218 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.