05-27-2004 12:23 AM
Solved! Go to Solution.
05-27-2004 02:04 AM
-OpenClient (in SDK of Sybase)
-DbLib (in SDK of Sybase)
-jConnect (Sybase JDBC)
-Embedded SQL (Cobol, C)
jConnect and FreeTDS could be the best options. It may depend on what system your Sybase database is running (and what version)
OpenVMS Developer & System Manager
05-27-2004 03:37 PM
Calling any of these interfaces (ctlib, dblib, ODBC) from COBOL will require buying or building a layer that translates string descriptors into null-terminated C strings. I seem to remember Attunity has something like this with their ODBC client.
Attunity is not the only ODBC client vendor for VMS. There is also OpenRDA:
and I think EasySoft also has OpenVMS support:
I think all the commercial ODBC client vendors have their own service that runs on the target server, which in turn connects to the database. There are some architectural advantages to this, and some disadvantages. As far as cost and management complexity, there are only disadvantages.
Someone suggested embedded SQL. Even when Sybase was supported on VMS I don't think there were any precompilers for it. It's possible, though, that Attunity has something in that arena since given their architecture they would only have to do it once, not a different one for each database.