From PowerBuilder to Ingres thru Sybase

[Natarajan. V. N.]

hi there,
i wld like some help in resolving this situation :
1. ingres 6.4/04 database, running abf on DEC-VAX (existing application)
2. pb4 application, including addtl tables on WinNT client (new dev - new db)
3. sybase system 10 SQL Server on HP-UX (available)

im planning to do :
1. new db on sybase
2. pb will talk only with sybase
3. all data rqmts, from the ingres db, will be handled by sybase
a. ingres DBProcs will be executed using RPC, from within sybase SPs
b. ingres tables will be accessed from within sybase SPs (dot notation)
<srvrname>.<dbname>.<owner>.<objname>.<fldname<
c. data updates on the ingres db will be thru Sybase

is this approach
i) Right iv) wont work vii) dont bother
ii) Wrong v) tell me if it works viii) others
iii) Dangerous vi) iv already burnt my fingers (please specify)

thanx in advance

btw, what is omniconnect ?

nvn

[Natarajan. V. N.]

hi there,
I have to add new functionalities to an existing Vax-Ingres application. The
new functionalities have to be done in WinNT-PB. Also there is a HP Server
with Sybase System 10 available on HP-UX.

For the addtl functionalities a new db has been created on Ingres. Also there
is need for accessing the existing db for query & update. Development in PB
is in progress using Intersolve's 16-bit ODBC driver.

Will the following idea work :
create the new database in Sybase on Hp-UX.
use Open-Client for communicating between PB & Syb.
use RPC for querying and updating the Ingres DB.

Can i access Ingres DBProc, Tables from within Sybase SP ?
Will the dot notation work inside the sybase ?
<server name>.<database name>.<owner name>.<table name>.<column name>

BTW what is omniconnect ?

thanx in advance

nvn

[Natarajan. V. N.]

[Natarajan. V. N.]

[Michael J. Smith]

Hello,

OMNIConnect is Sybase's main connectivity product. It is based
upon Open Server, and allows full read/write access to 25+
non-sybase data sources. It creates a system catalog that maps
the underlying non-sybase database/tables/records into Sybase SQL
Server compliant objects. Once this is done (using a supplied
utility) developers & users are totally unaware of where the
source data actual is located. Omni provides full location
transparency, and handles distributed joins and all of the
differences in language and data types behind the scenes.
You can dl info on Omni from the Sybase web site:
http://www.sybase.com

Regards,

Michael Smith, Sybase

[Richard E. Esposito]

<server name>...... only works for stored procedures NOT tables.

"omniconnect" used to be called "OmniSQL Open Server" --- It can be e.g.,
used to translate T-SQL to Ingres SQL and also map tables and attributes
between them.

On Thursday, June 06, 1996, Natarajan. V. N. wrote...