Questions regarding sybase/oracle compatability
Date: Mon, 24 May 1993 19:11:23 GMT
Message-ID: <C7JpB3.LIn_at_cbnewsk.cb.att.com>
This is a clarification of a previous post. The first one was misleading. I am also cross-posting in hopes to get a reply.
I have a ~10,000 line report writer that currently goes against 2 DBMS's
(Sybase and Teradata). I Have been asked to impact the cost (in time)
of adding a third DBMS (ORACLE). It might be compiled without Sybase
or Teradata for some platforms (so we don't have to pay fees, etc.)
so I can't use products such as Sybase's OmniSQL Gateway, etc. I am
coding this myself.
I am aware of various SQL inconsistencies between Sybase and Teradata,
does anyone know how close Sybase and Oracle are for SELECT processing
(no updates, deletes, inserts)? I am talking syntax compatability!
I have browsed the "Programmer's Guide to the ORACLE Call Interfaces" and have identified what I believe are some sybase/oracle equivalents. Are any grossly wrong? Are there any major things I am missing. I ask this only so i can make a good estimate, i don't care about minor issues at this point. If you know the "???", please let me know the equivalent.
SYBASE ORACLE ------ ------ dblogin/dbopen orlon dbclose ologof dbcmd/dbfcmd/dbsqlexec oparse/oexec/oopen dbbind odefin (select only!) dbcollen/cbcoltype odescr dberrhandle oerhms dbmsghandle ??? dbnextrow ofetch dbnumcols ??? dbprtype ???
Thanks for any and all your help
-- Glenn Robitaille glennr_at_cbs1.acpy01.att.com or glennr_at_cbs1.attmail.comReceived on Mon May 24 1993 - 21:11:23 CEST
(908) 457-5072