MySQL

[sirragu]

I am currently using Micro Focus Server Express 5.0 on AIX 5.3. I am looking for some sample code for connecting, reading, writing, etc to a MySQL database. New to working with SQL from COBOL. What directives, environment variables, copybooks ( ie SQLCA, SQLDA...). Any help would be greatly appreciated.

Thanks in advance!

 

[ingresman]

Thers isn't a ESQL COBOL for mysql so I think SQLCA etc are out if the question.
I've never used mysql from COBOL but used MYSQL a fair bit. If there is an ODBC interface within the COBOL it shoud be straightforward but if not you might have to go the the CLI (Call Level Interface) level. I suggest you look at

http://www.kitebird.com/mysql-book/

where you can download the chapters from Paul DuBois book on callinf from C and the C function referecne.
Hope this helps !

 

[fredericofonseca]

I may be wrong, but I think someone was doing a COBOL/MYSQL interface sometime ago. search for it

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[dchristensen]

Couldn't you use the MySQL Connector/ODBC libraries to allow you to connect using ESQL? I've done that on Windows and it's worked fine.