Anita, Employing a professional with a good understanding of UV & SQL notwithstanding, you can have a look at the documentation - available on the IBM website - www.ibm.com/software/data/u2 - which tells you how to write stored procedure for UV and what the limitations or alternatives to SPs are. In particular, see the chapter "Calling and Executing UniVerse Procedures" in the UCI.pdf
Also Brian Leach's knowledge base article on how to use SQL with UniOLEDB which might be helpful and also mentions using stored procedures in UV (I can't access the original PDF so I have put the Google cache link in) : http://72.14.253.104/search?q=cache:auRSGA6JCYgJ:www.mvopen.org/kb/uploa d/kb3.pdf+ibm+universe+sqlref&hl=en&ct=clnk&cd=1 Regards, Stuart >-----Original Message----- >1)Whether we can create stored procedures,functions in this multivalued >database system as we create in SQL.How do we create because it doesnot >recognize SQl keywords to create procedure,But it executes simple DDL and >DML commands.I had put forth some of my queries in the discussion forum >about the same....there I got a reply stating that all application logic is >written within the database engine.If it is so then how is it written in >the database engine ....is it by Universe Basic language(which I am not >aware off)or any other way.Please help me out to avoid all these >confusions. > >2)I had worked in an application having Delphi as the front end and SQL at >the backend ...its a simple design....But when we have Delphi at the front >end and Universe Basic at the Backend,can we create the stored procedures >at the backend or it has to be handled from the front end or any other way >to create and execute the stored procedures and stored functions in >Universe Basic Data base.Please suggest some links or sites which can help >me to smoothly understand Universe Basic.Thanks >Thanks and Regards >Anita ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
