Hi, I'd like to precise my questions, because I got more information ! I read in MaxDB documentation that theses schemas didn't exist in MaxDB : database link, package, rollback segment, snapshot, tablespace.
However, they are quite important for my applications, so I'd like to know if these is something in MaxDB to replace them, or at least to avoid needing them. Thanks, L�na > Hi, Excuse my english. I wanted to say : > Procedure : Many IN and/or Many OUT parameters and no return value. > (CREATE DBPROC in MaxDB) > Function : only IN parameters but returns a value. (CREATE FUNCTION in > MaxDB and PostgreSQL) > In this sense only, procedures does'nt exist in PostgreSQL, but since > PostgreSQL 7.4, functions can returns VOID. > I thing that stored procedures are very usefull in MaxDB AND PostgreSQL > and it's a very good thing that > functions are coming with MaxDB. > I'm working with PostgreSQL 7.4 at work and with SAP-DB 7.4 at home and > stored procedures gime me power with this 2 products ! > > Damien. > > > Anhaus, Thomas a �crit: > >>Vinod Kumar Singh wrote : >> >> >> >>>Stored Procedures are available in PostgreSQL also and syntax is very >>>similar to Oracle. Stored Procedures in SAP DB are only for token >>>presence they does not give any power to developer, working with them >>> is >>>a great pain. >>> >>> >> >> >> >>>Vinod >>> >>> >> >>Hi Vinod, >>I must contradict your statement that Stored Procedures are only for >> token presence. >>We are working hard on improving Stored Procedures, Trigger and >> Functions, but >>of course we depend on input about the experience of the users. >>It therefore would be great if you could give me some examples, why >> working with Stored Procedures >>is a pain. >> >>Best Regards, >>Thomas >> >>-----Original Message----- >>From: news [mailto:[EMAIL PROTECTED] Behalf Of Vinod Kumar Singh >>Sent: Freitag, 16. Januar 2004 08:53 >>To: [EMAIL PROTECTED] >>Subject: Re: Functions of MaxDB >> >> >>Stored Procedures are available in PostgreSQL also and syntax is very >>similar to Oracle. Stored Procedures in SAP DB are only for token >>presence they does not give any power to developer, working with them is >>a great pain. >> >>Vinod >> >>GUITARD Damien wrote: >> >> >> >>>Hi, >>>Function are available in MaxDB (7.5) but not in actual SAP-DB (7.4). >>>-> CREATE DBFUNCTION and soon CREATE FUNCTION >>>(search CREATE DBFUNCTION in docs online) >>>Procedures are available in MaxDB and SAP-DB (and not in PostgreSQL). >>>-> CREATE DBPROC >>> >>>Damien >>>Toulouse (France) ;-) >>> >>>[EMAIL PROTECTED] a �crit: >>> >>> >>> >>>>Hi everybody, >>>> >>>>I want to switch from Oracle to MaxDB or PostgreSQL, but I must prepare >>>> a >>>>comparative document before chosing between the 2 of them. >>>> >>>>Do you know where I could find such information ? In the MaxDB >>>>documentation, I can find the Oracle functions that are not available >>>> in >>>>MaxDB, but they don't give the equivalent ! >>>> >>>>Thank you for answering, >>>> >>>>L�na >>>>Toulouse (France) >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> >> >> > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
