Questions regarding sybase/oracle compatability

From: glenn.robitaille <glennr_at_cbnewsk.cb.att.com>
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.com

(908) 457-5072
Received on Mon May 24 1993 - 21:11:23 CEST

Original text of this message