[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:	DEC Rdb against the World

Moderator:	HERON::GODFRIND

Created:	Fri Jun 12 1987
Last Modified:	Thu Feb 23 1995
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1348
Total number of notes:	5438

1081.0. "Dynamic SQL, Oracle vers. Rdb" by BYENG0::UFRASCH (Ursula Frasch , MI DCC Eng, Munich) Thu Feb 06 1992 09:37

Hi,

Does anybody know the difference between dynamic SQL with Rdb and Oracle? I read
somewhere that their concepts/implementations are quite different.

I am currently starting a conversion project from Oracle to Rdb where the
customer uses quite heavily Oracle's dynamic SQL.

Ursula.

T.R Title User Personal
Name Date Lines

1081.1 Two differences VNASWS::LOBSANG A good bug is hard to find Thu Feb 06 1992 10:33 12

T.R	Title	User	Personal Name	Date	Lines
1081.1	Two differences	VNASWS::LOBSANG	A good bug is hard to find	`Thu Feb 06 1992 10:33`	12
	One difference is that with ORACLE you have to know at compile time the maximum amount of cursors that you will need/use. With Rdb this restriction does not exist (anymore). Furthermore, the image that is created when using ORACLE is a based image. In the liker options file that ORACLE uses, the SGAPAD (ORACLE's System Global Area) reserves the base address 500. This could lead to problems depending on the application. Lobsang Gyalpo

One difference is that with ORACLE you have to know at compile time
the maximum amount of cursors that you will need/use. With Rdb this
restriction does not exist (anymore).

Furthermore, the image that is created when using ORACLE
is a based image. In the liker options file that ORACLE
uses, the SGAPAD (ORACLE's System Global Area) reserves the base
address 500. This could lead to problems depending on the application.

Lobsang Gyalpo