Embedding SQL in Cobol 1

[Pootytaint]

I have been programming Cobol for a while, but have never used embedded sql in Cobol and am fairly new to SQL. The company I work for now is using a middleware to go in between MF Cobol and Oracle and are wanting to get rid of the middleware and embed SQL or PL/SQL in the code. DOes anyone have any examples or know where I can see actual examples of this?

 

[fredericofonseca]

http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96109.pdf

http://download-uk.oracle.com/docs/cd/B10501_01/win.920/a96113.pdf

You will need to register but it is free.

http://www.microfocus.com

also has information about that that will probably be of more interest to you.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Pootytaint]

Thanks, I have a 500 page .pdf, I guess I was looking for better examples, or maybe I can paste some code and see an exampl eof how to fix it. I just need to get the ball rolling. I appreciate your help.

 

[fredericofonseca]

For examples you can also look as

http://www.microfocus.com

or at

http://www.oracle.com.

If you look at the instalation directories of Oracle you will also have some examples.

http://www.syssoft-int.com/files/rmcprocobv8.zip

also contains some samples (available with Oracle installation) that you can look at.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[landei]

Hi Pootytaint,

look at

http://www.acucorp.com.

There is a product with the name "AcuSQL" but I have never use this tool.

Regards.

Helmut Langguth
Germany

 

[erba]

Give a look and eventially try ProCobol from Oracle.
You must have it from oracle installation.
Look for a programm called procob.exe or procob??.exe or something similar.
You do not need to use ODBC.
Its manual contain all examples you need.

 

[Truusvlugindewind]

Only commercial RDBM's come with a COBOL-pre-processor. The ones I know:
- DB2 (not only mainframe, also OS2,windows,unix/linux)
- sybase
- oracle
- adabas-D

NetExpress4 (the IDE of Micro Focus) comes with XDB. This is a mainframe DB2 look-alike.

The open-source re-incarnation of adabas-D, MaxDB, dropped the COBOL-pre-compiler :-(

 

[fredericofonseca]

Informix also has one, and Progress

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com