RE: Can I use store procedures in Informix.

But moving from from SQL to SPL is straightforward, the move to Java is a little harder:-)) Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > -----Original Message----- > From: Mike Segel [mailto:Postmaster@iiug.iiug.org] > Sent: Thursday, June 29, 2000 3:19 PM > To: informix-list@iiug.org > Subject: Re: Can I use store procedures in Informix. > > > Teddy, > I think he was more interested in SPL. > But you do bring up a valid point. Why write in SPL which is > specific to the > database vendor, rather than write to a common syntax that > should work with > the major RDBMS players. (Right now Oracle and Informix have > JVMs in the > engine, but I think IBM has it too. But hey, what do I know? :-P ) > > But I guess you're pushing the gun a bit. Going with Java > requires Foundation. > SPLs are already in there. For a small shop on a tight > budget, the cost of the > upgrade can be expensive. No? > > -Mikey > > > Ben Wilde wrote: > > > Ivan, > > > > You can also write Stored Procedures in Java with > Foundation.2000 (version > > 9.2 and above), you can get an eval from: > > > > http://www.intraware.com/informix > > > > ben. > > > > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message > > news:8jdj29$1nr$1@news.xmission.com... > > > > > > From: "Ivan V Canalejo" <ivan@ats-corp.com> > > > > > > > >I'm trying to find the equivalent of SQL store > procedures in Informix. > > > >Does anyone knows the answer.?? > > > > > > You mean like the Informix "CREATE PROCEDURE ..." > statement and the > > Informix > > > "EXECUTE PROCEDURE ..." statement? That are in the > manuals? That can be > > > found at http://www.informix.com/answers ? Like, > specifically, in the > > Guide > > > to SQL Syntax? Those stored procedures? > > > > > > Well, yes, but their underlying syntax is completely > different from that > > of, > > > say, SQL Server or Oracle. As they are different from each other. > > > > ______________________________________________________________ > __________ > > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.