RE: Transparent Gateways

Hey Antal,

I just setup the RMS Transparent Gateway for some testing on an OpenVMS box. Ick. The documentation is VERY sparse and confusing at best. Metalink contains a ton of stuff on very little on the Oracle Gateways And I never did find any examples of how to properly make use of RMS indexes.

However, when I did get it to go, it worked very well for what I needed, albeit there was a bit of an NLS_DATE problem with a DECODE(TO_CHAR(datefield,'MMDDYYYY')...) returning a 2000-year date when it was supposed to be a 1900-year.

All I can say is "Good Luck!".

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Tarkanyi Antal [mailto:tantal_at_nagev.hu]
> Sent: Wednesday, December 13, 2000 07:36
> To: Multiple recipients of list ORACLE-L
> Subject: Transparent Gateways
>
>
> Hi !
>
> I would like to import data from heterogeneous datasources
> into Oracle8i
> (odbc, dbf,...)
>
> Is there anybody out there who knows the "Transparent
> Gateways" or knows
> some better solution ?
>
> I found some information about this on :
> http://technet.oracle.com/products/rdb7/htdocs/fs_gwys.htm
>
> but How can I use this, do I need to install some product to
> use this ?
> or this is a part of Oracle8i ?
> Would you be so kind to send me more information about this
>
> >>The Rdb Transparent Gateways to PC Data provides customers with the
> ability to access client-based data sources. This access is
> >>ODBC-based and
> includes all the popular client data sources such as MS
> Access, Excel, dBase
> and SQL Server.
>
>
> Thank you in advance!
> Antal Tarkanyi

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Wed Dec 13 2000 - 11:33:32 CST