Yes it is possible. We do it.
The tools we use are now obsolete. But I am sure there are newer tools
available. We use the Oracle Gateway (obsolete) and PROCOBOL (I think also
obsolete). The SQL queries generated by the PROCOBOL portion of the COBOL
code queries information from Oracle. The COBOL program then writes the
information to a VPlus screen just like any other data.
I know there are several tools which will allow COBOL to do SQL queries. In
combination with any data gateway, ODBC, or other such technology this
should get the information into the program.
I see you did not actually specify programming language. Or if your
Image/VPlus application is written in some other language besides COBOL, I
am sure most languages will have something available to provide SQL
interfaces.
-----Original Message-----
From: Paul H. Christidis [mailto:[log in to unmask]]
Sent: Monday, July 07, 2003 5:02 PM
To: [log in to unmask]
Subject: Re: Accessing MS SQL server or ORACLE database from the HP3K
Folks,
One small clarification to my previous question:
We are not trying to migrate our IMAGE data to another platform. We are
trying to provide an enhancement where data that already exist in a
database on another platform can be viewed, extracted and used to
"complete" an existing entry in the IMAGE database, thus eliminating the
need for the user to manually 're-enter' the data.
Regards
Paul Christidis
===========================================================================
===
Folks,
I was asked the following question today and decided to turn to your
collective wisdom:
Is there a way for an IMAGE/VPLUS based application to connect, extract,
and present to the user (based on his input) data residing on an MS SQL
server or an ORACLE database on a different host?
What tools would one need in order to accomplish the above?
Regards
Paul Christidis
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
